IT 330 Lab 2: Entity Relationship Diagrams Objectives: Decipher customer statement. Develop entity list. Add attributes for each entity. Establish…

Use the following statement from Mountain View’s CEO in completing the following lab:

Customers log on to our Web site and place an order or call an employee who places the order on the customers’ behalf. All orders contain the customer information, the order detail, which has information about the products, and quantities that the customer purchased, and the payment method. When we receive the order into the system, the customer information has already been checked and crucial bits, such as the customer’s address, have been verified by the site. The first thing we do is process the order items. We make sure that the products being purchased are in stock and we place a hold on those products. If a product is not in stock, we place that item or the entire order on back order, depending on the customer’s preference. Products that are in stock have a hold placed on them. Once the products are on hold, we process the payment for the order. By law, once we accept payment, we must ship within 30 days. This is why we make sure the product is on hold before we process the payment. For payment, we take credit cards, gift cards, and direct bank draft via an electronic check. After the payment has been cleared, we send the order to the warehouse where is it picked, packed, and shipped by our employees. We do this for about 1,000 orders per week.

Leave a Reply