Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OCA Oracle Database SQL Exam Guide Exam 1Z0-071

Authors: Steve O'Hearn

1st Edition

1259585492, 978-1259585494

More Books

Students also viewed these Databases questions

Question

4. Show the trainees how to do it again.

Answered: 1 week ago

Question

8. Praise the trainees for their success in learning the task.

Answered: 1 week ago