Im having a little trouble with the following problem
CREATE TABLE Report(
Grade CHAR (2),
CHECK(Grade in ('A','B', 'C')),
UNIQUE(SSN, ReportCode, Term),
PRIMARY KEY(Id, ReportCode, Term)
My questions are:
1. are the candidate keys (SSN, ReportCode, Term) ?
2. is the primary key SSN or Id. Im not sure since I read that primary key should be one of the candidate keys, but SSN is not listed where it says Primary key.
3. are the superkeys (Id, ReportCode, Term) ?
Thanks for any help, i really appriciate it. Im still trying to get the hang of all this.