Computers and Technology, 28.07.2021 20:00 yasyyas646646
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:
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 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?
Answers: 1
Computers and Technology, 22.06.2019 19:00
In he example code, what does the title attribute create? a tool tip an element a source a markup
Answers: 1
Computers and Technology, 23.06.2019 11:30
In cell h5 enter a formula that will calculate the percentage of attendees that went to the altamonte springs job fair in 2018.
Answers: 1
Computers and Technology, 23.06.2019 15:00
Visually impaired individuals generally rely on the for navigation. thus, designers need to ensure that mouse-specific inputs, such as pointing, clicking, and hovering, can be done without a mouse.
Answers: 1
Computers and Technology, 23.06.2019 19:30
You can apply several different worksheet themes from which tab?
Answers: 1
The ABC Car Service & Repair Centers are owned by the Silent Car Dealership; ABC services and re...
Mathematics, 31.01.2021 01:00
Arts, 31.01.2021 01:00
Mathematics, 31.01.2021 01:00
Mathematics, 31.01.2021 01:00
Mathematics, 31.01.2021 01:00
Mathematics, 31.01.2021 01:00
Biology, 31.01.2021 01:00
Mathematics, 31.01.2021 01:00