6. Consider the relation DELIVERY (package-id,weight,customer-id, address, drive

Question

6. Consider the relation DELIVERY (package-id,weight,customer-id, address, driver, day,time,vehicle-id) You can assume all of the following: ench customer has a unique adress: however, several customers may live in the same address That is, customer-id -» address. Each package has a certain weight. That is, package-id veight. There is no agreement on exactly what constitutes a delivery; the following 3 alternative definitions are discussed: (a) A delivery is a single package delivered to one customer at a certain time. (b) A delivery is a single package delivered to one address at a certain time (c) A delivery is several packages delivered at the same time to the same customer For each definition, give the FDs that hold in the table, and the key and normal form determined by those FDs.

Explanation / Answer

Solution:

DELIVERY(package-id,weight,customer-id,address,driver,day,time,vehicle-id)

a)

Functional Dependencies :

Normal form - The relation DELIVERY is in first normal form as there are no multivalued dependencies. But it is not in second normal form.

To Normalize DELIVERY, it must be divided into following relations:

b)

Functional Dependencies :

Normal form - The relation DELIVERY is in first normal form as there are no multivalued dependencies. But it is not in second normal form.

c)

Functional Dependencies :

Normal form - The relation DELIVERY is in first normal form as there are no multivalued dependencies. But it is not in second normal form.

?underlined are primary keys

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.