【文章內容簡介】 圖 錯誤 !未找到引用源。 6 信息 實體 ER 總圖 . 數(shù)據(jù)流程圖： . 關系圖： 4. 數(shù)據(jù)庫源代碼 . 數(shù)據(jù)庫建立 創(chuàng)建數(shù)據(jù)庫 USE master GO CREATE DATABASE bookshopsystem ON ( NAME = bookshopsystem， FILENAME = 39。d： \39。， SIZE = 10， MAXSIZE = 50， FILEGROWTH = 5 ) LOG ON ( NAME = 39。bookshop39。， FILENAME = 39。d： \39。， SIZE = 5MB， MAXSIZE = 25MB， FILEGROWTH = 5MB ) GO . 創(chuàng)建顧客表 create table system_customers （ customerid varchar(20) primary key， customername varchar(30) not null, customeraddress varchar(30) not null, customerlink varchar(20) not null, ordernumber varchar(20) not null, foreign key (ordernumber) references system_ordernumbers (ordernumber), ) . 創(chuàng)建書籍表 create table system_books ( bookid varchar(20) primary key， bookname varchar(30) not null, boostyle varchar(30) not null, bookauthor varchar(20) not null, bookpub varchar(30) not null, bookpubdate datetime not null, bookprice varchar(10） not null, ) . 創(chuàng)建訂單表 create table system_ordernumbers ( ordernumber varchar(20) primary key， bookid varchar(20) not null, customerid varchar(20) not null, customername varchar(30) not null, customeraddress varchar(30) not null, customerlink varchar(20) not null, booknumber varchar(10) not null, orderdate datetime not null, deliverdate datetime not null, bookprice varchar(10) not null, foreign key (bookid) references system_books (bookid), foreign key (customerid) references system_customers (customerid), ) . 創(chuàng)建管理員表 create table system_managers （ managerid varchar(10) primary key， managerrole varchar(20) not null, ) 創(chuàng)建庫存表 create table system_store （ bookid varchar(20) not null, storenumber varchar(10) not null, bookprice varchar(10) not null, foreign key (bookid) references system_books (bookid), ) . 數(shù)據(jù)初始化 . 將已有的顧客加入 system_customers 表中 insert into system_customers(customerid , customername , customeraddress , customerlink , ordernumber ) values(39。28528752039。 , 39。朵林 39。,39。北京市西城區(qū)德外大街 4 號 39。,39。1390765421739。,39。00139。)。 insert into system_customers(customerid , customername , customeraddress , customerlink , ordernumber ) values(39。28528752139。,39。張小玲 39。,39。北京市海淀區(qū)圓明園西路 2 號 39。,39。1369894326839。,39。00239。)。 insert into system_customers(customerid , customername , customeraddress , customerlink , ordernumber ) values(39。28528752239。,39。馬思遠 39。,39。北京市百萬莊大街 22 號 39。,39。1352741630539。,39。00339。)。 insert into system_customers(customerid , customername , customeraddress , customerlink , ordernumber ) values(39。28528752339。,39。劉俊彥 39。,39。廣州市藝苑路東慶街 2 號 39。,39。1396202578239。,39。00439。)。 insert into system_customers(customerid , customername , customeraddress , customerlink , ordernumber ) values(39。28528752439。,39。夏林 39。,39。上海市肇嘉路 366 號 39。,39。1397658438939。,39。00539。)。 insert into system_customers(customerid , customername , customeraddress , customerlink , ordernumber ) values(39。28528752539。,39。慕芝陽 39。,39。上海市淮海中路 222 號 39。,39。1512069698639。,39。00639。)。 . 將已有的圖書加入 system_books 表中 insert into system_books(bookid, bookname, boostyle, bookauthor, bookpub, bookpubdate, bookprice ) values(39。00125