Data Flow Diagram

Data Flow Diagram

1)Introduction
This report is prepared for the Acme Garage case study. The Acme garage specializes in repairing the cars. Presently the Acme garage update and maintain its various data such as; customer data, suppliers’ data, car parts invoice data, etc. in the Microsoft Excel spreadsheet. We investigate the overall business and business purpose of Acme garage. We observe the data flow of the business data of Acme garage and made a new database system for it, so that it can easily maintain their various business data. We choose the Microsoft Access to develop a new database system for the Acme garage.

About the Book

Data Flow Diagram

1)Introduction

This report is prepared for the Acme Garage case study. The Acme garage specializes in repairing the cars. Presently the Acme garage update and maintain its various data such as; customer data, suppliers’ data, car parts invoice data, etc. in the Microsoft Excel spreadsheet. We investigate the overall business and business purpose of Acme garage. We observe the data flow of the business data of Acme garage and made a new database system for it, so that it can easily maintain their various business data. We choose the Microsoft Access to develop a new database system for the Acme garage.

Data Flow Diagram

2)Business Overview

Structure

The Acme garage is providing the car repairing services to their customers. When the customers comes for repairing their cars, the Acme always check  the customer has paid previously for work done or not before fixing the car. After the car repair and ready to deliver to the customer, an invoice report of whole work done is provided to the user after this the customer needs to pay the full amount within 30 days.

The acme kept the detail of the customers and job in the customers file and job file respectively.The employee who is responsible for updating and maintaining the database, maintain the database. The mechanics are repairing the cars and also write the entries into the job book. Its stock the car parts which is used frequently and purchase it’s from the parts supplier regularly. The parts which are used less frequently are ordered to the suppliers when required; the Acme is invoiced by the suppliers for purchasing of these parts. Reference to the Stock file will indicate if parts required for a particular job are in stock otherwise the parts will have to be ordered in. In case where items are removed from the stock, the balance of stock needs to be reduced.The cost of the car parts is added from the invoice which is received at the time of delivery of parts. After completing the job, hours of labour are maintained in the job file and the stock file. The order file will be used to determine the parts price which will record in job file also. Finally, the job file helps to produce an invoice for the customer. At the end of the month all the invoice will be paid in full sent from the supplier.

Book Club Resources
Disclosure of Material Connection: Some of the links in the page above are "affiliate links." This means if you click on the link and purchase the item, I will receive an affiliate commission. I am disclosing this in accordance with the Federal Trade Commission's 16 CFR, Part 255: "Guides Concerning the Use of Endorsements and Testimonials in Advertising."