Copyright 2004 Pearson Education Inc Chapter 3 Data Modeling Using the Entity Relationship Model Copyright 2004 Pearson Education Inc FIGURE 3 1 A simplified diagram to illustrate the main phases of database design Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 3 FIGURE 3 2 An ER schema diagram for the COMPANY database Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 4 FIGURE 3 3 Two entities employee e1 and company c1 and their attributes Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 5 FIGURE 3 4 A hierarchy of composite attributes Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 6 FIGURE 3 5 A complex attribute AddressPhone Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 7 FIGURE 3 6 Two entity types EMPLOYEE and COMPANY and some member entities of each Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 8 FIGURE 3 7 The CAR entity type with two key attributes Registration and VehicleID Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 9 FIGURE 3 8 Preliminary design of entity types for the COMPANY database Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 10 FIGURE 3 9 Some instances in the WORKS FOR relationship set which represents a relationship type WORKS FOR between EMPLOYEE and DEPARTMENT Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 11 FIGURE 3 10 Some relationship instances in the SUPPLY ternary relationship set Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 12 FIGURE 3 11 A recursive relationship SUPERVISION between EMPLOYEE in the supervisor role 1 and EMPLOYEE in the subordinate role 2 Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 13 FIGURE 3 12 A 1 1 relationship MANAGES Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 14 FIGURE 3 13 An M N relationship WORKS ON Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 15 FIGURE 3 14 Summary of the notation for ER diagrams Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 16 FIGURE 3 15 ER diagrams for the COMPANY schema with structural constraints specific using min max notation Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 17 FIGURE 3 16 The COMPANY conceptual scheme in UML class diagram notation Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 18 FIGURE 3 17 An ER diagram for an AIRLINE database schema Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 19 FIGURE 3 18 An ER diagram for a BANK database schema Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 20 FIGURE 3 19 Part of an ER diagram for a COMPANY database Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 21 FIGURE 3 20 Part of an ER diagram for a COURSES database Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 3 22
View Full Document
Unlocking...