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 need help with 4 and 5. I know how to do

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

1, 2, and 3, but Iwas struggling with 4 and 5 the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!