Assignment: Retail Company-- ERD Development
Marylyn Inc. has experienced tremendous growth over the past one year and top management thinks keeping data in a spreadsheet format has many drawbacks. These include minimizing data redundancy, data inconsistency, and data isolation and maximizing data integrity, security, and independence. Top management has requested you to help the company expand its data capture and reporting capabilities by developing a relational database as a more functional structure.
Requirements:
1. Revisit the Customer Relations Spreadsheet you used in Assignment #1 and determine which tables need to be created.
2. Create the required tables.
3. Transfer the tables to a Microsoft Access Database.
4. Create an Entity Relationship Model using the MS Access Database Management System using the following rules.
a. A customer can place zero or more orders, but an order can be placed by one and only one customer.
b. A product can be requested by one or more orders, and an order can request one or more products.
c. A Sales Representative can serve one or more Customers, but a customer must be served by one and only one Sales Representative.
d. When you have a one to many relationship; place the primary key of the one side of the relationship into the many side of the relationship.
e. When you have a many-to-many relationship; create a bridge table whose composite key has one primary key from each of participating tables.
ITA#3: Database Development
Based on the ER Diagram you developed in ITA#2, you are requested to complete the following assignment:
a. Create a Main Form and Sub-Form for each one to many relationship.
b. Create a query that lists the total purchases by each customer.
c. Create a query that lists the total sales of each Sales Representative.
d. Create a report for the list of total purchases by each customer.
e. Create a report for the list of total sales by each Sales Representative.
f. Export the two reports generated in d. & e. above to an Excel Spreadsheet.
g. Use the knowledge you have gained in class to produce a graph and/or dashboard to present your report to top management. Write your observations on the spreadsheet.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Data.rar