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.

Help Nisha to identify the constraint which should be applied to the attribute NAME such that the Employees' Names cannot be left empty or NULL while entering the records but can have duplicate values.

Answer 1

NOT NULL: Restricts input of NULL values but allows duplicate values.