menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

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. 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?

BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 9, Problem 1P
Textbook Problem
1519 views

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:

  1. 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.

  1. b. Describe the various modules that you believe the system should include.
  2. c. How will a data dictionary help you develop the system? Give examples.
  3. 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.
  4. e. What is the best approach to conceptual database design? Why?
  5. f. Name and describe at least four reports the system should have. Explain their use. Who will use those reports?

a)

Program Plan Intro

DBLC (Database Life Cycle):

  • DBLC is a sequential process which is used to trace the history of the application that is present within the information system.
  • The history of the application can be traced from the beginning till its last even though being outdated.
  • DBLC is concurrent to SDLC because the database represents the core of the information system.
  • It is composed of six phases:
    • Initial study:
      • Examining the operations of the current system.
    • Design:
      • It focuses on designing the database model which satisfies both operation and objectives of the company.
    • Implementation and loading:
      • It is a process of designing the specifications.
    • Testing and evaluation:
      • Ensure the database performance.
    • Operation:
      • The process that is designed to make it operational.
    • Maintenance and evolution:
      • Performs routine maintenance activity within the database.

Explanation of Solution

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:

Analysis:

  • The shop manager gets interviewed.
  • The mechanic of the shop is interviewed.
  • Operations of the company are obtained in the form of general description.
  • For every system process descriptions are created.

Design:

  • E-R diagram is used to create a conceptual model.
  • The system flow charts and diagrams for data flow are created.
  • The conceptual model gets normalized.

Implementation:

  • The table structure gets created.
  • The contents are loaded into the database.
  • Application programs are created...

b)

Explanation of Solution

The main modules that are needed to be included for the development of the system:

  • Inventory.
    • Maintains the inventory of the system,
  • Payroll.
    • Payroll information gets processed
  • Work order.
    • Processing details of the work order.
  • Customer.
    • Payments and receipt of the work order made are maintained.

Sub-modules of the main modules include:

Inventory

  • Parts
    • Parts those are used or maintained or purchased.
  • Purchasing
    • Holds the purchase history.

Payroll

  • Employee payroll
    • The payroll for the employees gets processed.

Work order

  • Maintenance
    • Histories of maintenance are recorded...

c)

Program Plan Intro

Data Dictionary:

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:

  • The contents of data dictionary are used for verifying the components of database design such as entities, attributes and relationships that exists between them.
  • Database design is used by the designer to check for their homonyms and synonyms.
  • It also verifies the entities and attributes created can be able to support all the queries in required way along with report requirements.

d)

Explanation of Solution

Recommendation that can be given to the shop manager:

  • The role of the designer is to provide solutions to the problems that are identified during the initial stage.
  • The system that is developed is subjected to both external and internal constraints.
  • Consider the following example:
    • Consider the designing work that is made the system developed must concentrate and prioritize the development of module that will bring the benefits at the stated time and with the given budget.
    • The time required in the development of the system need not to be spends on identifying the relationships.
  • The modular system that is developed needs to be developed in a way that any future improvements that are necessary can be merged to it whenever required...

e)

Explanation of Solution

Best approach for the conceptual database design:

  • The best approach to provide the conceptual database design based the given nature of the business would be centralized and top down approach.

Top down approach:

  • The design approach begins by identifying the data sets and by defining the data elements for each of the sets.
  • This process takes place by identifying the available entity type that are different and attributes of each entity gets defined.
  • This type of design approach is well suited for the database designers who deal with the complex and large databases...

e)

Explanation of Solution

List of four reports that system can contain:

The below are the list of four reports that system can contain and they are:

  • Report on monthly activity.
    • It contains the summary of service by category which is categorized based on branch and by month.
    • It acts as a base for forecasting personnel and maintains the stock requirements for each branch and period.
  • Report on the mechanic summary sheet.
    • It contains record of number of hours worked by the mechanic.
    • This kind of data will be greatly helpful for the payroll processing.
    • This is used for maintenance personnel for making scheduling activity...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
Describe the functions of a human resource MIS.

Fundamentals of Information Systems

Explain the basic requirements for becoming a successful automotive technician.

Automotive Technology: A Systems Approach (MindTap Course List)

On a summer day in Phoenix, Arizona, the inside room temperature is maintained at 68 F while the outdoor air te...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

When should you use a one-way sync or a two-way sync?

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

What can a welder do to control overheating of the metal pieces being welded?

Welding: Principles and Applications (MindTap Course List)