Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started