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.
- Spring '08