Reference no: EM132866556

Simi Valley is a distributor that sells and delivers furniture to corporations, as well as selling directly to individual consumers. It is planning a new online sales channel as well. Items sold include office chairs , desks, office dividers, customized racks for computer equipment, bookshelves etc.

Simi Valley sells office furniture directly to corporations but it also sells to individuals seeking home office furniture. Besides the regular sales order process by phone, Simi Valley does accept returns for warranty service on products - which it performs itself (i.e. it does not send it back to the manufacturer). Warranty service processing will cause internal stock transfers to be generated as returns are received in the shipping point of the warehouse and are then transferred to a different room for repair or replacement and are then transferred back to shipping in order to be reissued to customers.

Different sales associates are used by Simi Valley for the 2 different kinds of sales (i.e. corporate vs. individual). If products are in stock, then the orders are fulfilled (picked, packed shipped and invoiced) within a 20 day period. If products are not in stock for a corporate order then a back order may be generated. If products are not in stock for individual orders then no order will be accepted for the products that are out of stock (although those that are in stock may still be ordered).

If a standard order from a corporation for in-stock products is not fulfilled in 20 days then Simi Valley issues a special 10% rebate coupon (with a coupon code) to the Customer for their next order. This is not true for individual orders.

Task 1: You will develop an Entity Relationship diagram (or Class diagram) to depict the key data entities (objects) relevant to this process. You can use database templates as a basis for this, we well as reverse engineering data structures (i.e. tables and inter-table relationships) from the screens in the ERP simulations you have been using. You should also provide a short narrative explaining and justifying why you think the entities you have depicted in this ERD are the most significant entities for this process.