“Creating a Database and Analyzing its Structure and Functionality” 1. Analysis of Database and ER-Diagram The database that I have created is a customer management system for a retail store. The purpose of this database is to store and

You will create a Database in the DBMS of your
choosing (recommendation: Microsoft Access), which will include the following items:
1.     A
analysis of your database and ER-diagram (minimum 500 words).
2.     An
ER diagram (using either Chen or Crow’s Foot Notation)
3.     A
normalized database that includes a minimum of four
database tables, two relationships, five queries, the SQL code for your
queries, and three reports.