KINDLY DON'T COPY FROM ANY SOURCE AND PROVIDE THE EXACT ANSWER.

Extreme Bicycles manufacturer produces various plastic items including the raw parts for cycles. The company uses most of these raw parts to assemble the finished and semi-finished bicycles. It is possible that a single part may be used in several other products. All these products (raw, semi and finished) are sold to the customers through online orders. When an order is manufactured, it is shipped to the customer. The company keeps track of every order and shipment and updates the records according to the status of an order (received, in-production and manufactured) and the shipment (shipped and delivered). Draw an ER diagram to represent the data requirements as following: Identify the main entity types. [5] Identify the main relationship types between the entity types. Also Identify recursive relationship(s), if any. [5] Identify attributes and associate them with entity or relationship types. [3] Determine candidate and primary key attributes for cach (strong) entity type. [2] Following queries need to be performed on your data model. You are required to write a short descriptive note (1 to 2 lines such as The required information can be retrieved by joining Doctor and Patient_Treatment tables by using DOC_ID attribute.") indicating which tables/relationships will be used for each query. Do not write the SQL queries. . Identify the raw parts require to assemble any semi-finished or finished product. [3] Calculate the time taken from order placement to the shipment of an order. [3] Keep the record of the orders placed by each customer. [3] Calculate the total amount payable for an order including the shipment fee. [3] Track the status of each order and shipment. [3]