数据库实验习题2.3.sql

数据库第二章习题程序

/*USE SCHOOL
CREATE TABLE WORKER(
NUMBER CHAR(5),
NAME CHAR(20) CONSTRAINT U1 UNIQUE,
SEX CHAR(8),
SAGE INT CONSTRAINT U2 CHECK(SAGE<=28),
DEPARTMENT CHAR(20),
CONSTRAINT PK_WORKER PRIMARY KEY(NUMBER))*/

/*USE SCHOOL
INSERT INTO WORKER VALUES('00001','YongLi','MALE',24,'SCIENCE_DEPARTMENT')*/

/*USE SCHOOL
ALTER TABLE WORKER DROP U2*/

/*USE SCHOOL
INSERT INTO WORKER VALUES('00002','FangWang','FEMALE',22,'SCIENCE_DEPARTMENT')*/

/*USE SCHOOL
GO
CREATE RULE RULE_SEX AS @VALUE IN ('FEMALE','MALE')
GO
EXEC SP_BINDRULE RULE_SEX, 'WORKER.[SEX]'*/

/*(1)
USE SCHOOL
ALTER TABLE WORKER 
ADD CONSTRAINT U3 CHECK(SAGE>=0)*/

/*(2)
USE SCHOOL
GO 
CREATE RULE RULE_SAGE AS @SAGE>=1 AND @SAGE<=100
GO
EXEC SP_BINDRULE RULE_SAGE, 'WORKER.[SAGE]'*/