Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Case Description For this assignment you are going to continue working on the database from Marcia s Dry Cleaning. Below is current Invoice that displays
Case Description
For this assignment you are going to continue working on the database from Marcias Dry Cleaning.
Below is current Invoice that displays some of the data stored in the database.
With regards to orders, all orders must have at least one item on them. All orders need to show which
employee took the order along with who completed a service on the order. Not all employees will take
orders and not all employees will complete orders. Finally, not all services will be on orders.
When describing services, the database needs to store the name of the service, its description, and the
cost of that service. Additionally, it needs to store the category for each service. There are many
different categories. Such as pants, shirts, coats, suits, wedding dresses, dresses and other. The other
category describes items brought in that do not fit the categories mentioned. Marcia wants to create
reports showing which categories sell the most. Therefore, the category names need to be uniform to
ease with searching. For instance, Marcia doesnt want the shirts category to include data such as dress
shirt, short sleeve shirt, long sleeve shirt, etc. Not all categories will be in services.
Page of
For customers, a customer can exist in the database without being associated with an order. The
database needs to store the names of customers, along with their contact information and when they
became a customer at Marcias Contact information includes address, city, state, zip, phone and email.
The database also needs to keep track of Employees. Specifically, the database needs to store
information about the employees name, contact information, date of birth, social security number, date
hired, and date terminated.
Finally, Marcia will need to run the following reports:
Sales Report displays the category of the items sold and the amount. This report is ran weekly,
monthly, quarterly and yearly
Employees With Services displays the name of the employee and the total number of services
they completed
Customer Total Orders displays the name of the customer and the total they spent. This report is
run monthly, quarterly and yearly.
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