Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 8 (1 point) Suppose a table contains, among others, the columns student_number, email_address, student_name, student_address. Suppose further that email_address and student_number are each known
Question 8 (1 point) Suppose a table contains, among others, the columns student_number, email_address, student_name, student_address. Suppose further that email_address and student_number are each known to be unique and also the combination of student_name and student_address together is known to be unique. Which ONE of the following statements is TRUE? If student_address was known to be unique then the combination of student_address, student_name could be a candidate key but not a superkey. email_address or student_number are both minimal keys but the combination of student_name, student_address cannot be a minimal key because it would not be a key with the fewest number of columns. If student_address was known to be unique then the combination of student_address,student_name could not be chosen as the primary key. The combination student_address,student_name could be a candidate key if it was also a foreign key. email_address or student_number are candidate keys but student_name,student_address taken together is definitely not 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