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:
__________ 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.
DBLC (Database Life Cycle):
Order in which the design of the database made for the ABC car service and repair Centers:
The correct sequence of process are based on the phases of DBLC, here the sequence are arranged based on the main three phase namely analysis, design, and implementation:
The order that is sorted based on the phases of DBLC:
The main modules that are needed to be included for the development of the system:
Sub-modules of the main modules include:
The collection of description of data objects and a set of information that describes the content, format and structure of a database is called Data Dictionary. It is also used to control access in database and describe the relationship between the elements.
Function of data dictionary in database design:
The functions of data dictionary in the database design are listed below:
Recommendation that can be given to the shop manager:
Best approach for the conceptual database design:
Top down approach:
List of four reports that system can contain:
The below are the list of four reports that system can contain and they are:
Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!Get Started
Database Systems: Design, Implementation, & Management
Fundamentals of Information Systems
Principles of Information Security (MindTap Course List)
A Guide to SQL
Fundamentals of Information Systems
Principles of Information Systems (MindTap Course List)
Precision Machining Technology (MindTap Course List)
Fundamentals of Geotechnical Engineering (MindTap Course List)
Cornerstones of Financial Accounting
Principles of Geotechnical Engineering (MindTap Course List)
Automotive Technology: A Systems Approach (MindTap Course List)
Mechanics of Materials (MindTap Course List)
Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)
Management Of Information Security
International Edition---engineering Mechanics: Statics, 4th Edition
EBK ELECTRICAL WIRING RESIDENTIAL
Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)
Solid Waste Engineering
Electric Motor Control
Steel Design (Activate Learning with these NEW titles from Engineering!)
Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
A+ Guide to Hardware (Standalone Book) (MindTap Course List)
Welding: Principles and Applications (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)