You have two tables in the HR database, HR.EmployeeName and HR.EmployeeAddress, with columns as follows: You need to ensure that there are no duplicate values in the Social Security Number field. How should you do that?

You have two tables in the HR database, HR.EmployeeName and HR.EmployeeAddress, with columns as follows: You need to ensure that there are no duplicate values in the Social Security Number field. How should you do that?

You have two tables in the HR database, HR.EmployeeName and HR.EmployeeAddress, with columns as follows:

You need to ensure that there are no duplicate values in the Social Security Number field. How should you do that?

Answer: – Add a unique constraint to the field

(You have identified the EmployeeID field as the primary key, which by itself enforces uniqueness. Neither a default constraint nor a foreign key is required in this situation.)