种类char(8), 数量tinyint, 存放位置char(8) )

create table 出版社

(书号char(16) foreign key references 书籍(书号) on delete no action on update cascade, 出版社名char(16), 电话char(16), 地址char(20), 邮编char(6),

primary key(书号,出版社名)

)

create table 借书人

(借书证号char(20) primary key, 姓名char(8), 单位char (30)

)

create table 借阅

(书号char(16) foreign key references 书籍(书号) on delete no action on update cascade,

借书证号char(20) foreign key references 借书人(借书证号) on delete no action on update cascade, 借书日期datetime, 还书日期datetime,

primary key(书号,借书证号) )

5.3 数据库的表间关联

6 感想与体会