Current state: An auto repair shop accepts appointments from customers as well as walk-ins when there is some slack.

Desired future state: It wants to:

- add stores across several neighboring states; and

- roll out an Internet-based service that will track customers' cars and offer a 24x7 on-road emergency assistance in those states plus the guarantee of towing to the nearest store and same-day diagnostics with follow-up repair when feasible.

- It proposes to attain the future state with the help of a brand-new information system shared by all the stores.

---------

Your task:

A. For the current state, create an Entity-Relationship (ER) diagram that captures as much as possible of the requirements regarding

- Parts, suppliers, internals of auto models, mechanics, customers, repair bays, and diagnostic instruments /special-purpose computers.

B. For the current state, draw a logical Data Flow Diagram (DFD) capturing

- the process of a customer/patient arriving for an appointment and being serviced by an appropriate technician;

C. For the current state, give two applications of database triggers. Explain which table a trigger would be defined on, what the trigger would respond to and what would be its action(s).

D. For the current state, describe three controls that would help minimize fraud and error: explain the idea, outline a control plan, identify control goal(s) for which you claim it would be effective, and justify your claim.

E. For the future state, explain how each of the following would be useful. For each, give an executive summary regarding its utility and impact (as well as technical details --- the level of detail should be that we have seen in the class. (For example, you need to make clear the structure and content of the table using which association rules would be mined.) The executive summary should enable the CEO to convince the CFO to allocate funds. The technical details should enable the CTO to certify the feasibility of the idea.

i. a data warehouse

ii. data mining leading to association rules

iii. a decision tree constructed using the C4.5 algorithm

iv. clustering using the k-means algorithm

F. Identify the most important ethical issue that would become relevant in the future state. Argue both in favor of ignoring it and for taking (potentially expensive) steps to address it.