1 / 9

Relational Database Design and Mapping for COMPANY Database

Learn how to map ER conceptual schema into relational schema, handle n-ary relationship types, and specialize or generalize using various options. Explore EER specialization lattice and categories mapping techniques.

afontenot
Download Presentation

Relational Database Design and Mapping for COMPANY Database

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 7 Relational Database Design by ER- and EER-to-Relational Mapping

  2. FIGURE 7.1The ER conceptual schema diagram for the COMPANY database.

  3. FIGURE 7.2Result of mapping the COMPANY ER schema into a relational schema.

  4. FIGURE 7.3Mapping the n-ary relationship type SUPPLY from Figure 4.11a.

  5. FIGURE 7.4Options for mapping specialization or generalization.(a) Mapping the EER schema in Figure 4.4 using option 8A. (b) Mapping the EER schema in Figure 4.3b using option 8B. (c) Mapping the EER schema in Figure 4.4 using option 8C. (d) Mapping Figure 4.5 using option 8D with Boolean type fields Mflag and Pflag.

  6. FIGURE 7.5Mapping the EER specialization lattice in Figure 4.6 using multiple options.

  7. FIGURE 7.6Mapping the EER categories (union types) in Figure 4.7 to relations.

  8. FIGURE 7.7An ER schema for a SHIP_TRACKING database.

More Related