Instructions:

Given the diagram $($entities$,$ relationships, and

cardinalities$)$ and the table below $($at the end

of the assignment$)$ determine which tables

the foreign keys go in and determine the

primary key of the relationship table.

Then, create, in Access, non$-$redundant

relational database in access to include:

Table Structure consistent with the

information needs and database design issues.

Tables and fields defined as suggested below

and populated with limited data $(<mn\; id="EditorElement\_2460048">3</mn>$ records

in each table will do$,$ relationship tables may

have more records$).$