图书馆数据库各个表.docx
- 文档编号:26315806
- 上传时间:2023-06-17
- 格式:DOCX
- 页数:13
- 大小:71.15KB
图书馆数据库各个表.docx
《图书馆数据库各个表.docx》由会员分享,可在线阅读,更多相关《图书馆数据库各个表.docx(13页珍藏版)》请在冰豆网上搜索。
图书馆数据库各个表
创建数据库
CREATEDATABASE[Library]ONPRIMARY
(NAME=N'Library',FILENAME=N'C:
\Users\Administrator\Desktop\DATA\Library.mdf',SIZE=3072KB,MAXSIZE=UNLIMITED,FILEGROWTH=1024KB)
LOGON
(NAME=N'Library_log',FILENAME=N'C:
\Users\Administrator\Desktop\DATA\Library_log.ldf',SIZE=1280KB,MAXSIZE=2048GB,FILEGROWTH=10%)
GO
ALTERDATABASE[Library]SETCOMPATIBILITY_LEVEL=100
GO
IF(1=FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC[Library].[dbo].[sp_fulltext_database]@action='enable'
End
创建Users表
/*
NavicatOracleDataTransfer
OracleClientVersion:
11.2.0.1.0
SourceServer:
g
SourceServerVersion:
110200
SourceHost:
localhost:
1521
SourceSchema:
SYSTEM
TargetServerType:
ORACLE
TargetServerVersion:
110200
FileEncoding:
65001
Date:
2012-05-0522:
43:
30
*/
------------------------------
--Tablestructurefor"SYSTEM"."Users"
------------------------------
DROPTABLE"SYSTEM"."Users";
CREATETABLE"SYSTEM"."Users"(
"ID"NUMBERNOTNULL,
"学号"VARCHAR2(10BYTE)NOTNULL,
"已借"NUMBERNULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
------------------------------
--RecordsofUsers
------------------------------
INSERTINTO"SYSTEM"."Users"VALUES('2','090210101','3');
INSERTINTO"SYSTEM"."Users"VALUES('3','090210102','0');
INSERTINTO"SYSTEM"."Users"VALUES('1','123456','0');
------------------------------
--Checksstructurefortable"SYSTEM"."Users"
------------------------------
ALTERTABLE"SYSTEM"."Users"ADDCHECK("ID"ISNOTNULL);
ALTERTABLE"SYSTEM"."Users"ADDCHECK("学号"ISNOTNULL);
创建Return_Table表
/*
NavicatOracleDataTransfer
OracleClientVersion:
11.2.0.1.0
SourceServer:
g
SourceServerVersion:
110200
SourceHost:
localhost:
1521
SourceSchema:
SYSTEM
TargetServerType:
ORACLE
TargetServerVersion:
110200
FileEncoding:
65001
Date:
2012-05-0522:
44:
56
*/
------------------------------
--Tablestructurefor"SYSTEM"."Return_Table"
------------------------------
DROPTABLE"SYSTEM"."Return_Table";
CREATETABLE"SYSTEM"."Return_Table"(
"ID"NUMBERNOTNULL,
"学号"VARCHAR2(10BYTE)NOTNULL,
"图书编号"VARCHAR2(50BYTE)NOTNULL,
"书名"VARCHAR2(50BYTE)NOTNULL,
"出版社"VARCHAR2(50BYTE)NULL,
"作者"VARCHAR2(50BYTE)NULL,
"借阅日期"VARCHAR2(50BYTE)NULL,
"还书日期"TIMESTAMP(6)NOTNULL,
"罚款"VARCHAR2(10BYTE)NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
------------------------------
--RecordsofReturn_Table
------------------------------
INSERTINTO"SYSTEM"."Return_Table"VALUES('6','090210101','7229975','行政职业能力测验','京华出版社','罗红军','011190012:
00AM',TO_TIMESTAMP('2012-04-1822:
59:
40:
133000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'0元');
INSERTINTO"SYSTEM"."Return_Table"VALUES('7','090210102','7294524','数据结构','清华大学','严蔚敏','011190012:
00AM',TO_TIMESTAMP('2012-04-1822:
59:
47:
587000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'0元');
INSERTINTO"SYSTEM"."Return_Table"VALUES('8','090210101','7229975','行政职业能力测验','京华出版社','罗红军','2012/4/20星期五21:
08:
52',TO_TIMESTAMP('2012-04-2021:
08:
59:
543000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'0元');
INSERTINTO"SYSTEM"."Return_Table"VALUES('9','090210101','7229975','行政职业能力测验','京华出版社','罗红军','2012/4/20星期五21:
11:
37',TO_TIMESTAMP('2012-04-2021:
11:
59:
530000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'0元');
------------------------------
--Checksstructurefortable"SYSTEM"."Return_Table"
------------------------------
ALTERTABLE"SYSTEM"."Return_Table"ADDCHECK("ID"ISNOTNULL);
ALTERTABLE"SYSTEM"."Return_Table"ADDCHECK("学号"ISNOTNULL);
ALTERTABLE"SYSTEM"."Return_Table"ADDCHECK("图书编号"ISNOTNULL);
ALTERTABLE"SYSTEM"."Return_Table"ADDCHECK("书名"ISNOTNULL);
ALTERTABLE"SYSTEM"."Return_Table"ADDCHECK("还书日期"ISNOTNULL);
创建borrow表
/*
NavicatOracleDataTransfer
OracleClientVersion:
11.2.0.1.0
SourceServer:
g
SourceServerVersion:
110200
SourceHost:
localhost:
1521
SourceSchema:
SYSTEM
TargetServerType:
ORACLE
TargetServerVersion:
110200
FileEncoding:
65001
Date:
2012-05-0522:
45:
49
*/
------------------------------
--Tablestructurefor"SYSTEM"."borrow"
------------------------------
DROPTABLE"SYSTEM"."borrow";
CREATETABLE"SYSTEM"."borrow"(
"ID"NUMBERNOTNULL,
"学号"NCHAR(10)NOTNULL,
"图书编号"NCHAR(10)NOTNULL,
"书名"VARCHAR2(50BYTE)NOTNULL,
"作者"VARCHAR2(50BYTE)NOTNULL,
"出版社"VARCHAR2(50BYTE)NOTNULL,
"借阅时间"TIMESTAMP(6)NOTNULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
------------------------------
--Recordsofborrow
------------------------------
------------------------------
--Checksstructurefortable"SYSTEM"."borrow"
------------------------------
ALTERTABLE"SYSTEM"."borrow"ADDCHECK("ID"ISNOTNULL);
ALTERTABLE"SYSTEM"."borrow"ADDCHECK("学号"ISNOTNULL);
ALTERTABLE"SYSTEM"."borrow"ADDCHECK("图书编号"ISNOTNULL);
ALTERTABLE"SYSTEM"."borrow"ADDCHECK("书名"ISNOTNULL);
ALTERTABLE"SYSTEM"."borrow"ADDCHECK("作者"ISNOTNULL);
ALTERTABLE"SYSTEM"."borrow"ADDCHECK("出版社"ISNOTNULL);
ALTERTABLE"SYSTEM"."borrow"ADDCHECK("借阅时间"ISNOTNULL);
创建books表
/*
NavicatOracleDataTransfer
OracleClientVersion:
11.2.0.1.0
SourceServer:
g
SourceServerVersion:
110200
SourceHost:
localhost:
1521
SourceSchema:
SYSTEM
TargetServerType:
ORACLE
TargetServerVersion:
110200
FileEncoding:
65001
Date:
2012-05-0522:
46:
33
*/
------------------------------
--Tablestructurefor"SYSTEM"."books"
------------------------------
DROPTABLE"SYSTEM"."books";
CREATETABLE"SYSTEM"."books"(
"图书编号"NCHAR(10)NOTNULL,
"bookID"NUMBERNOTNULL,
"书名"VARCHAR2(50BYTE)NULL,
"出版社"VARCHAR2(50BYTE)NULL,
"库存量"NUMBERNULL,
"总量"NUMBERNULL,
"类别"VARCHAR2(10BYTE)NULL,
"单价"FLOAT(126)NULL,
"入库时间"TIMESTAMP(6)NULL,
"作者"VARCHAR2(20BYTE)NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
------------------------------
--Recordsofbooks
------------------------------
INSERTINTO"SYSTEM"."books"VALUES('000003','3','离散数学','西安电子科技大学','10','5','计算机科学','25',TO_TIMESTAMP('2010-09-1000:
00:
00:
000000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'方世昌');
INSERTINTO"SYSTEM"."books"VALUES('0462990','4','平凡的世界','北京出版社','10','2','文学','25',TO_TIMESTAMP('2009-10-1500:
00:
00:
000000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'路遥');
INSERTINTO"SYSTEM"."books"VALUES('7226679','6','中国语文','重庆出版社','10','20','文学','15',TO_TIMESTAMP('2009-05-0600:
00:
00:
000000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'周先慎');
INSERTINTO"SYSTEM"."books"VALUES('7229975','5','行政职业能力测验','京华出版社','6','6','行政科学','50',TO_TIMESTAMP('2011-10-2000:
00:
00:
000000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'罗红军');
INSERTINTO"SYSTEM"."books"VALUES('7294524','1','数据结构','清华大学','10','10','计算机科学','32',TO_TIMESTAMP('2010-01-0500:
00:
00:
000000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'严蔚敏');
INSERTINTO"SYSTEM"."books"VALUES('7294541','2','编译原理','机械工业出版社','10','12','计算机科学','40',TO_TIMESTAMP('2011-05-1500:
00:
00:
000000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'Kemeth');
INSERTINTO"SYSTEM"."books"VALUES('7446250','7','从入门到精通ASP.NET','人民邮电出版社','11','33','计算机科学','59',TO_TIMESTAMP('2009-05-0600:
00:
00:
000000','YYYY-MM-DDHH24:
MI:
SS:
FF6'),'龙马创新教育研究室');
------------------------------
--Checksstructurefortable"SYSTEM"."books"
------------------------------
ALTERTABLE"SYSTEM"."books"ADDCHECK("图书编号"ISNOTNULL);
ALTERTABLE"SYSTEM"."books"ADDCHECK("bookID"ISNOTNULL);
创建Administrator管理员表
/*
NavicatOracleDataTransfer
OracleClientVersion:
11.2.0.1.0
SourceServer:
g
SourceServerVersion:
110200
SourceHost:
localhost:
1521
SourceSchema:
SYSTEM
TargetServerType:
ORACLE
TargetServerVersion:
110200
FileEncoding:
65001
Date:
2012-05-0522:
47:
08
*/
------------------------------
--Tablestructurefor"SYSTEM"."Administrator"
------------------------------
DROPTABLE"SYSTEM"."Administrator";
CREATETABLE"SYSTEM"."Administrator"(
"ID"NUMBERNOTNULL,
"admin_name"VARCHAR2(10BYTE)NOTNULL,
"admin_password"VARCHAR2(10BYTE)NOTNULL,
"admin_limit"NUMBERNOTNULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
------------------------------
--RecordsofAdministrator
------------------------------
INSERTINTO"SYSTEM"."Administrator"VALUES('2','admin','admin','1');
INSERTINTO"SYSTEM"."Administrator"VALUES('7','aaa','aaa','0');
INSERTINTO"SYSTEM"."Administrator"VALUES('8','sss','sss','0');
------------------------------
--Checksstructurefortable"SYSTEM"."Administrator"
------------------------------
ALTERTABLE"SYSTEM"."Administrator"ADDCHECK("ID"ISNOTNULL);
ALTERTABLE"SYSTEM"."Administrator"ADDCHECK("admin_name"ISNOTNULL);
ALTERTABLE"SYSTEM"."Administrator"ADDCHECK("admin_password"ISNOTNULL);
ALTERTABLE"SYSTEM"."Administrator"ADDCHECK("admin_limit"ISNOTNULL);
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 图书馆 数据库 各个