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 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?
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
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
__________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?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps