Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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 database's 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. Sales Sales ID Sales Date Emo_ID Cuitto 81 8L Employees Employee ID Employee Name User Name Password Role Company E-mail Address Job Title Business Phone Home Phone Fax Number Address City State/Province ZIP/Postal Code Country/Region Notes Sale Details ID Sale 10 Pro ID 8181 Customers Customer 10 Customer Name Job Title Business Phone Fax Number Address City State Province ZIP Postal Code Country Region Member Products Pro 10 Product Description Category Amount Unit Price Attachments Member Menu Sales Sales ID Sales Date Emp_3D Cust 10 8T8L Employees Employee ID Employee Name User Name Password Role Company E-mail Address Job Title Business Phone Home Phone Fax Number Address City State/Province ZIP/Postal Code Country/Region Notes Sale Details VID Sale_ID Pro ID 81 81 Customers * Customer 10 Customer Name Job Title Business Phone Fax Number Address City State/Province ZIP Postal Code Country/Region Member Products POID Product Description Category Amount Unit Price Attachments Attachments.FileData Attachments.FileName Attachments.FileType Member Member ID Member

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Microsoft SQL Server 2012 Programming

Authors: Paul Atkinson, Robert Vieira

1st Edition

1118102282, 9781118102282

More Books

Students also viewed these Databases questions