CREATE TABLE Sailors
(Sid char(10)PRIMARY KEY,
sname char(20),
rating int ,
age int
);
CREATE TABLE Boats
(bid char(10)PRIMARY KEY,
bname char(20) NOT NULL,
color char(10)
);
CREATE TABLE Reserves
(Sid char(10) ,
bid char(10),
rdate date,
PRIMARY KEY(Sid,bid,rdate),
FOREIGN KEY(Sid)REFERENCES Sailors(Sid),
FOREIGN KEY(bid)REFERENCES Boats(bid),
);
insert into Sailors (Sid ,Sname,rating,age )
values
('22','dustin',7,45),
('29','brustus',1,33),
('31','lubber',8,56),
('32','andy',8,26),
('58','rusty',10,35),
('64','horati',7,35),
('71','zorba',10,35),
('74','horatio',9,35),
('85','art',3,26),
('86','john',1,17),
('95','bob',3,64),
('96','frodo',3,26),
('98','tom',3,17);
insert into Boats (bid ,bname ,color )
values (101 , 'A' , 'red'),
(102 , 'B' , 'green' ),
(103 , 'C' , 'blue '),
(104 , 'D' , 'white') ,
(105 , 'E' , 'red '),
(106 , 'F' , 'blue '),
(107 , 'G' , 'green') ;
insert into Reserves (Sid ,bid ,rdate )
values ( 22 , 101 , '2010-01-08' ),
( 22 , 102 , '2010-01-09' ),
( 29 , 103 , '2010-01-09' ),
( 31 , 102 , '2010-02-11' ),
( 22 , 104 , '2010-03-08' ),
( 22 , 103 , '2010-03-10' ),
( 32 , 105 , '2010-03-11' ),
( 32 , 106 , '2010-03-18' ),
( 32 , 102 , '2010-03-19' ),
( 58 , 104 , '2010-03-20' ),
( 64 , 105 , '2010-03-20' ),
( 95 , 101 , '2010-04-02' ),
( 85 , 102 , '2010-04-05' ),
( 22 , 101 , '2010-04-07' ),
( 22 , 105 , '2010-05-01' ),
( 22 , 106 , '2010-06-18' ),
( 22 , 107 , '2010-07-09' ),
( 31 , 106 , '2010-08-06' ),
( 32 , 105 , '2010-08-06' ),
( 29 , 104 , '2010-08-07' ),
( 64 , 103 , '2010-09-05' ),
( 58 , 102 , '2010-09-09' ),
( 64 , 104 , '2010-11-03' ),
( 64 , 105 , '2010-11-04' ),
( 31 , 106 , '2010-12-06' );
最新发布
博客记录了两项收获，一是实现了主界面与dll浏览器的结合，二是完成了log文件的封装，这些内容与信息技术相关。
扫一扫
5498
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
