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
- Spring '08
- Relational model, Candidate key, Database normalization, following Schema, Type Lab Technician Lab Type Fee