图书管理系统数据库创建.docxVIP

图书管理系统在 1.创建数据库 SQL Server 2005数据库中的创建代码 create database BookSys on ( name = BookSys , filename = D:\BookSysDB\BookSys.mdf size = 3 , filegrowth = 10 % ) log on ( name = BookSys_log , filename = D:\BookSysDB\BookSys_log.ldf size = 1 , filegrowth = 1 ) Go 创建表 (1)创建管理员(admin)信息表 use BookSys go create table ( admin ( adminId varchar ( 10 ) not null adminName varchar (4) not null, adminSex varchar (2) not null, adminAge adminPass int not null, varchar ( 10 ) not null Go (2)创建读者(reader)信息表 use BookSys go create table i reader ( readerId varchar ( 10 ) not null, readerPass varchar ( 10 ) not null,