数据库课程设计-图书管理系统。

Рid主键Рclerk-nameРcharР50Р是Р否Р管理名称Рclerk-pwdРintР50Р是Р否Р管理密码Р其他表的逻辑模型略Р3.4.物理设计Р3.4.1.创建数据库РUSE masterРGOРCREATE DATABASE libraryРON Р( NAME = library,Р FILENAME = 'd:\library.mdf',Р SIZE = 10,Р MAXSIZE = 50,Р FILEGROWTH = 5 )РLOG ONР( NAME = 'library',Р FILENAME = 'd:\library.df',Р SIZE = 5MB,Р MAXSIZE = 25MB,Р FILEGROWTH = 5MB )РGOР3.4.2.书籍表的创建Рcreate table bookР( Р Book-id varint(20) primary key,Р Book-name varchar(30) Not null, Р Book-author varchar(30),Р Book-publish varchar(30) ,Р Book-date datetime,Р bookindate datetime ,Р isborrowed varchar (2) ,Р)Р3.4.3.管理员表Рcreate table clerkР( Р clerk-id varint(20) primary key,Р Clerk-name varchar(30) Not null, Р Clerk-psw varint(20) not null,Р)Р3.4.4.读者表Рcreate table readerР( Р reader-id varint(20) primary key,Р reader-name varchar(30) Not null,