Database Design: Create the ER diagram using MS Visio. Be sure to include table names, primary $/$foreign key fields, attributes, relationships, crow$$s feet notation, and minimum$/$maximum cardinalities. Minimum of $4$ attributes per table

Database Application: Create the matching Access database using the ER diagram that you just created. Be sure to include table names, primary$/$foreign keys, attributes, field descriptions where applicable, and relationships setting referential integrity. Add at least $5$ records to each table.

Create two queries. Make sure that each contains either a criterion to refine the search data or a function that computes a value. Be sure to name these queries with a descriptive name as well. Make sure the queries pull from multiple tables.

Uniqueness: In one of your queries you must add a field that shows the current date along with your StudentID. Enter the following into the last field in one of your queries: Uniqueness: Now$()$ & $"$ STUNAM$1234"($where STUNAM$1234$ is your studentID$).$

Create one report based on one of your queries. You may choose the type of design.

Upload your Visio ER diagram $(.$vsdx$)$ and Access database $(.$accdb$)$ files for grading using the submission instructions below.