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...

________ contains four pairs of twisted-copper wire and supports speeds up to 100 Mbps over a maximum distance of 100 m.

a. Coaxial cable b. Fiber-optic cable c. Twisted pair d. Cat-5

Computer Science & Information Technology

Click the ________ button to advance through changes in a document, one a time

Fill in the blank(s) with correct word

Computer Science & Information Technology