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. __________ 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? For example, if the system will be integrated, what modules will be integrated? 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?

BuyFind

Database Systems: Design, Implemen...

11th Edition
Steven + 8 others
Publisher: Cengage Learning
ISBN: 9781285196145
BuyFind

Database Systems: Design, Implemen...

11th Edition
Steven + 8 others
Publisher: Cengage Learning
ISBN: 9781285196145

Solutions

Chapter
Section
Chapter 9, Problem 1P
Textbook Problem

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:

  1. 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.”)
    1.   __________ Normalize the conceptual model.
    2.   __________ Obtain a general description of company operations.
    3.   __________ Load the database.
    4.   __________ Create a description of each system process.
    5.   __________ Test the system.
    6.   __________ Draw a data flow diagram and system flowcharts.
    7.   __________ Create a conceptual model using ER diagrams.
    8.   __________ Create the application programs.
    9.   __________ Interview the mechanics.
    10.   __________ Create the file (table) structures.
    11.   __________ Interview the shop manager.
  1. b. Describe the various modules that you believe the system should include.
  2. c. How will a data dictionary help you develop the system? Give examples.
  3. d. What general (system) recommendations might you make to the shop manager? For example, if the system will be integrated, what modules will be integrated? What benefits would be derived from such an integrated system? Include several general recommendations.
  4. e. What is the best approach to conceptual database design? Why?
  5. f. Name and describe at least four reports the system should have. Explain their use. Who will use those reports?

Expert Solution

Want to see the full answer?

Check out a sample textbook solution.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
A______ can be used to measure cutting fluid concentrations.

Precision Machining Technology (MindTap Course List)

What is the latest projection of the U.S. Census Bureau for the world population?

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

What is a functional decomposition diagram (FDD) and why would you use one? Explain how to create an FDD

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

Determine the resultant of the four forces.

International Edition---engineering Mechanics: Statics, 4th Edition

Do you have a screen saver configured on your computer or mobile device? If so, what does it look like?

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)