正在加载图片...
2) CREATE TABLE P( PNo INT PRIMARY KEY, PName CHAR(30), PPrice CHAR(30) }: 3) CREATE TABLE Sell( SNo INT, PNo INT, Sell_Number CHAR(30), Sell_Date DATE, PRIMARY KEY (SNo,PNo), FOREIGN KEY (SNo)REFERENCES S(SNo), FOREIGN KEY (PNo)REFERENCES P(PNo) }: 三、(每小题6分,共18分) I)GRANT SELECT,INSERT(SNo,PNo)ON Sell TO大中电器商店; 2)CREATE INDEX PNolndex ON P(PNo); 3)DELETE FROM Sell WHERE PNo=1200236; DELETE FROM P WHERE PNo=1200236; 4342) CREATE TABLE P{ PNo INT PRIM ARY KEY PName CHAR(30) PPrice CHAR(30) }; 3) CREATE TABLE Sell { SNo INT PNo INT Sell_Number CHAR(30) Sell Date DATE PRIMARY KEY (SNo,PNo) FOREIGN KEY (SNo) REFERENCES S(SNo) FOREIGN KEY (PNo) REFERENCES P(PNo) 三、(每小题 6分.共 18分) 1) GRANT SELECT , INSERT(SNo, PNo) ON Sell TO大中电器商店 2) CREATE INDEX PNoIndex ON P(PNo); 3)DELETE FROM Sell W HERE PNo= 1200236 DELETE FROM P W HERE PNo= 1200236 434
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有