1. Who are the stakeholders for this database?

a. Group of answer choices

b. Marcia

c. Customers

d. Seamstresses (2)

e. Internet Service Provider

f. Chemical and Equipment Vendors

g. St. Vincent DePaul

h. Store Clerks (2)

i. Dry Cleaners (2)

2. For the first stakeholder you chose above, what access or privileges will they receive on the new database?

Group of answer choices

a. CREATE

b. DROP

c. READ

d. EDIT

3. For the third stakeholder you chose above, what access or privileges will they receive on the new database?

Group of answer choices

a. CREATE

b. DROP

c. READ

d. WRITE

4. For the fourth stakeholder you chose above, what access or privileges will they receive on the new database?

Group of answer choices

a. CREATE

b. DROP

c. READ

d. WRITE

5. Which of the following are business rules for this new database?

Group of answer choices

Customers have to first log their order on the web app before coming in to the store.

The seamstresses must initial each outgoing order.

Customers can exist in the database without placing an order.

Marcia inspects each order.

All orders must have one service on them.

Calls are made to customers who have not picked up their dry cleaning after 4 weeks.

An order can have no services specified on it.

Calls are made to customers who have not picked up their dry cleaning after 8 weeks.

Once an article of clothing is cleaned it goes to the seamstresses for mending.

Very dirty items are cleaned twice at no extra charge.

Clothing not picked up after 6 months is donated to St. Vincent DePaul.

Customers who spend more than $100 in one month get a 10% discount on their next cleaning bill.

Clothing items left at the store after 1 year can be taken home by the employees.

Marcia's Dry Cleaning Case Description Marcia's Dry Cleaning is an upscale dry cleaner in Clinton Twp. Since the competition is so fierce, she stands out from her competitors by offering superior customer service. Currently she keeps track of her customers in an Excel spreadsheet but has noticed that there are certain problems when trying to keep records in Excel. Namely she complains of multiple addresses and other contact information for her customers. Additionally, there are numerous mathematical errors on the orders and inconsistencies when applying coupons. She would like to develop a more robust system and needs your help. Marcia would like her database to do the following: Allow for easy entry, correction and deletion of their data Better report capabilities. More integrity when it comes to the data E-mail alerts when clothes are ready Special offers and coupons to repeat customers During your initial interview with Marcia you find out that she currently employs 6 people. There are 2 employees who assist customers and perform general duties, there are 2 seamstresses and 2 people who do all of the dry cleaning and are skilled on the operation of those very specific machines. The seamstresses and machine operators will only need to look up data if a question arises. The only employees that will need to change data are the two employees who will work with the customers directly. These employees are responsible for entering new customers, updating orders when they are completed, calling customers who have not picked up their dry cleaning in a while and entering new orders. The owner, Marcia will need full access to the database. She also needs to have the ability to query the database and run reports. It is not clear at this time what hardware or software Marcia's database will need. As customer's will not need to access the data in the database, there is no need to put the database on the Internet. The only deliverable the customer receives is an order number at that time they drop off their cleaning and a receipt showing payment when they pick up their order. In talking with Marcia, at some point she would like the application system with her new database to automatically send a text message when a customer's dry cleaning is done. But she can wait for that. At this point, the database and corresponding application will be on a few PC's and on a very small network. In looking at the types of data Marcia's new system will need to catalog and store, you determine that Marcia will need to keep track of her customers, the orders placed, the services available, the services performed and which employee performed those services. You also learn that there are some rules about the data she will need to store. For instance, customers do not need to have an order to be stored in the database. All orders must have at least one service on them. All orders must show which employee cleaned or mended an item. When an item has been cleaned and not picked after 4 weeks, a phone call must be made to the customer letting them know their item is ready. A second call is placed after another 4 weeks. If an item has been left in the store 6 months it is donated to St. Vincent DePaul's on VanDyke and 21 Mile. This is all specified on the order form and customers must agree to this policy before their clothes are taken for dry cleaning. Finally, customers who spend $100 in one month get their next dry- cleaning bill discounted at 10%