【文章內(nèi)容簡(jiǎn)介】 簇。當(dāng)然我們還應(yīng)當(dāng)看到建立和維護(hù)聚簇的開銷并不小，應(yīng)當(dāng)綜合各方面因素權(quán)衡利弊，考慮相應(yīng)的實(shí)施方案。 當(dāng)然，在方案的評(píng)價(jià)與實(shí)施的過程當(dāng)中，相關(guān)人員應(yīng)當(dāng)從各方案的存儲(chǔ)空間、存取時(shí)間以及維護(hù)代價(jià)等方面進(jìn)行考慮，而在實(shí)施的過程中，也密切關(guān)注系統(tǒng)的運(yùn)行，對(duì)數(shù)據(jù)庫(kù)的物理結(jié)構(gòu)設(shè)計(jì)方案進(jìn)行相應(yīng)的調(diào)整。6 數(shù)據(jù)庫(kù)實(shí)施和維護(hù) 建立數(shù)據(jù)庫(kù)及相關(guān)表1. 建立數(shù)據(jù)庫(kù)CREATE DATABASE 咖啡館管理系統(tǒng)ON ( NAME =cafe_data, FILENAME = 39。C:\Documents and Settings\Administrator\桌面\新建文件夾\39。, SIZE = 1MB, MAXSIZE = 20MB, FILEGROWTH = 10%) LOG ON ( NAME =cafe_log, FILENAME = 39。C:\Documents and Settings\Administrator\桌面\新建文件夾\39。, SIZE = 1MB, MAXSIZE = 10MB, FILEGROWTH = 10%)GO2. 建表/*員工表*/create table 員工表( Wnum char(4) primary key, Wname varchar(10) not null, Wsex char(2) default 39。男39。 check(Wsex in(39。男39。,39。女39。)), Win smalldatetime not null, WID char(18) unique, Wtel varchar(20) not null, Wgrade decimal(6,2) not null, Wadd varchar(255) not null,)。/*供應(yīng)商信息表*/create table 供應(yīng)商信息表( Snum char(10) primary key, Sname varchar(100) not null, Stel varchar(20) not null, Sadd varchar(255) not null, Scoo int not null, Sdiscount Varchar(255) not null, Scredit int not null, Smark varchar(255))。/*會(huì)員表*/create table 會(huì)員表( Cnum char(10) primary key, Cname varchar(10) not null, Csex char(2) default 39。男39。 check(Csex in(39。男39。,39。女39。)), Cbirthdate smalldatetime not null, Caddr varchar(255) not null, Ctel varchar(20) not null, Cvip char(10) not null default 39。普卡39。, Cdlevel decimal(3,2) default 39。39。 check(Cdlevel between and ))。/*原材料*/create table 原材料表( Mnum char(10) primary key, Mname varchar(20) not null, Mprice money not null, Mtotal decimal(10,2) not null, Mstoretime char(2) not null, Snum char(10) references 供應(yīng)商信息表(Snum))。/*產(chǎn)品信息*/create table 產(chǎn)品信息表( Pnum char(10) primary key, Pname varchar(20) not null, Ppri money not null, Psize char(2) not null, Ppdate datetime not null, Psdate char(2) not null, Pmark varchar(255))。/*銷售單*/create table 銷售單( Snum char(10) primary key, Pnum char(10) references 產(chǎn)品信息表(Pnum), Wnum char(4) references 員工表(Wnum), Saccount money not null, Sdate datetime not null, Smark Varchar(255))。/*采購(gòu)單*/create table 采購(gòu)單( Bnum char(10) primary key, Snum char(10) references 供應(yīng)商信息表(Snum), Wnum char(4) references 員工表(Wnum),Mnum char(10) references 原材料表(Mnum),Saccount decimal(10,2) not null,Sdate datetime not null,Bsum decimal(10,2) not null,Bmark Varchar(255))。/*銷售明細(xì)*/create table 銷售明細(xì)( Snum char(10) references 銷售單(Snum), Pnum char(10) references 產(chǎn)品信息表(Pnum), Bquantity decimal(10,2) not null, constraint order_flo_pk primary key(Snum,Pnum))。3. 記錄錄入/*員工表信息錄入*/insert into 員工表 values(39。100139。,39。陳一39。,39。男39。,39。201112339。,39。13028219880212115639。,39。1804256235639。,39。300039。,39。浙江省杭州市江干區(qū)39。)insert into 員工表 values(39。100239。,39。范二39。,39。女39。,39。20115639。,39。33028219880813456939。,39。1874561235639。,39。320039。,39。浙江省杭州市下城區(qū)39。)insert into 員工表 values(39。100339。,39。付三39。,39。男39。,39。20116639。,39。33025019890105125639。,39。1350571256339。,39。280039。,39。浙江省杭州市西湖區(qū)39。)insert into 員工表 values(39。100539。,39。高武39。,39。男39。,39。20116639。,39。33012019900109485639。,39。1360663125639。,39。208839。,39。浙江省杭州市西湖區(qū)39。)insert into 員工表 values(39。101039。,39。胡圖39。,39。男39。,39。201182039。,39。33014519910418963239。,39。1378954145439。,39。208839。,39。浙江省溫州市樂清39。)insert into 員工表 values(39。101139。,39。青海39。,39。男39。,39。20115639。,39。33045619910826544539。,39。1335688585539。,39。300039。,39。浙江39。)insert into 員工表 values(39。106039。,39。張?chǎng)?9。,39。女39。,39。20117139。,39。33058019920726589739。,39。1886565852539。,39。208839。,39。浙江省寧波市江東區(qū)39。)insert into 員工表 values(39。111139。,39。藏老板39。,39。男39。,39。2010121239。,39。33028219910506121239。,39。1888856885639。,39。500039。,39。浙江省寧波市彩虹小區(qū)39。)/*供應(yīng)商信息表錄入*/insert into 供應(yīng)商信息表 (Snum,Sname,Stel,Sadd,Scoo,Sdiscount,Scredit,Smark)values (39。000139。, 39。醇香咖啡原料有限公司39。, 39。05712567389439。, 39。杭州市下城區(qū)13號(hào)路675號(hào)39。, 39。57839。, 39。39。,39。1039。,null)。insert into 供應(yīng)商信息表 (Snum,Sname,Stel,Sadd,Scoo,Sdiscount,Scredit,Smark)values (39。000239。, 39。飄香咖啡豆有限公司39。, 39。05758587896439。, 39。紹興市越城區(qū)白馬新村567號(hào)39。, 39。78939。, 39。39。,39。939。,null)。insert into 供應(yīng)商信息表 (Snum,Sname,Stel,Sadd,Scoo,Sdiscount,Scredit,Smark)values (39。000339。, 39。光明奶制品有限公司39。, 39。05712578562139。, 39。杭州市九堡323號(hào)39。, 39。25539。, 39。39。,39。1039。,null)。insert into 供應(yīng)商信息表 (Snum,Sname,Stel,Sadd,Scoo,Sdiscount,Scredit,Smark)values (39。000439。, 39。新希望奶制品有限公司39。, 39。05712679010639。, 39。杭州市蕭山區(qū)新城路567號(hào)39。, 39。26539。, 39。39。,39。1039。,null)。insert into 供應(yīng)商信息表 (Snum,Sn