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 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 doesn$$t 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 $2$ of $3$

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 Marcia$$s$.$ 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 employee$$s 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.