WestWorld is a small retail company specializing in selling tech products. The company initially began selling items though a Facebook company page and tracked all its customer, product and order information via an excel spreadsheet. Due to current COVID-19 situation there has been a surge in online shopping, and this made it more challenging for the company to keep track of customer orders and deliveries. The company has decided to build an online webstore. You have been hired to be part of the IT development team. Your responsible for database design aspect of this project. Given below is the data you have gathered through interviews and documentation. Create an ERD with all entities identified, their respective relationships, indicate type of relationship (use crow foot notation) and list possible attributes.

A customer may place many orders.

An order must be placed by a customer.

An order contains at least one order line.

Each order line is contained in one and only one order. (Discussion: Although a given item such as a headset may be found in many orders, a specific headset sold to a specific customer is found in only one order.)

Each order line has a specific product written in it.

A product may be written in many orders. (Discussion: Many customers can order one or more specific products, but a product that is not in demand may never be sold to a customer and will, therefore, not show up in any order line -- note that ORDER_LINE is optional to PRODUCT. Also, note that each order line may indicate more than one of a specific item. For example, the item may be headset and the number sold may be 1 or 2, or 500.

The ORDER_LINE entity would have at least the following attributes: ORDER_NUM, ORDLINE_NUM, PROD_CODE, ORDLINE_PRICE, ORDLINE_QUANTITY. The ORDER_LINE composite PK would be ORDER_NUM + ORDLINE_NUM. You might add the derived attribute ORDLINE_AMOUNT, which would be the result of multiplying ORDLINE_PRICE and ORDLINE_QUANTITY.)

WestWorld is a small retail company specializing in selling tech products. The company initially began selling items though a Facebook company page and tracked all its customer, product and order information via an excel spreadsheet. Due to current COVID-19 situation there has been a surge in online shopping, and this made it more challenging for the company to keep track of customer orders and deliveries. The company has decided to build an online webstore. You have been hired to be part of the IT development team. Your responsible for database design aspect of this project. Given below is the data you have gathered through interviews and documentation. Create an ERD with all entities identified, their respective relationships, indicate type of relationship (use crow foot notation) and list possible attributes.

A customer may place many orders.

An order must be placed by a customer.

An order contains at least one order line.

Each order line is contained in one and only one order. (Discussion: Although a given item such as a headset may be found in many orders, a specific headset sold to a specific customer is found in only one order.)

Each order line has a specific product written in it.

A product may be written in many orders. (Discussion: Many customers can order one or more specific products, but a product that is not in demand may never be sold to a customer and will, therefore, not show up in any order line -- note that ORDER_LINE is optional to PRODUCT. Also, note that each order line may indicate more than one of a specific item. For example, the item may be headset and the number sold may be 1 or 2, or 500.

The ORDER_LINE entity would have at least the following attributes: ORDER_NUM, ORDLINE_NUM, PROD_CODE, ORDLINE_PRICE, ORDLINE_QUANTITY. The ORDER_LINE composite PK would be ORDER_NUM + ORDLINE_NUM. You might add the derived attribute ORDLINE_AMOUNT, which would be the result of multiplying ORDLINE_PRICE and ORDLINE_QUANTITY.)

MAKE A ERD ITS SUPPER URGENT