Question
Jim's Automotive is operated by Jim Wood, the Chief Executive Officer (CEO), and his associated employees. He has decided to develop a database system to
Jim's Automotive is operated by Jim Wood, the Chief Executive Officer (CEO), and his associated employees. He has decided to develop a database system to track his purchases, parts inventory, accounts payable, and cash payments. However, he does not have time to do the development himself. Therefore, he has hired you and your team members to design and implement the system (i.e., parts and supplies purchasing system) for him. He describes the requirements of his system as follows: Whenever parts are needed, a purchasing clerk prepares a purchase order by completing a purchase order form. The purchase order form includes purchase order number, order date, item number, quantity ordered, order price, employee number (preparer), employee number (authorizer), and vendor number. To accommodate all of parts needs, the purchasing clerk may need to prepare several purchase orders, as Jim's Automotive orders parts from several vendors. Also, a purchase order can be made for several types of auto parts from a single vendor. When the purchase order form is prepared, the purchasing clerk forwards the form to the CEO, Jim Wood, who approves the order. The approved purchase order is then sent to a vendor. When the order is received, a warehouse department clerk inspects the quality of the parts and verifies the quantity of parts based on the purchase order and the packing slip included in the shipment. The clerk then prepares a receiving report, forwards the report to an accounting payable clerk for payment process, and updates inventory records. The receiving report includes receipt number, receipt date, quantity received, item condition, purchase order number, employee number (receiver), and vendor number. Also, an invoice is delivered to the accounts payable clerk from the vendor. At the end of each month, the accounts payable clerk prepares a purchase order payment form for all amounts charged through the end of the month by verifying invoices, purchase orders, and receiving reports. The purchase order payment form includes payment number, payment date, payment amount, employee number (preparer), employee number (authorizer), receipt number, vendor number, and account number. The form is then forwarded to the CEO. When the CEO authorizes the payment form, the accounts payable clerk prepares a check and mails it to the vendor. Finally, a monthly summary report of purchase orders and payments is prepared for each month and forwarded to the CEO.
Develop a Context level and Level 0 Data Flow Diagram. Separate each of the two diagrams and clearly label them. The last page can be used to develop your rough draft of the diagrams. Your final diagrams need to be neat, readable, and should not have any crisscrossing data flows. Make sure to include all necessary files to prepare the reports or process the data listed in the narrative.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started