Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A candidate key is an attribute (or combination of attributes) that uniquely identifies each individual entity instance in a database. I am designing a database
A candidate key is an attribute (or combination of attributes) that uniquely identifies each individual entity instance in a database. I am designing a database of historical houses in North Carolina that are still in existence at their original location. Which of the following attribute or attribute combinations could be a candidate key?
- A. The ZIP code portion of the house's address.
- B. The year the house was built.
- C. The name of the original owner of the house.
- D. None of the above; you'd need to generate a "HouseID" number.
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