Question Number 1                                                                                                  

Develop an Entity-relationship diagram for a TCS parcel delivery company which uses system-wide information for all the parcels it delivers. All parcels are identified by their tracking number and is associated with different parameters including weight, dimension, destination, delivery date, sender and receiver addresses. All items are received at various distribution centers across the country and are identified by their unique id, type and their addresses. All parcels make their way to the destination via one or more standard transportation methods (i.e. flights, delivery trucks, motorcycles, these transportation methods are characterized by their unique type, id and transportation identification number.

Develop an Entity-relationship diagram for a TCS parcel delivery company which uses system-wide information for all the parcels it delivers. All parcels are identified by their tracking number and is associated with different parameters including weight, dimension, destination, delivery date, sender and receiver addresses. All items are received at various distribution centers across the country and are identified by their unique id, type and their addresses. All parcels make their way to the destination via one or more standard transportation methods (i.e. flights, delivery trucks, motorcycles, these transportation methods are characterized by their unique type, id and transportation identification number.

Develop an Entity-relationship diagram for a TCS parcel delivery company that uses system-wide information for all the parcels it delivers. All parcels are identified by their tracking number and are associated with different parameters including weight, dimension, destination, delivery date, sender, and receiver addresses. All items are received at various distribution centers across the country and are identified by their unique id, type, and their addresses. All parcels make their way to the destination via one or more standard transportation methods (i.e. flights, delivery trucks, motorcycles, these transportation methods are characterized by their unique type, id, and transportation identification number.

Develop an entity-relationship model for the following scenario.

A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. The manufacturer has piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by one or more technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.