Erd To Track Sales Transactions Or Viet Inuong Music Viet Thuong Music Inc Is A Musical Instrument Retailer The Comp 1 (48.21 KiB) Viewed 28 times
Erd To Track Sales Transactions Or Viet Inuong Music Viet Thuong Music Inc Is A Musical Instrument Retailer The Comp 2 (22.13 KiB) Viewed 28 times
ERD to track sales transactions or viet inuong music. Viet Thuong Music, Inc. is a musical instrument retailer. The company buys musical instruments from different suppliers and then sells them to their customers. Currently the company manages its sales data using MS Excel. Since the business of Viet Thuong Music is booming, it decides to use MS Access database to track its sales transactions. 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 track employees' performance in terms of profit amount per sales transaction against employees' monthly profit target. Propose an update to the database design (e.g adding new fields to existing tables) to capture the required Information. Briefly explain how the monthly profit performance of each employee can be retrieved and compared against their profit target with the new database design 1
Customer CIO DO La Phone he A. wed D Salentin STO CO D Pro Ged Tinna A W CI COM + Sures were A
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!