Database Systems, 13e Module 9 Problem 1
Coronel/Morris
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, complete A through
F below. Once you have completed answering the questions, save your file with your
last name in the file name.
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.
___________ Obtain a general description of company operations.
___________ Load the database.
___________ Create a description of each system process.
___________ Test the system.
___________ Draw a data flow diagram and system flowcharts.
___________ Create a conceptual model using ER diagrams.
___________ Create the application programs.
___________ Interview the mechanics.
___________ Create the file (table) structures.
___________ Interview the shop manager.
B. Describe the various modules that you believe the system should include.
C. How will a data dictionary help you develop the system? Give examples.
D. What general (system) recommendations might you make to the shop
manager? What benefits would be derived from such an integrated system?
Include several general recommendations.
E. What is the best approach to conceptual database design? Why?
F. Name and describe at least four reports the system should have. Explain
their use. Who will use those reports?