From 6bf4b90c90f15f4ab60833bddf5b5756d1a6b1f6 Mon Sep 17 00:00:00 2001 From: Elizabeth Alexander Hunt Date: Thu, 2 Jul 2026 11:55:17 -0700 Subject: Init --- Homework/cs5800/Exams/1.org | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 Homework/cs5800/Exams/1.org (limited to 'Homework/cs5800/Exams/1.org') 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 -- cgit v1.3