数据库第五次作业

ALTER TABLE SC ADD CONSTRAINT SC_SNO FOREIGN KEY (SNO) REFERENCES S(SNO), ADD CONSTRAINT SC_CNO FOREIGN KEY (CNO) REFERENCES C(CNO);

ALTER TABLE SC DROP CONSTRAINT SC_SNO,SC_CNO;//

ALTER TABLE C ADD CONSTRAINT cfk FOREIGN KEY (cpno) REFERENCES C(cno);

insert into c select * from system.C;

INSERT INTO SC

SELECT  * FROM  System.SC

WHERE SNO(SELECT SNO FROM S

WHERE S.SNO = System.SC.SNO)

AND CNO (SELECT CNO FROM C WHERE C.CNO =   System.SC.CNO);

 

**DISTINCT**

ALTER TABLE S ADD CONSTRAINT sexbd            CHECK (ssex IN ('男','女') AND (

    (SSEX = '男' AND SBIRTHDATE BETWEEN '19980101' AND '20071231')        

  OR        

    (SSEX = '女' AND SBIRTHDATE BETWEEN '19980101' AND '20070101')    

));

ALTER TABLE S DROP CONSTRAINT Sexbd;

UPDATE S SET SBIRTHDATE='20070101' WHERE SNO='22670236';