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.