Kekoa Konani is chairman of the Chatty Chihuahua Club,where he maintains a database of registered purebred Chihuahuas and their breeding history.One table will store the name,birth date,and other characteristics of all of the registered Chihuahuas.Each Chihuahua is uniquely identified by a registration number.A second table will contain data that link each Chihuahua to its male and female parents by means of their registration numbers.The primary key in the first table is
A) name.
B) registration number.
C) date of birth.
D) relationship number.

Question

Quizplus · Accepted Answer

The registration number is the most appropriate choice for a primary key as it is a unique identifier for each Chihuahua in the database. Using the name or date of birth may not be reliable as there could be multiple Chihuahuas with the same name or birth date, whereas each Chihuahua has a unique registration number. The relationship number is not relevant as it is not a unique identifier for each Chihuahua.

Kekoa Konani Is Chairman of the Chatty Chihuahua Club,where He