Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

What will be an ideal response?


A primary key field is a field that contains unique information for each record. Using an employee's last name as the primary key field would be a poor choice because it does not allow for employees with the same last name.

Computer Science & Information Technology

You might also like to view...

The page setup dialog box Header/Footer tab is one way of adding a header and/or footer to your spreadsheet

Indicate whether the statement is true or false

Computer Science & Information Technology

When using a style for a second paragraph of a document use ________ style

Fill in the blank(s) with correct word

Computer Science & Information Technology

To insert an image into Word from a digital camera or memory card, it is best to first transfer it to your hard drive, flash drive, or floppy disk

Indicate whether the statement is true or false

Computer Science & Information Technology

?TheUnified Modeling Language (UML) notation _____ identifies a zero or many relation.

A. ?0..1 B. ?1..* C. ?0..* D. ?0..0

Computer Science & Information Technology