1 / 16

Table Relationships

Table Relationships. 11 examples of tables and relationships. Tables. Remember that tables are lists of records. Customer Table . Tables. Remember that tables are lists of records. Customer Table .

conan-trevino
Download Presentation

Table Relationships

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. Table Relationships 11 examples of tables and relationships

  2. Tables • Remember that tables are lists of records. Customer Table 

  3. Tables • Remember that tables are lists of records. Customer Table 

  4. Relationship.Each customer may have many orders so there is a “1” to “many” link in the table relationships.

  5. Relationships • For example, each student can be linked to several classes through a schedule table.

  6. 1. School schedule system

  7. 2. Store sales system

  8. 3. Persona CD collection database

  9. 4. Hospital patient records

  10. 5. Video library loan system

  11. 6. Library circulation system

  12. 7. Doctor appointment database

  13. 8. Mechanic / Garage system

  14. 9. Store order system

  15. 10. College student address book

  16. 11. Bookstore sales system

More Related