ABC MANUFACTURING CUSTOMER ORDER AND PRODUCT APPLICATION The ABC Manufacturing company has a completely automated application system. iThe system, however, resides on index files and does not allow for decision support at all in order to move to ad hoc queries, and "what if queries, the company has decided to convert the existing system to a database. Initially, the only criterion for the application is to replace the existing system with a database reports and screens that exist currently. system. No ad hoc screen or reports have been anticipated. You will see the Use this case to perform the task that the module has asked of you Customer Order and Product Application Considerations Each customer must be on file before an order can be placed. The name, address(s), phone number(s), and credit limit must be recorded. All other data items are optional. If there is no shipping address, then the mailing address is used instead. Since customers can have identical names, a customer id has been assigned to each customer. 1. Each order will have a computer generated id number. The order can have up to 10 line items. Discounts can be given to preferred customers and this discount 2. amount will be recorded on the customer's record. Customers without a amount will not be given a discount. 3. Each product listed on the order will show the standard price for that product Discounts will be shown at the bottom of the order form. 4. Orders that can be flled or partially flled are shipped immediately, and the product data is updated accordingly. Orders, or partial orders that cannot be filled will be backordered. As products are manufactured the product data is updated accordingly along with the part inventory data. 5. A customer can place numerous orders. different customers. The same part can be used in numerous products.(eg.a screw can be used in a chair, bar stool etc.) Products can be ordered by many 6. ABC MANUFACTURING ORDER FORM DATE: AUG 30 2002 ORDER9832 SHIPPING ADDRESS: 4NO STREET 123 THAT STREET TORONTO, ONTARIO HAMLTON, ONTARO LEK 514 PHONE: (416) 879-0045 (416) 786-3241 1FR223 HALF SZE REFRGERATOR2 2TB101 PATIO TABLE 2-75099 3 150.00 3 CH089 PATIO CHAIRS 700.00 20 20 35.00 TOTAL 2651.99 DISCOUNT AMT 22.56 AMOUNT OWING 2572.42 PRODUCTS INVENTORY AS AT:AUG 30, 2002 FR223 TB101 PATIO CHARS HALF SCE REFRIGERATOR 10 PATIO TABLE PRODUCT EXPLOSION REPORT PRODUCT CODE DESCRPTIONPART NUMB PART DESCRIPTION WOOD223 SCRW110 1X2-30WOOD 1.25 SCREWS 28 2x4-48 WOOD 1.25* SCREWS 12 TB101 PATIO TABLE 34 SCRW110 ABC MANUFACTURING CUSTOMER ORDER AND PRODUCT APPLICATION The ABC Manufacturing company has a completely automated application system. iThe system, however, resides on index files and does not allow for decision support at all in order to move to ad hoc queries, and "what if queries, the company has decided to convert the existing system to a database. Initially, the only criterion for the application is to replace the existing system with a database reports and screens that exist currently. system. No ad hoc screen or reports have been anticipated. You will see the Use this case to perform the task that the module has asked of you Customer Order and Product Application Considerations Each customer must be on file before an order can be placed. The name, address(s), phone number(s), and credit limit must be recorded. All other data items are optional. If there is no shipping address, then the mailing address is used instead. Since customers can have identical names, a customer id has been assigned to each customer. 1. Each order will have a computer generated id number. The order can have up to 10 line items. Discounts can be given to preferred customers and this discount 2. amount will be recorded on the customer's record. Customers without a amount will not be given a discount. 3. Each product listed on the order will show the standard price for that product Discounts will be shown at the bottom of the order form. 4. Orders that can be flled or partially flled are shipped immediately, and the product data is updated accordingly. Orders, or partial orders that cannot be filled will be backordered. As products are manufactured the product data is updated accordingly along with the part inventory data. 5. A customer can place numerous orders. different customers. The same part can be used in numerous products.(eg.a screw can be used in a chair, bar stool etc.) Products can be ordered by many 6. ABC MANUFACTURING ORDER FORM DATE: AUG 30 2002 ORDER9832 SHIPPING ADDRESS: 4NO STREET 123 THAT STREET TORONTO, ONTARIO HAMLTON, ONTARO LEK 514 PHONE: (416) 879-0045 (416) 786-3241 1FR223 HALF SZE REFRGERATOR2 2TB101 PATIO TABLE 2-75099 3 150.00 3 CH089 PATIO CHAIRS 700.00 20 20 35.00 TOTAL 2651.99 DISCOUNT AMT 22.56 AMOUNT OWING 2572.42 PRODUCTS INVENTORY AS AT:AUG 30, 2002 FR223 TB101 PATIO CHARS HALF SCE REFRIGERATOR 10 PATIO TABLE PRODUCT EXPLOSION REPORT PRODUCT CODE DESCRPTIONPART NUMB PART DESCRIPTION WOOD223 SCRW110 1X2-30WOOD 1.25 SCREWS 28 2x4-48 WOOD 1.25* SCREWS 12 TB101 PATIO TABLE 34 SCRW110