111 12 13 14 15 16 17 4 5 6 7 8 Eltronics R' Us are a growing business that sells electronic goods. To improve the track

[answerhappygod]

111 12 13 14 15 16 17 4 5 6 7 8 Eltronics R Us Are A Growing Business That Sells Electronic Goods To Improve The Track 1 (89.07 KiB) Viewed 21 times

111 12 13 14 15 16 17 4 5 6 7 8 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. Announcements Syllabus Account Your tasks: Tasks 1 (2 marks): Use this ERD to explain what information is stored (tables and fields) and how the information from Dashboard different tables is related (entity relationships) so that the database can store necessary information and facilitates efficient Assignments 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. Emolyes Employee Leyte Userne Password Role Company Address Tele Business Phone Phone Farbe More Sales Sol Dale END Cust TIL + Sale Details 7 Sat, Po Customers 7 Custom Customer Name Robe Business F Statin Postal Code County Region Rates Products CRY State DPPC Country Member hedust Dration Category im Un Attachment Attached ha ante Mala Member