Question: I need help with 4 and 5. I know how to do 1, 2, and 3, but Iwas struggling with 4 and 5 the part
I need help with 4 and 5.

I know how to do 1, 2, and 3, but Iwas struggling with 4 and 5 the part where customer ship package and receive package
Below is how I do 1 2 3 4, please suggest a solution if it wrong and help me on 5 too

For this assignment, you are making an EER diagram for Planet Express delivery service. 1. Customers have a unique address, which is made up of a street, city, state, and zip. Customers may have multiple phone numbers, and customers have a name. 2. Some customers are businesses. Customers that are businesses may also have a shipping manager's name and may have a billing account number. 3. All packages have a width and length and a unique tracking number. Packages must be either a letter or a parcel. Letters have a service type (next day, second day, ground, etc). Parcels have additional attributes of height and weight. 4. A customer may ship multiple packages. Each shipment has a shipping date. Packages must participate in this relationship, and each package is shipped by a single customer. 5. A customer may receive multiple packages. Packages must participate in this relationship, and each package is sent to only one customer. The "receives" relationship has attributes of delivery date, a delivery photo, and notes. These attributes may be null if the package is still in transit. (name) (Address ( (phone #) Customer city Businesses hipping Lefter Package c o Parcel width
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
