Please complete the following diagrams for Car Service Management System:• Develop DFD level 0 diagrams for ACME garage. Case Study 2: Acme Garage Lilydale The Acme Garage specialises in repairing cars. The owner isGeoff, who has worked in the field for many years and owns 3 garages around Victoria. There are 30full time and part-time employees currently working in his business. In the Lilydale location, there isMary and Kim, who looks after customer enquiries, maintain (Create, Retrieve, Update, Delete)customer profiles, generate customer invoices, process invoices and payments. Bill and Ben are carmechanics. Peter looks after the ordering processes. When customers come to have their carsrepaired, their initial contact is with Kim or Mary. Before Kim or Mary accept their requests, theycheck the database system to ensure any previous work that the customer has requested has beenpaid for satisfactorily. This can be generated by their current computer system (when customer's carregistregistration number is entered into the computer, the system will provide relevant feedback). Ifwamethere are outstanding payment issues with the car registration number, the customer will berequired to pay all outstanding bills before their new requests are accepted. Customer details arekept in a Customer file, and details of each job are kept in a Job file under-car registration numbers.perangIf all is ok, Kim or Mary will accept the vehicles and pass the jobs to the mechanics: Bill and Ben. Theywill hwill check the car and identify problems, parts required and estimated completion time. They willneed to complete forms which include all relevant information and forward to Kim or Mary, who willcheck the lists and calculate the cost. They will then call the customer for confirmation. If customersagree, Mary or Kim will notify the mechanics to go ahead and repair the car. After the job iscompleted, labour hours and parts used are recorded in the Job file. The mechanics will notify Maryor Kim, who will prepare invoices and call the customer to collect the cars. Customers can pay whenthey pick up cars or within 30 days. Reminder emails will be sent to customers a week before thedue date. If payment is not made within 30 days, the follow-up emails will be sent to customeradvising of a 10% penalty. At the end of every week, computer systems will generate reports, e.g.,Jobs and used parts, Customer Payment report... Acme needs to keep stock of frequently used parts(C-5-7 Spor(e.g., spark plugs, oil filters, air filters) which are purchased regularly from suppliers. Acme'ssuppliers are mainly local, however for some special parts for expensive cars, they also purchasefrom overseas suppliers. The computer system will monitor the stock level automatically. For thoseparts from local suppliers where the inventory level drops down to quantities of 3, then anotification will be sent to Peter, who supervisors the ordering processes. Peter has to contactsuppliers and lodge a replacement order. However, for those parts from overseas suppliers, thenotification will be sent when the inventory level drops to a quantity of 5. Less frequently used partsare ordered as required. Once they have a reliable supplier, they tend to stick with them, so theyonly ever have one supplier for each part. Supplier details are recorded and filed in the database. Inany ever have one supppara cappier www CONthe case where stock is ordered, details of the order are recorded in the Order file. Peter works inmegy are reathe office and maintains the ordering processes. All parts are recorded in the database 'Parts' file.The parts database should be identified to the supplier allowing Peter to create, add, update, deletewwwand modify both supplier and part tables. If ordered parts haven't arrived within 10 days, the systemautomatically notifies Peter, who will contact suppliers immediately. The computer system willgenerate several reports by the end of each month, e.g., ordering parts with the suppliers, deliveredorders, an unpaid invoice report and an unfilled orders report. These reports will be sent to theAcme's owner Geoff. A copy of all orders is stored in an Order file, where invoices and parts arechecked against the goods received and are then attached to the order. If everything is correct,Peter will update the order and stock details on the system. He will then pass the invoices, (includingthe cost of the parts) to Mary or Kim who looks after accounting and payments. Mary or Kim will paythe invoices within 10 days after the delivery. If invoices haven't been paid in 10 days, the auto-notification will be sent to their email to remind them that the orders are outstanding. At the end ofthe month, the system will generate reports on invoices paid during the month, the parts list whichdetails the names of the parts, quantities, single costs and total costs. Most of the data entryinvolves simple business transactions (recording customer information, job information, partsinformation, supplier information, managing orders, receiving payments and making payments). Asmentioned previously, a variety of information is extracted from the system through enquiries andthe generation of periodic reports. This information is used by Geoff, the owner of the garage, tomanage the business.

Answer is given below. Answer is given in the second step

me and part-time employees currently working in his business. In the Lilydale location, there is and Kim, who looks after customer enquiries, maintain (Create, Retrieve, Update, Delete) mer profiles, generate customer invoices, process invoices and payments. Bill and Ben are car anics. Peter looks after the ordering processes. When customers come to have their cars red, their initial contact is with Kim or Mary. Before Kim or Mary accept their requests, they the database system to ensure any previous work that the customer has requested has been for satisfactorily. This can be generated by their current computer system (when customer's car tration number is entered into the computer, the system will provide relevant feedback). If Akk e are outstanding payment issues with the car registration number, the customer will be ired to pay all outstanding bills before their new requests are accepted. Customer details are in a Customer file, and details of each job are kept in a Job file under-car registration numbers. is ok, Kim or Mary will accept the vehicles and pass the jobs to the mechanics: Bill and Ben. They heck the car and identify problems, parts required and estimated completion time. They will ricca New to complete forms which include all relevant information and forward to Kim or Mary, who will to complete fo the lists and calculate the cost. They will then call the customer for confirmation. If customers Kam wwwwww e, Mary or Kim will notify the mechanics to go ahead and repair the car. After the job i 2000 200 p -pon are leted, labour hours and parts used are recorded in the Job file. The mechanics will notify Mary econoce men m, who will prepare invoices and call the customer to collect the cars. Customers can pay when 13 indor emai pick up cars or within 30 days. Reminder emails will be sent to customers a week before the 2012 date. If payment is not made within 30 days, the follow-up emails will be sent to customer ing of a 10% penalty. At the end of every week, computer systems will generate reports, e.g., and used parts, Customer Payment report... Acme needs to keep stock of frequently used parts spark plugs, oil filters, air filters) which are purchased regularly from suppliers. Acme's liers are mainly local, however for some special parts for expensive cars, they also purchase overseas suppliers. The computer system will monitor the stock level automatically. For those from local suppliers where the inventory level drops down to quantities of 3, then a ication will be sent to Peter, who supervisors the ordering processes. Peter has to contact liers and lodge a replacement order. However, for those parts from overseas suppliers, the ication will be sent when the inventory level drops to a quantity of 5. Less frequently used parts rdered as required. Once they have a reliable supplier, they tend to stick with them, so they ever have one supplier for each part. Supplier details are recorded and filed in the database. In ase where stock is ordered, details of the order are recorded in the Order file. Peter works in ffice and maintains the ordering processes. All parts are recorded in the database 'Parts' file. parts database should be identified to the supplier allowing Peter to create, add, update, delete modify both supplier and part tables. If ordered parts haven't arrived within 10 days, the system matically notifies Peter, who will contact suppliers immediately. The computer system will rate several reports by the end of each month, e.g., ordering parts with the suppliers, delivered rs, an unpaid invoice report and an unfilled orders report. These reports will be sent to the e's owner Geoff. A copy of all orders is stored in an Order file, where invoices and parts are women ked against the goods received and are then attached to the order. If everything is correct, eu again P will update the order and stock details on the system. He will then pass the invoices, (including ost of the parts) to Mary or Kim who looks after accounting and payments. Mary or Kim will pay after the voices within 10 days after the delivery. If invoices haven't been paid in 10 days, the auto- ication will be sent to their email to remind them that the orders are outstanding. At the end of nonth, the system will generate reports on invoices paid during the month, the parts list which Is the names of the parts, quantities, single costs and total costs. Most of the data entry mentioned previously, a variety of information is extracted from the system through enquiries and the generation of periodic reports. This information is used by Geoff, the owner of the garage, to manage the business.

me and part-time employees currently working in his business. In the Lilydale location, there is and Kim, who looks after customer enquiries, maintain (Create, Retrieve, Update, Delete) mer profiles, generate customer invoices, process invoices and payments. Bill and Ben are car anics. Peter looks after the ordering processes. When customers come to have their cars red, their initial contact is with Kim or Mary. Before Kim or Mary accept their requests, they the database system to ensure any previous work that the customer has requested has been for satisfactorily. This can be generated by their current computer system (when customer's car tration number is entered into the computer, the system will provide relevant feedback). If Akk e are outstanding payment issues with the car registration number, the customer will be ired to pay all outstanding bills before their new requests are accepted. Customer details are in a Customer file, and details of each job are kept in a Job file under-car registration numbers. is ok, Kim or Mary will accept the vehicles and pass the jobs to the mechanics: Bill and Ben. They heck the car and identify problems, parts required and estimated completion time. They will ricca New to complete forms which include all relevant information and forward to Kim or Mary, who will to complete fo the lists and calculate the cost. They will then call the customer for confirmation. If customers Kam wwwwww e, Mary or Kim will notify the mechanics to go ahead and repair the car. After the job i 2000 200 p -pon are leted, labour hours and parts used are recorded in the Job file. The mechanics will notify Mary econoce men m, who will prepare invoices and call the customer to collect the cars. Customers can pay when 13 indor emai pick up cars or within 30 days. Reminder emails will be sent to customers a week before the 2012 date. If payment is not made within 30 days, the follow-up emails will be sent to customer ing of a 10% penalty. At the end of every week, computer systems will generate reports, e.g., and used parts, Customer Payment report... Acme needs to keep stock of frequently used parts spark plugs, oil filters, air filters) which are purchased regularly from suppliers. Acme's liers are mainly local, however for some special parts for expensive cars, they also purchase overseas suppliers. The computer system will monitor the stock level automatically. For those from local suppliers where the inventory level drops down to quantities of 3, then a ication will be sent to Peter, who supervisors the ordering processes. Peter has to contact liers and lodge a replacement order. However, for those parts from overseas suppliers, the ication will be sent when the inventory level drops to a quantity of 5. Less frequently used parts rdered as required. Once they have a reliable supplier, they tend to stick with them, so they ever have one supplier for each part. Supplier details are recorded and filed in the database. In ase where stock is ordered, details of the order are recorded in the Order file. Peter works in ffice and maintains the ordering processes. All parts are recorded in the database 'Parts' file. parts database should be identified to the supplier allowing Peter to create, add, update, delete modify both supplier and part tables. If ordered parts haven't arrived within 10 days, the system matically notifies Peter, who will contact suppliers immediately. The computer system will rate several reports by the end of each month, e.g., ordering parts with the suppliers, delivered rs, an unpaid invoice report and an unfilled orders report. These reports will be sent to the e's owner Geoff. A copy of all orders is stored in an Order file, where invoices and parts are women ked against the goods received and are then attached to the order. If everything is correct, eu again P will update the order and stock details on the system. He will then pass the invoices, (including ost of the parts) to Mary or Kim who looks after accounting and payments. Mary or Kim will pay after the voices within 10 days after the delivery. If invoices haven't been paid in 10 days, the auto- ication will be sent to their email to remind them that the orders are outstanding. At the end of nonth, the system will generate reports on invoices paid during the month, the parts list which Is the names of the parts, quantities, single costs and total costs. Most of the data entry mentioned previously, a variety of information is extracted from the system through enquiries and the generation of periodic reports. This information is used by Geoff, the owner of the garage, to manage the business.

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter5: Advanced Data Modeling

Section: Chapter Questions

Problem 6P

See similar textbooks