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

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. image text in transcribed 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.Flee

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

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions

Question

Provide examples of Dimensional Tables.

Answered: 1 week ago