Conceptual Model from Visio Solution is in attached PDF.
Now we are going to convert our conceptual model into a logical model. Using Microsoft Access perform the following steps:
1. For each entity listed in the Solution file create a table in Access
2. Add primary keys for each table.
3. Set column properties for unique constraints.
4. Update the datatype for your attributes to enforce the domain constraints of the data.
o Dates should have a date datatype
o Surrogate keys sh…
