Design Approaches Need to come up with a methodology to ensure that each of the relations in the database is "good" Two ways of doing so: Entity Relationship Model(Chapter 7) Models an enterprise as a collection of entities and relationships Represented diagrammatically by an entity-relationship diagram: Normalization Theory (Chapter 8) Formalize what designs are bad,and test for them Database System Concepts-6th Edition 1.18 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 1.18 ©Silberschatz, Korth and Sudarshan th Edition Design Approaches Need to come up with a methodology to ensure that each of the relations in the database is “good” Two ways of doing so: Entity Relationship Model (Chapter 7)  Models an enterprise as a collection of entities and relationships  Represented diagrammatically by an entity-relationship diagram: Normalization Theory (Chapter 8)  Formalize what designs are bad, and test for them