书店销售管理子系统数据库设计(6)

3.数据库源代码

3.1数据库建立

3.1.1创建数据库 USE master GO

CREATE DATABASE librarysystem ON

( NAME = librarysystem,

FILENAME = 'd:\librarysystem.mdf', SIZE = 10,

MAXSIZE = 50, FILEGROWTH = 5 ) LOG ON

( NAME = 'library',

FILENAME = 'd:\librarysystem.ldf', SIZE = 5MB,

MAXSIZE = 25MB, FILEGROWTH = 5MB ) GO

3.1.2书本类别表建立 create table book_style (

bookstyleno varchar(30) primary key, bookstyle varchar(30) )

3.1.3创建书库表

create table system_books (

bookid varchar(20) primary key, bookname varchar(30) Not null, bookstyleno varchar(30) Not null, bookauthor varchar(30), bookpub varchar(30) ,