Page 410

1. The ABC Car Service & Repair Centers are owned by the SILENT car dealer; ABC services and repairs only SILENT cars. Three ABC Car Service & Repair 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 the manager of one of the centers 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.

1. Obtain a general description of company operations
2. Interview the shop manager
3. Interview the mechanics.
4. Create a description of each system process
5. Draw a data flow diagram and flowcharts.
6. Create a conceptual model using ER diagrams
7. Normalize the conceptual model
8. Create the file (table) structures.
9. Load the database
10. Create the application programs
11. Test the system

b. Describe the various modules that you believe the system should include.

Car Configuration: this module will contain the different types of cars SILENT services and their configurations. The cars will be uniquely identified with part of a Vehicle Identification Number (VIN). Each car has a configuration of types of parts that make it up as well as recommended servicing.
Inventory: this module will track the SILENT shop’s inventory of parts, which is tied into the car configuration module.