cs186_sp08_mt2 8

cs186_sp08_mt2 8 - Title → Genre Title Author →...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
b.2 Is this relation in BCNF? Is it in 3NF? Why or why not? c. Consider a relation with the following schema and functional dependencies: Recipes(Title, Genre, PreparationTime, Author, EstimatedCost)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Title → Genre Title, Author → PreparationTime, EstimatedCost c.1 Which attributes of the relation are prime? Why? c.2 Is the relation in 3NF? Why or why not?...
View Full Document

Ask a homework question - tutors are online