Question
Suppose a table contains, among others, the following columns StdNo, Section, Grade and it is known that both StdNo,Section,Grade and StdNo,Section are superkeys but that
Suppose a table contains, among others, the following columns StdNo, Section, Grade and it is known that both StdNo,Section,Grade and StdNo,Section are superkeys but that neither StdNo nor Section is a superkey. Which ONE of the following is TRUE?
Select one:
a. Either StdNo or Section could be chosen as the primary key.
b. StdNo,Section could be chosen as the primary key but not a as candidate key.
c. StdNo,Section,Grade could be chosen as the primary key.
d. StdNo,Section is a candidate key and could serve as the primary key.
e. StdNo,Section,Grade is a candidate key.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started