Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
1. The ABC Car Service & Repair Centers are owned by the Silent Car Dealerships 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.

1. The ABC Car Service & Repair Centers are owned by the Silent Car Dealerships 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.

Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter17: Markov Chains
Section: Chapter Questions
Problem 14RP
See similar textbooks
icon
Related questions
Question

Please solve d,e,f

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. 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.
Transcribed Image Text: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. 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?
Transcribed Image Text: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?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Data Modeling Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS