InitHEADmain

1 files changed, 21 insertions, 0 deletions

diff --git a/Homework/cs5800/Exams/1.org b/Homework/cs5800/Exams/1.org
new file mode 100644
index 0000000..51d2fc1
--- /dev/null
+++ b/Homework/cs5800/Exams/1.org
@@ -0,0 +1,21 @@
+* EER and relational (notations, translation, ER -> EER)
+* Languages (DML - DBA or User, DDL - , VDL, SDL)
+* DBMS system components
+User queries and DDL queries paths
+* Conceptual Data Modeling (Focus on min-max) (ER and Enhanced ER model)
+Partial participation, categorization on unions,
+convert to integrity constraints
+
+non-null is an entity integrity constraint
+* Relational model concepts
+** Keys
+(Super key, candidate key, primary key, foreign key)
+studentno is a key, {studentno, birthdate} is a superkey
+sometimes there is more than one key
+* Data Definition Language (DDL)
+** Creating table, adding constraints, table attrributes
+** DBA uses
+** Attributes, primary keys, foreign keys
+
+** Drop table, Alter table
+** Constraints: null/not null, unique, CHECK