一个让我迷惑的问题,高分求解

[anneyang]

You are the database developer for a company that provides consulting services. The company maintains data about its employees in a table named Employee. The script that was used to create the employee table is shown below:

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 emp type column is 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?

[CSDNM]

很简单，定义emptype字段的编码为1-executive,2- administrative, 3-consultants，在程序里控制只能操作emptype比他大的员工。

[徐春华]

It's a good idea.

[windindance]

CSDNM的方法极妙。

[xiaolun]

随你怎么控制啦！在前端可以，在后端也行！
不知道这道题究竟想考什么！！！

[anneyang]

to yinzhen(yinzhen) :
请详细解释一下,你的解决方案.

[yinzhen]

用 With Check Option選項生成一個View