Question
ERD to track sales transactions of House Appliances Specialist. House Appliances Specialist, Inc. is a household appliance retailer. The company buys small appliances from different
ERD to track sales transactions of House Appliances Specialist.
House Appliances Specialist, Inc. is a household appliance retailer. The company buys small appliances from different suppliers and then sells them to their customers. Currently the company manages its sales data using MS Excel. Since the business of House Appliances Specialist 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 : Use this ERD to briefly explain the main purposes of the Access database, then discuss 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 : 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.
Step 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