A database for a delivery company needs to store information about customers,packages and delivery facilities.Each customer is assigned a unique ID and the name and address of the customer needs to be recorded.Each package on the other hand is assigned a unique ID and the weight needs to be recorded.Also each facility is assigned a unique ID and the address of each facility needs to be recorded.One customer can ship multiple packages ,but each package is sent by exactly one customer.For each shipment,the receipent's name and address needs to be recorded.Furthermore, the database must store the facilities that each package goes through, and the time when that package arrives at each of these facilities..

Quesa)Draw an ER diagram that captures this information

Ques b) Define tables using SQL that correspond to the E-R diagram in (a). You must define the smallest number of tables while ensuring that these tables are in BCNF (you do not need to prove that the resulting tables are in BCNF). For each table, specify primary and foreign keys. Add integrity constraints if needed.

Ques c)Identify all non trivial dependencies.