Draw the Entity 1 1 
Draw the Entity- Relationship Diagram (ERD) for the following scenario:
A salesperson may manage many other salespeople. A salesperson is managed by only one salespeople.
A salesperson can be an agent for many customers. A customer is managed by one salespeople. A customer can place many orders. An order can be placed by one customer. An order lists many inventory items. When the order is made for number of inventory items, the date and the amount is recorded.
An inventory item may be listed on many orders. An inventory item is assembled from many parts. A part may be assembled into many inventory items. Many employees assemble an inventory item from many parts. While the employee assemble, if any fault, it is identified with fault-log-id, fault-log-name. A supplier supplies many parts. A part may be supplied by many suppliers.
Draw the Entity- Relationship Diagram (ERD) for the following scenario:
UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries)
.
These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a deliveryRoute. Please create an Entity Relationship diagram that captures this information about the UPS system. Be certain to indicate identifiers and cardinality constraints.
Draw the Entity- Relationship Diagram (ERD) for the following scenario:
The company is organized into DEPARTMENTs. Each
A salesperson may manage many other salespeople. A salesperson is managed by only one salespeople.
A salesperson can be an agent for many customers. A customer is managed by one salespeople. A customer can place many orders. An order can be placed by one customer. An order lists many inventory items. When the order is made for number of inventory items, the date and the amount is recorded.
An inventory item may be listed on many orders. An inventory item is assembled from many parts. A part may be assembled into many inventory items. Many employees assemble an inventory item from many parts. While the employee assemble, if any fault, it is identified with fault-log-id, fault-log-name. A supplier supplies many parts. A part may be supplied by many suppliers.
Draw the Entity- Relationship Diagram (ERD) for the following scenario:
UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries)
.
These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a deliveryRoute. Please create an Entity Relationship diagram that captures this information about the UPS system. Be certain to indicate identifiers and cardinality constraints.
Draw the Entity- Relationship Diagram (ERD) for the following scenario:
The company is organized into DEPARTMENTs. Each