• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

3. Implementing Entity-Relationship Mode... > 3.4. The LIBRARY Relational Database

The LIBRARY Relational Database

We can now complete the implementation of the LIBRARY relational database (without the Contributors entity class) in Microsoft Access. If you open the LIBRARY database in Microsoft Access, you will see four tables:

  • AUTHORS

  • BOOK/AUTHOR

  • BOOKS

  • PUBLISHERS

(The LIBRARY_FLAT table is not used in the relational database.)

These four tables correspond to the following four entity classes (or table schemes):

  • Authors (AuID, AuName, AuPhone)

  • Book/Author (ISBN, AuID)

  • Books (ISBN, Title, PubID, Price)

  • Publishers (PubID, PubName, PubPhone)

The actual tables are shown in Tables Table 3-3 through Table 3-6.

Table 3-3. The AUTHORS table from the Access LIBRARY database

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint