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 atleast 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 pay roll.You have been contacted by one of the centre's manager to design and implement a computerized data base system. Given the preceding information, do the followinga.Indicate the most appropriate sequence of activities by labeling each of the following steps in the correct order.____Normalize the conceptual model.Obtain a general description of company's operationsLoad the database.Create a description of each system of process.Test the system.Draw a data flow diagram and system flow charts._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 module that you believe the system should include.c.How will a data dictionary help you develop the system?d.what geneal 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?

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

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 atleast 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 pay roll.You have been contacted by one of the centre's manager to design and implement a computerized data base 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.
__________Normalize the conceptual model.
__________Obtain a general description of company's operations
__________Load the database.
__________Create a description of each system of process.
__________Test the system.
__________Draw a data flow diagram and system flow charts.
_________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 module that you believe the system should include.
c.How will a data dictionary help you develop the system?
d.what geneal 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?