Database Tips(Repost)

Database tips(old tips) repost

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 language, but data manipulation language)
-"join" is included.
-Refer SQL slide.

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