Question
Eltronics R Us are a growing business that sells electronic goods. To improve the tracking of sales, improve customer service and increase loyalty, the business
Eltronics R Us are a growing business that sells electronic goods. To improve the tracking of sales, improve customer service and increase loyalty, the business would like to implement a database system. The image below shows the ERD of the proposed Access databases logical design. Your tasks: Tasks 1 (2 marks): Use this ERD to explain what information is stored (tables and fields) and how the information from different tables is related (entity relationships) so that the database can store necessary information and facilitates efficient data retrieval and updates. Task 2 (3 marks): the company wants to offer a discount rate to different customers; customers can only have one rate applied and is tied to their membership type. They would also like to track how many of each item is purchased is a sale. Propose an update to the database design (e.g adding new fields to existing tables) to capture the required information. Briefly justify your design choices.
Employees Employee Name User Name Sales Date to 10 Cust Sale Details Company Email Addres Job Title Business Phone Home Phone Customer Customer Customer Name Business Phone Fax Number State Province Postal Code Country Region State Province ZIP Postal Code Country Region Products 9 Pro Product Description Amount Unit Price Member Member Attachments.cat Atachments Feline Attachments.FleeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started