can someone help me with this question please

) A database for a package delivery company (e.g., Fedex) needs to store data about customers, packages, and delivery facilities. Each customer is assigned a unique customer ID and the name and address of each customer must be recorded. Each package is assigned a unique package ID and the weight of each package needs to be recorded. Each facility is assigned a unique facility ID and the address of each facility needs to be recorded. A customer can ship multiple packages, but each package is sent by exactly one customer. For each shipment, the recipients name and address must 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.

(a) (20 points) Draw an E/R diagram that captures all of the above information.

(b) (20 points) 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.

(c) (10 points) List all of the nontrivial functional dependencies that you can find from the tables in (b). If there are attribute names that are newly introduced in (b), you may use these names. Please omit functional dependencies that are redundant (for example, if a b is included, do not add ac bc