You are the database developer for a company that provides consulting service. The company maintains data about its
employees in a table named Employee.
The script that was used to create the Employee table is shown in the exhibit.
CREATE TABLE Employee
EmployeeID int NOT NULL;
EmpType char (1) NOT NULL,
EmployeeName char (50) NOT NULL,
Address char (50) NULL,
Phone char (20) NULL,
CONSTRAINT PK_Employee PRMARY KEY (Employee ID)
The EmpType column in this table is used to identify employees as executive, administrative, or consultants.
You need to ensure that the administrative employees can add, update, or delete data for non-executive employees only.
What should you do?