新建 文本文档.txt

本课题是图书管理信息系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[书籍信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[书籍信息]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[借阅信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[借阅信息]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书类别]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[图书类别]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[系统管理]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[系统管理]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[读者信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[读者信息]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[读者类别]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[读者类别]
GO

CREATE TABLE [dbo].[书籍信息] (
	[书籍编号] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[书名] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[类别] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[作者] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[出版社] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[出版日期] [smalldatetime] NULL ,
	[登记日期] [smalldatetime] NULL ,
	[是否被借出] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[借阅信息] (
	[借阅编号] [int] NULL ,
	[读者编号] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[读者姓名] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[书籍编号] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[书籍名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[出借日期] [smalldatetime] NULL ,
	[还书日期] [smalldatetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[图书类别] (
	[类别名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[类别编号] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[系统管理] (
	[用户名] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[密码] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[权限] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[读者信息] (
	[读者姓名] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[读者编号] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[性别] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[读者类别] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[工作单位] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[家庭地址] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[电话号码] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[登记日期] [smalldatetime] NULL ,
	[已借书数量] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[读者类别] (
	[种类名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[借书数量] [int] NULL ,
	[借书期限] [int] NULL ,
	[有效期限] [int] NULL 
) ON [PRIMARY]
GO