EXAMRADAR

Question: A Super keys for which no proper subset is a super key. Such a minimal Super keys are called _______

Answer:

It is possible that several distinct sets of attributes could serve as a candidate key. Suppose that a combination of customer-name and customer-street is sufficient to distinguish among members of the customer entity set. Then, both {customer-id} and {customer-name, customer-street} are candidate keys. Although the attributes customer-id and customer-name together can distinguish customer entities, their combination does not form a candidate key, since the attribute customer-id alone is a candidate key

MCQ: A Super keys for which no proper subset is a super key. Such a minimal Super keys are called _______

Correct Answer: A. Primary key

Explanation:

It is possible that several distinct sets of attributes could serve as a candidate key. Suppose that a combination of customer-name and customer-street is sufficient to distinguish among members of the customer entity set. Then, both {customer-id} and {customer-name, customer-street} are candidate keys. Although the attributes customer-id and customer-name together can distinguish customer entities, their combination does not form a candidate key, since the attribute customer-id alone is a candidate key

Discuss a Question

Related Questions

You may be interested in:

Advanced Database Management System MCQs

Recently Added Articles

How Can AI Simplify the Academic Life of Students?

How Can AI Simplify the Academic Life of Students?

Last updated on: April 16, 2025Posted by: ExamRadar

Want to Clear IBPS RRB PO? Master These Mock Test Hacks!

Last updated on: March 10, 2025Posted by: ExamRadar

Top AI Tools for Instantly Detecting Plagiarized Writing

Last updated on: December 5, 2024Posted by: ExamRadar

5 Important Tools for System Administrators

Last updated on: December 1, 2024Posted by: ExamRadar

Image to Text Conversion Made Easy: Online Tool Insights

Last updated on: April 12, 2024Posted by: ExamRadar

Tips to Write an Email: Pro Email Writing Tips

Last updated on: March 20, 2024Posted by: ExamRadar

Yellow diamond: the market worth and value

Last updated on: March 9, 2024Posted by: ExamRadar