Question: 2. Have students read the Note on page 31. Ask them how they feel about using Social Security number as a primary key. Also ask

 2. Have students read the Note on page 31. Ask them
how they feel about using Social Security number as a primary key.

2. Have students read the Note on page 31. Ask them how they feel about using Social Security number as a primary key. Also ask them for additional databases where Social Security number is being used as a primary key other than banks and places of employment. Some examples are: insurance company, doctor's office, dentist's office. 1. Ask students for other examples of relations (tables) that could have more than one candidate key. Some examples are: state data that contain both state abbreviation and state name and inventory data that contain both a tag number and a serial number. 2. Have students read the Note on page 31. Ask them how they feel about using Social Security number as a primary key. Also ask them for additional databases where Social Security number is being used as a primary key other than banks and places of employment. Some examples are: Insurance company, doctor's office, dentist's office

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!