Kleenit Dry Cleaning Company specializes in the removal of stubborn stains, especially from woolen and other heavy
Question:
Kleenit Dry Cleaning Company specializes in the removal of stubborn stains, especially from woolen and other heavy clothing. The company uses an information system built around a relational database to help control and monitor its operations. The normal business process of the company is as follows: a customer will bring items needing cleaning to the shop and provide the details of the cleaning required. Details will be recorded on the cleaning receipt, a copy of which will be given to the customer and which will be entered in the receipts data table. The receipt will include a time and date when the cleaned clothing will be available. Personal information about customers is stored in the customer’s data table, and must be entered for new customers only. The customer will return an appropriate number of days later, bringing the cleaning receipt. He or she will make payment for the cleaned garments and will be given a payment receipt. The payment details shown on the receipt will be stored in the payments data table. At the beginning of each week, the receipts data table is used to determine if new cleaning materials are required by the company. If this is the case, a purchase order is placed with the materials supplier. The supplier ships the materials along with an invoice to the company; the company will send the appropriate payment to the supplier. The details of the purchases of cleaning materials are recorded in the purchases data table. Invoice payment details are recorded in the invoice data table.
1. Prepare a list of all data entities (tables) needed for the system, which should include all data attributes (fields). Designate which fields will be used as keys and specify the relationships between entities using the key fields.
2. Prepare a list of input forms which are needed by the system. Include a brief description of each form, including who will be using it. Draw examples of at least two of the forms (you may draw these using any method you prefer).
3. Prepare a list of outputs which the system must generate. Include a brief description of each output, including who will be using it. Draw examples of at least two of the output reports (you may draw these using any method you prefer).
Cost Management A Strategic Emphasis
ISBN: 978-0078025532
6th edition
Authors: Edward Blocher, David Stout, Paul Juras, Gary Cokins