Consider the following E-R entity set diagram -- DRIVER PK driver_Id, name, { ca
ID: 3776121 • Letter: C
Question
Consider the following E-R entity set diagram --
DRIVER
PK driver_Id,
name,
{
car
license
make
model
color
}
A naïve relational reduction resulted in the following relation and multivalued dependency –
driver(driver_id, name,l icense, make, model, color)
driver_id -->-> (license, make, model, color)
An astute database designer recognizes that this schema will result in repeated data. Use the multivalued dependency to decompose driver into two 4NF relations, driver and car. Show those relations.
Explanation / Answer
decompose the above one into driver and car having driver_id as the primary key which is unique.
driver(driver_id,name,license)
car(driver_id,make,model,color)
having driver_id details can be retrived without any repeated data
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.