Difference between revisions of "Exemplar System: Database Tables"

From Yacapaca wiki
Jump to: navigation, search
(Created page with '__NOTOC__ The database will need 3 tables linked by relationships so that the data can be used effectively. Each table will contain fields that hold particular data that is rele…')
 
(No difference)

Latest revision as of 13:17, 3 August 2009

The database will need 3 tables linked by relationships so that the data can be used effectively.

Each table will contain fields that hold particular data that is relevant to the system. These are shown below.

CDs Table

Cd table2.jpg

Customer Table

Customer table.jpg

Borrowed CDs Table

Borrowed cds.jpg

There are two primary key fields in the Borrowed CDs table to prevent:

  • a CD apparently being booked out twice during the same period of time.
  • a customer borrowing more than one CD at a time (this is what Mr Smith wants).