Database Tips

Structured Question:

ERD - enhancement(ERM)

Logic Database Design (conversion from conceptual to logical)
- Conversion from conceptual to logical
- Write relation scheme

Normalization(15%)
1NF, 2NF, 3NF

SQL Statement
(no data definition, but data manipulation)
-"join" is included.
-Refer SQL slide from slide 3 to 5.

Case Study(total = 25%)
- (ER diagram - draw)(13%)
- write relational scheme(12%)

Normalization Exercise (Answer)