1 / 22

Chapter 3

Chapter 3. Data Modeling Using the Entity-Relationship Model. FIGURE 3.1 A simplified diagram to illustrate the main phases of database design. FIGURE 3.2 An ER schema diagram for the COMPANY database. FIGURE 3.3 Two entities, employee e 1 and company c 1 , and their attributes.

tiger-byers
Download Presentation

Chapter 3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Chapter 3 Data Modeling Using the Entity-Relationship Model

  2. FIGURE 3.1A simplified diagram to illustrate the main phases of database design.

  3. FIGURE 3.2An ER schema diagram for the COMPANY database.

  4. FIGURE 3.3Two entities, employee e1 and company c1, and their attributes.

  5. FIGURE 3.4A hierarchy of composite attributes.

  6. FIGURE 3.5A complex attribute: AddressPhone.

  7. FIGURE 3.6Two entity types, EMPLOYEE and COMPANY, and some member entities of each.

  8. FIGURE 3.7The CAR entity type with two key attributes, Registration and VehicleID.

  9. FIGURE 3.8Preliminary design of entity types for the COMPANY database.

  10. FIGURE 3.9Some instances in the WORKS_FOR relationship set, which represents a relationship type WORKS_FOR between EMPLOYEE and DEPARTMENT.

  11. FIGURE 3.10Some relationship instances in the SUPPLY ternary relationship set.

  12. FIGURE 3.11A recursive relationship SUPERVISION between EMPLOYEE in the supervisor role (1) and EMPLOYEE in the subordinate role (2).

  13. FIGURE 3.12A 1:1 relationship, MANAGES.

  14. FIGURE 3.13An M:N relationship, WORKS_ON.

  15. FIGURE 3.14Summary of the notation for ER diagrams.

  16. FIGURE 3.15ER diagrams for the COMPANY schema, with structural constraints specific using (min, max) notation.

  17. FIGURE 3.16The COMPANY conceptual scheme in UML class diagram notation.

  18. FIGURE 3.17An ER diagram for an AIRLINE database schema.

  19. FIGURE 3.18An ER diagram for a BANK database schema.

  20. FIGURE 3.19Part of an ER diagram for a COMPANY database.

  21. FIGURE 3.20Part of an ER diagram for a COURSES database.

More Related