Part II · Conceptual and logical design¶
The second partial exam: the Entity-Relationship model, from reading a schema to drawing one from requirements or from an existing relational schema, then the step to tables, with the analysis of redundancies that comes before it.
| Topic | Exercise |
|---|---|
| Conceptual design | Reading E-R schemas |
| Conceptual design: first schemas | |
| Conceptual design: exam questions | |
| Reverse engineering: from relational schema to E-R | |
| Logical design | Redundancy analysis |
| Logical design: from E-R to tables |