Database Answers Bienecke Rare Book Library, Yale University.

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Home Libraries
An Access Database is available on demand, and here is the Data Model of the Access Database.

The User Requirements have been drafted.

If you are new to Databases, this page of my Tutorial will help you understand the Data Model.

Home Libraries Data Model

This diagram shows Inheritance, with Sub-Types of Books, DVDs and Magazines, etc. inheriting attributes from the 'Catalogue' Super-Type.

The diagram of an Access Database shows how this might look in a physical Database, where all the Sub-Types attributes are combined into one consolidated Table.



Barry Williams
22nd. December 2007
Principal Consultant
Database Answers.org

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map