Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

Accounting Information Systems And Internal Control

Authors: Eddy Vaassen, Roger Meuwissen, Caren Schelleman

2nd Edition

0470753951, 9780470753958

More Books

Students also viewed these Accounting questions