Nisha is assigned the task of maintaining the staff data of an organization. She has to store the details of the staff in the SQL table named EMPLOYEES with attributes as EMPNO, NAME, DEPARTMENT, BASI

Question

Nisha is assigned the task of maintaining the staff data of an organization. She has to store the details of the staff in the SQL table named EMPLOYEES with attributes as EMPNO, NAME, DEPARTMENT, BASICSAL to store Employee's Identification Number, Name, Department and Basic Salary respectively. There can be two or more Employees with the same name in the organization.

(i) (a) Help Nisha to identify the attribute which should be designated as the PRIMARY KEY. Justify your answer

Accepted Answer

EMPNO. It is unique for every employee.

Question 27i

Answer

Explanation