1. The ABC Car Service & Repair Centers are owned by the Silent Car Dealership; ABC services and repairs
only silent cars. Three ABC centers provide service and repair for the entire state.
Each of the three centers is independently managed and operated by a shop manager, a receptionist,
and at least eight mechanics. Each center maintains a fully stocked parts inventory.
Each center also maintains a manual file system in which each car’s maintenance history is kept: repairs
made, parts used, costs, service dates, owner, and so on. Files are also kept to track inventory,
purchasing, billing, employees’ hours, and payroll.
You have been contacted by one of the center’s managers to design and implement a computerized
database system. Given the preceding information, do the following:
a. Indicate the most appropriate sequence of activities by labeling each of the following steps in the
correct order. (e.g., if you think that “Load the database” is the appropriate first step, label it “1.”)
Normalize the conceptual model.