b. Describe the various modules that you believe the system should include.
b. Describe the various modules that you believe the system should include.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Please solve part d,e,f thanks

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.

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
I need answers for d,e,f and these are subparts where you should answer 3 subparts.
Solution
Knowledge Booster
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.Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education