Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning PostgreSQL

Authors: Salahaldin Juba, Achim Vannahme, Andrey Volkov

1st Edition

178398919X, 9781783989195

More Books

Students also viewed these Databases questions

Question

List at least three advantages to using a consultant.

Answered: 1 week ago

Question

3. Review the evidence. Do you believe the testimony presented?

Answered: 1 week ago

Question

1. What are the marketing implications of this situation?

Answered: 1 week ago