數(shù)據(jù)庫課程設(shè)計--圖書管理系統(tǒng)-文庫吧
2025-01-01 17:01 本頁面
【正文】 文件的物理名稱 size = 30MB, 主數(shù)據(jù)文件的初始大小 maxsize = unlimited, 主數(shù)據(jù)文件增長的最大值 filegrowth = 10 主數(shù)據(jù)文件的增長率)Log ON( /*日志文件的具體描述,各參數(shù)含義同上*/ NAME = LibraryMs_log, FILENAME = 39。E:\YY\39。, size = 1MB, maxsize = 100MB, filegrowth = 2MB)Use db_Library============================ 管理員登陸表 ============================CREATE TABLE tb_admin( a_id varchar(50) not null primary key, 管理員編號 a_name varchar(50) not null, 管理員登陸名 a_pwd varchar(30) not null 管理員密碼)insert into tb_admin values(39。YY231439。,39。yanyan39。,39。12345639。)。insert into tb_admin values(39。HLZ53139。,39。huangzhuli39。,39。12345639。)。insert into tb_admin values(39。MSL86439。,39。moshanlan39。,39。12345639。)。insert into tb_admin values(39。ZS768439。,39。zhangshan39。,39。12345639。)。insert into tb_admin values(39。LS951239。,39。lisi39。,39。12345639。)。============================ 書架信息表 ============================CREATE TABLE tb_bookcase( /*描述書存放的位置*/ c_id varchar(30) not null primary key, 書架編號 c_name varchar(30) not null, 書架名稱)insert into tb_bookcase values(39。GL145739。,39。信息39。)insert into tb_bookcase values(39。WX318639。,39。文學(xué)39。)insert into tb_bookcase values(39。TW786639。,39。天文39。)insert into tb_bookcase values(39。DL658139。,39。地理39。)insert into tb_bookcase values(39。WL864539。,39。物理39。)============================ 圖書類型信息表 ============================CREATE TABLE tb_booktype( t_id int IDENTITY (1,1) not null primary key, 類型編號 t_name varchar(30) not null, 類型名稱 t_days int not null, 可借天數(shù))insert into tb_booktype values(39。數(shù)據(jù)結(jié)構(gòu)39。,30)insert into tb_booktype values(39。數(shù)學(xué)39。,30)insert into tb_booktype values(39。散文39。,30)insert into tb_booktype values(39。地理39。,30)insert into tb_booktype values(39。物理39。,30)============================ 管理員權(quán)限表 ============================CREATE TABLE tb_purview( p_id int IDENTITY (1,1) primary key not null, 編號 a_id varchar(50) not null foreign key (a_id) references tb_admin(a_id), 管理員編號 p_sysset varchar(6) not null, 系統(tǒng)設(shè)置權(quán)限 p_readset varchar(6) not null, 讀者管理權(quán)限 p_bookset varchar(6) not null, 圖書管理權(quán)限 p_borrowback varchar(6) not null, 圖書借還管理權(quán)限 p_sysquery varchar(6) not null 系統(tǒng)查詢權(quán)限)insert into tb_purview values(39。YY231439。,39。true39。,39。true39。,39。true39。,39。true39。,39。true39。)insert into tb_purview values(39。HLZ53139。,39。true39。,39。true39。,39。false39。,3
電大資料相關(guān)推薦
鄂ICP備17016276號-1