cs186_sp08_mt2 7

cs186_sp08_mt2 7 - b Consider a relation with the following...

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

View Full Document Right Arrow Icon
3. Functional dependencies and normalization (12 points) a. Consider a relation with the following schema and functional dependencies: Tests(PatientID, DoctorID, TestDate, Type, Lab, Technician, Fee, ResultDate, Status); PatientID, DoctorID TestDate PatientID, TestDate, Type Lab Technician Lab Type Fee PatientID, TestDate, Type ResultDate, Status a.1 Is this relation in BCNF? Why or why not?
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: b. Consider a relation with the following schema and functional dependencies: AstronomicalObjects(MessierNumber, CommonName, Coordinates, Type, Distance, Galaxy) MessierNumber → CommonName CommonName → Coordinates, Type MessierNumber → Distance CommonName → MessierNumber, Galaxy b.1 What are the candidate keys for this relation? Also, give at least one superkey....
View Full Document

This note was uploaded on 08/30/2009 for the course CS 186 taught by Professor Staff during the Spring '08 term at Berkeley.

Ask a homework question - tutors are online