Table Design, Primary Keys and Relationships

When you begin a database, you need to start backwards--at the end of the process--and analyze the final product. In some databases, the final report may be an insurance claim form. In others, it may be an engineering status report. The Front Row Video database is a simple business model: Who bought what? The final product is a receipt that prints the names of the movies and the rental price. The Receipt Form design will be presented in two lessons: Tables and Forms. In the following lessons, the data captured by the Receipt Form will be queried and formatted for print.

 

How should the Receipt Tables be designed? What are the relationships?

 

Microsoft Office Access 2010: Example of the Relationships in a Database