Microsoft Access Assignment $1(50$ Points$)$

$$

Create a relational database in MS Access for the following UML class diagram.

$$

$$

Steps:

$1.$ Name the database as A$1\_$your name $(6$ points$)$

$2.$ Create tables for Person, Auto, Dealers and State $(4$ points$)$

$3.$ Enter attributes for each table and choose appropriate data types and properties $(16$ points$)$

Person $[$Person$\_$ID$,$ Person$\_$Name$]$

Auto $[$Auto$\_$ID$,$ Auto$\_$Manufacturer, Auto$\_$Model, Auto$\_$Model$\_$Year, Person$\_$ID$,$ State$\_$Abbrev$]$

Dealers $[$Dealer$\_$ID$,$ Dealer$\_$Name$]$

State $[$State$\_$ Abbrev, State$\_$Name$]$

$$

$$

$4.$ Identify correct primary keys $(4$ points$)$

$5.$ Create the relationships based on the UML diagram $(20$ points$)$

Hint: a linking table is needed for many$-$to$-$many relationships