音響店零售出租管理數(shù)據(jù)庫

1、大型數(shù)據(jù)庫課程設(shè)計(jì)設(shè)計(jì)報(bào)告題 目：音響店DVD出租/零售管理系統(tǒng)學(xué) 號： 1 2 1 0 0 6 3 1 4 學(xué)生姓名： 劉 可 指導(dǎo)教師： 劉 寧 提交時間： 目錄第1章需求分析11.1需求調(diào)查11.2 系統(tǒng)功能分析1第2章概念結(jié)構(gòu)設(shè)計(jì)22.1 局部E-R圖22.2 全局E-R圖3第3章邏輯結(jié)構(gòu)設(shè)計(jì)43.1 E-R圖向關(guān)系模式轉(zhuǎn)換43.2建立關(guān)系模式43.3關(guān)系模式規(guī)范化處理43.4用戶子模式建立43.5關(guān)系模式邏輯結(jié)構(gòu)定義5第4章數(shù)據(jù)庫物理結(jié)構(gòu)設(shè)計(jì)74.1 數(shù)據(jù)庫物理設(shè)計(jì)7第5章數(shù)據(jù)庫實(shí)施85.1 數(shù)據(jù)庫及數(shù)據(jù)庫對象建立8第6章 數(shù)據(jù)庫完整性設(shè)計(jì)96.1 主鍵96.2 參照完整性設(shè)計(jì)96.

2、3 觸發(fā)器設(shè)計(jì)96.4 視圖設(shè)計(jì)12第7章 數(shù)據(jù)庫存儲過程設(shè)計(jì)13總結(jié)14參考文獻(xiàn)：14 可修改 歡迎下載 精品 Word第1章需求分析1.1需求調(diào)查通過對各個用戶的調(diào)查，該音響店DVD零售出租管理系統(tǒng)如下需求：1) 系統(tǒng)管理：實(shí)現(xiàn)系統(tǒng)管理人員對系統(tǒng)的管理，包括添加刪除用戶，更改密碼等功能。2) 數(shù)據(jù)管理：實(shí)現(xiàn)管理人員對系統(tǒng)的管理，包括DVD入庫，出租，出售，歸還等功能。3) 基本信息：實(shí)現(xiàn)顯示客戶和DVD基本信息（包括客戶信息和客戶所租賃DVD信息，DVD基本信息）。4) 查詢：查詢當(dāng)前DVD狀況；查詢當(dāng)前用戶租賃狀況及歷史租賃狀況。1.2 系統(tǒng)功能分析音響店DVD零售/出租管理系統(tǒng)DVD借

3、還管理DVD零售管理用戶信息管理DVD信息管理DVD入庫管理1) DVD信息管理：存放及查看各DVD的基本信息和數(shù)量。2) 用戶信息管理：用于對用戶基本信息的錄入、查詢、修改、維護(hù)、刪除等常用功能，并記錄用戶的租賃情況。3) DVD入庫管理：用于對DVD的入庫情況進(jìn)行記錄，并修改DVD總量。4) DVD零售管理：用于記錄DVD的零售情況，并修改DVD總量。5) DVD借還管理：用于統(tǒng)計(jì)各DVD的借還情況。第2章概念結(jié)構(gòu)設(shè)計(jì)2.1局部E-R圖：（1）對DVD建立E-R圖 （2）對用戶建立E-R圖用戶用戶編號姓名歷史租賃性別當(dāng)前租賃DVDDVD編號主演庫存現(xiàn)貨名稱（3）對DVD租賃建立E-R圖DV

4、D租賃DVD編號租賃用戶編號租賃日期租賃期限D(zhuǎn)VD名稱租賃編號（4）對DVD歸還建立E-R圖DVD歸還DVD編號歸還用戶編號歸還日期逾期天數(shù)DVD名稱歸還編號（5）對DVD零售建立E-R圖DVD零售DVD編號出售日期出售數(shù)量DVD編號DVD名稱（6）對DVD入庫建立E-R圖DVD入庫DVD編號入庫日期入庫數(shù)量DVD編號DVD名稱2.2全局E-R圖：DVD名稱DVD編號歸還日期DVD名稱入庫日期DVD編號DVD入庫歸還用戶編號入庫數(shù)量DVD歸還歸還編號提供現(xiàn)貨姓名逾期天數(shù)DVD名稱主演性別用戶編號DVD編號DVD提供用戶DVD零售辦理庫存出售日期出售數(shù)量DVD編號當(dāng)前租賃歷史租賃DVD名稱DVD

5、編號租賃日期DVD租賃DVD名稱租賃期限租賃編號租賃用戶編號第3章邏輯結(jié)構(gòu)設(shè)計(jì)3.1E-R圖向關(guān)系模式轉(zhuǎn)變邏輯結(jié)構(gòu)是獨(dú)立于任何一種數(shù)據(jù)模型的，在實(shí)際應(yīng)用中，一般所用的數(shù)據(jù)庫環(huán)境已經(jīng)給定（如SQL Server或Oracel或MySql)。由于目前使用的數(shù)據(jù)庫基本上都是關(guān)系數(shù)據(jù)庫，因此首先需要將E-R圖轉(zhuǎn)換為關(guān)系模型，然后根據(jù)具體DBMS的特點(diǎn)和限制轉(zhuǎn)換為特定的DBMS支持下的數(shù)據(jù)模型，最后進(jìn)行優(yōu)化系模式轉(zhuǎn)換3.2建立關(guān)系模式DVD信息（DVD編號，DVD名稱，主演，現(xiàn)貨，庫存）用戶信息（用戶編號，姓名，性別，當(dāng)前租賃，歷史租賃）DVD租賃（DVD編號，DVD名稱，租賃日期，租賃期限，租賃用戶編

6、號，租賃編號）DVD歸還（DVD編號，DVD名稱，歸還日期，逾期天數(shù)，歸還用戶編號，歸還編號）DVD零售（DVD編號，DVD名稱，出售日期，出售數(shù)量）DVD入庫（DVD編號，DVD名稱，入庫日期，入庫數(shù)量）3.3 關(guān)系模式規(guī)范化處理根據(jù)F，分析每一個關(guān)系模式是否滿足3NF，對不滿足3NF的關(guān)系模式要進(jìn)行規(guī)范化處理。3.4 用戶子模式建立 根據(jù)需求分析，研究建立滿足不同需求的用戶子模式，子模式表示形式為：子模式名（屬性列表）3.5 關(guān)系模式邏輯結(jié)構(gòu)定義1.DVD詳細(xì)信息字段名數(shù)據(jù)類型長度約束DVD編號char4主鍵DVD名稱char10不為空主演char10不為空現(xiàn)貨int不為空庫存int不為空

7、2.用戶詳細(xì)信息字段名數(shù)據(jù)類型長度約束用戶編號char4主鍵姓名char10不為空性別nchar1男或女當(dāng)前租賃int可為空歷史租賃int可為空3.DVD租賃信息字段名數(shù)據(jù)類型長度約束DVD編號char4外鍵DVD名稱char10不為空租賃日期datetime不為空租賃期限int不為空租賃用戶編號char4外鍵租賃編號char20主鍵4.DVD歸還信息字段名數(shù)據(jù)類型長度約束DVD編號char4外鍵DVD名稱char10不為空歸還日期datetime不為空逾期天數(shù)int不為空歸還用戶編號char4外鍵歸還編號char20主鍵，外鍵5.DVD零售信息字段名數(shù)據(jù)類型長度約束DVD編號char4主鍵，

8、外鍵DVD名稱char10不為空出售日期datetime主鍵出售數(shù)量int不為空6.DVD入庫信息字段名數(shù)據(jù)類型長度約束DVD編號char4主鍵，外鍵DVD名稱char10不為空入庫日期datetime主鍵入庫數(shù)量int不為空第4章數(shù)據(jù)庫物理結(jié)構(gòu)設(shè)計(jì)4.1數(shù)據(jù)庫物理設(shè)計(jì)數(shù)據(jù)庫物理設(shè)計(jì)：設(shè)計(jì)數(shù)據(jù)庫的物理結(jié)構(gòu)，根據(jù)數(shù)據(jù)庫的邏輯結(jié)構(gòu)來選定RDBMS（如Oracle、Sybase等），并設(shè)計(jì)和實(shí)施數(shù)據(jù)庫的存儲結(jié)構(gòu)、存取方式等。數(shù)據(jù)庫物理設(shè)計(jì)是后半段。將一個給定邏輯結(jié)構(gòu)實(shí)施到具體的環(huán)境中時，邏輯數(shù)據(jù)模型要選取一個具體的工作環(huán)境，這個工作環(huán)境提供了數(shù)據(jù)存儲結(jié)構(gòu)與存取方法，這個過程就是數(shù)據(jù)庫的物理設(shè)計(jì)。物理

9、結(jié)構(gòu)依賴于給定的DBMS和和硬件系統(tǒng)，因此設(shè)計(jì)人員必須充分了解所用RDBMS的內(nèi)部特征、存儲結(jié)構(gòu)、存取方法。數(shù)據(jù)庫的物理設(shè)計(jì)通常分為兩步，第一，確定數(shù)據(jù)庫的物理結(jié)構(gòu)，第二，評價實(shí)施空間效率和時間效率確定數(shù)據(jù)庫的物理結(jié)構(gòu)包含下面四方面的內(nèi)容：1、確定數(shù)據(jù)的存儲結(jié)構(gòu)2、設(shè)計(jì)數(shù)據(jù)的存取路徑3、確定數(shù)據(jù)的存放位置4、確定系統(tǒng)配置數(shù)據(jù)庫物理設(shè)計(jì)過程中需要對時間效率、空間效率、維護(hù)代價和各種用戶要求進(jìn)行權(quán)衡，選擇一個優(yōu)化方案作為數(shù)據(jù)庫物理結(jié)構(gòu)。在數(shù)據(jù)庫物理設(shè)計(jì)中，最有效的方式是集中地存儲和檢索對象。第5章 數(shù)據(jù)庫實(shí)施5.1數(shù)據(jù)庫及數(shù)據(jù)庫對象建立（1）創(chuàng)建數(shù)據(jù)庫：create database 音響店DVD

10、零售出租管理系統(tǒng)數(shù)據(jù)庫on( name ='音響店DVD零售出租管理系統(tǒng)數(shù)據(jù)文件', ='E:SJKKCSJ音響店DVD零售出租管理系統(tǒng)數(shù)據(jù)文件.mdf', size =15MB, maxsize = 50MB, =5%)log on( name ='音響店DVD零售出租管理系統(tǒng)日志文件', = 'E:SJKKCSJ音響店DVD零售出租管理系統(tǒng)日志文件.ldf', size = 2MB, maxsize = 5MB, = 1MB)（2）創(chuàng)建表：create table DVD信息表( DVD編號 char(4) not null

11、primary key, DVD名稱 char(10) not null, 主演 char(10) not null, 現(xiàn)貨 int not null, 庫存 int not null)create table 用戶信息表( 用戶編號 char(4) not null primary key, 姓名 char(10) not null, 性別 nchar(1) not null, 當(dāng)前租賃 int null, 歷史租賃 int null)create table DVD租賃表( DVD編號 char(4) not null, DVD名稱 char(10) not null, 租賃日期 date

12、time not null, 租賃期限 int not null, 租賃用戶編號 char(4) not null, 租賃編號 char(20) not null primary key, foreign key(DVD編號) references DVD信息表(DVD編號), foreign key(租賃用戶編號) references 用戶信息表(用戶編號)create table DVD歸還表( DVD編號 char(4) not null, DVD名稱 char(10) not null, 歸還日期 datetime not null, 逾期天數(shù) int null, 歸還用戶編號 ch

13、ar(4) not null, 歸還編號 char(20) not null primary key, foreign key(DVD編號) references DVD信息表(DVD編號), foreign key(歸還編號) references DVD租賃表(租賃編號), foreign key(歸還用戶編號) references 用戶信息表(用戶編號) create table DVD零售表( DVD編號 char(4) not null, DVD名稱 char(10) not null, 出售日期 date not null, 出售數(shù)量 int not null, primary

14、key(DVD編號,出售日期), foreign key(DVD編號) references DVD信息表(DVD編號) )create table DVD入庫表( DVD編號 char(4) not null, DVD名稱 char(10) not null, 入庫日期 date not null, 入庫數(shù)量 int not null, primary key(DVD編號,入庫日期), foreign key(DVD編號) references DVD信息表(DVD編號)第6章 數(shù)據(jù)庫完整性設(shè)計(jì)6.1主鍵表名主鍵DVD信息表(DVD編號)用戶信息表(用戶編號)DVD租賃表(租賃編號)DVD歸

15、還表(歸還編號)DVD零售表(DVD編號，出售日期)DVD入庫表(DVD編號，入庫日期)6.2參照完整性設(shè)計(jì)表名外鍵參照DVD租賃表(DVD編號，租賃用戶編號)DVD信息表.DVD編號用戶信息表.用戶編號DVD歸還表(DVD編號，歸還用戶編號)DVD信息表.DVD編號用戶信息表.用戶編號DVD零售表(DVD編號)DVD信息表.DVD編號DVD入庫表(DVD編號)DVD信息表.DVD編號6.3觸發(fā)器設(shè)計(jì)1.實(shí)現(xiàn)出租時自動修改DVD現(xiàn)貨及客戶的當(dāng)前租賃數(shù)量create trigger _rent on DVD租賃表-租賃觸發(fā)器for insertasbeginupdate DVD信息表 set 現(xiàn)

16、貨=現(xiàn)貨-1from DVD信息表,insertedwhere DVD信息表.DVD編號=inserted.DVD編號update 用戶信息表 set 當(dāng)前租賃=當(dāng)前租賃+1from 用戶信息表,insertedwhere 用戶信息表.用戶編號=inserted.租賃用戶編號end2.實(shí)現(xiàn)歸還時自動修改DVD現(xiàn)貨及客戶的當(dāng)前租賃數(shù)量和歷史租賃數(shù)量create trigger _return on DVD歸還表-歸還觸發(fā)器for insertasbeginupdate DVD信息表 set 現(xiàn)貨=現(xiàn)貨+1from DVD信息表,insertedwhere DVD信息表.DVD編號=inserte

17、d.DVD編號update 用戶信息表 set 當(dāng)前租賃=當(dāng)前租賃-1from 用戶信息表,insertedwhere 用戶信息表.用戶編號=inserted.歸還用戶編號update 用戶信息表 set 歷史租賃=歷史租賃+1from 用戶信息表,insertedwhere 用戶信息表.用戶編號=inserted.歸還用戶編號update DVD歸還表 set DVD編號=DVD租賃表.DVD編號,DVD名稱=DVD租賃表.DVD名稱,歸還用戶編號=DVD租賃表.租賃用戶編號from DVD租賃表,DVD歸還表,insertedwhere DVD租賃表.租賃編號=inserted.歸還編號e

18、nd3.實(shí)現(xiàn)入庫時自動修改DVD庫存create trigger _buy on DVD入庫表-入庫觸發(fā)器for insertasupdate DVD信息表 set 庫存=庫存+inserted.入庫數(shù)量from DVD信息表,insertedwhere DVD信息表.DVD編號=inserted.DVD編號4.實(shí)現(xiàn)零售時自動修改DVD庫存create trigger _sale on DVD零售表-零售觸發(fā)器for insertasupdate DVD信息表 set 庫存=庫存-inserted.出售數(shù)量from DVD信息表,insertedwhere DVD信息表.DVD編號=inser

19、ted.DVD編號5.實(shí)現(xiàn)歸還時自動計(jì)算并存入逾期天數(shù)create trigger _days on DVD歸還表-逾期天數(shù)觸發(fā)器for insertasdeclare days intset days=(select cast(inserted.歸還日期 as int)-cast(DVD租賃表.租賃日期 as int)from DVD租賃表,insertedwhere DVD租賃表.租賃編號=inserted.歸還編號)if days>(select DVD租賃表.租賃期限 from DVD租賃表,inserted where DVD租賃表.租賃編號= inserted.歸還編號)be

20、ginupdate DVD歸還表 set 逾期天數(shù)= days-(select DVD租賃表.租賃期限 from DVD租賃表 where DVD租賃表.租賃編號=inserted.歸還編號)from DVD租賃表,DVD歸還表,insertedwhere DVD租賃表.租賃編號=inserted.歸還編號endelsebeginupdate DVD歸還表 set 逾期天數(shù)=0from DVD租賃表,DVD歸還表,insertedwhere DVD租賃表.租賃編號=inserted.歸還編號end6.4視圖設(shè)計(jì)創(chuàng)建視圖查詢各類DVD的庫存情況create view numberasselect

21、 DVD編號,DVD名稱,現(xiàn)貨,庫存from DVD信息表第7章 數(shù)據(jù)庫存儲過程設(shè)計(jì)創(chuàng)建存儲過程統(tǒng)計(jì)某段時間內(nèi)各DVD的銷售、借還數(shù)量create procedure tongji begintime date,endtime date,type char(6) asdeclare leixing char(6)set leixing=typebeginif leixing='零售'select begintime as 起始日期,endtime as 截至日期,DVD編號,SUM(出售數(shù)量) as 銷售量from DVD零售表where 出售日期>=begintime

22、and 出售日期<=endtimegroup by DVD編號else if leixing='出租'select begintime as 起始日期,endtime as 截至日期, DVD編號,count(DVD編號) as 出租量from DVD租賃表where 租賃日期>=begintime and 租賃日期<=endtimegroup by DVD編號else if leixing='歸還'select begintime as 起始日期,endtime as 截至日期,DVD編號,count(DVD編號) as 歸還量from DV

23、D歸還表where 歸還日期>=begintime and 歸還日期<=endtimegroup by DVD編號else print '請輸入正確的查詢類型'end總結(jié)在做本次課程設(shè)計(jì)的過程中，遇到了許多困難，正是這些困難，讓我把這門課學(xué)得更好，有了更深一步的理解，明白了理論和實(shí)踐要想充分地結(jié)合，需要非常扎實(shí)的基本功。這就說明學(xué)好基礎(chǔ)知識是理論付諸實(shí)踐的前提。參考文獻(xiàn)：1. 王珊,薩師煊 .數(shù)據(jù)庫系統(tǒng)概論M. 高等教育出版社,20052. 鄭阿奇等. SQLserver實(shí)用教程（第3版）M . 電子工業(yè)出版社,20093. 趙乃真等. 信息系統(tǒng)設(shè)計(jì)與應(yīng)用. 清華大

24、學(xué)出版社,2005 附錄：隨機(jī)插入用戶信息表數(shù)據(jù)存儲過程代碼：create procedure dbo.usermassage_proc1/* 為用戶表輸入數(shù)據(jù)*/asdeclare num int,rmd floatdeclare gender nchar(1)declare userid intdeclare xing int,rxing int, na nvarchar(8)-姓declare ming int,rming int,me nvarchar(10)-名declare name nvarchar(20)-姓名set num=0while num<1000beginset

25、 num=num+1set rmd=rand()-產(chǎn)生的隨機(jī)數(shù)rmdif(rmd>0.5)-隨機(jī)確定性別set gender='男'else set gender='女'set rxing=floor(rmd*100)set xing= rxing%35set rming=floor(rmd*10000)-rxing*100if xing=1 begin set na='王' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and

26、rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪軍' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凱' if (ming=8 and rmd>0.5) set me=

27、'小寶' if (ming=9 and rmd>0.5) set me='海軍' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志強(qiáng)' if (ming=14and rmd>0.5) set me='云凱' if

28、(ming=15and rmd>0.5) set me='云龍' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克強(qiáng)' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='樂樂' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd

29、<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='曉旭' if (ming=7 and rmd<=0.5) set me='曉旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set

30、me='雪嬌' if (ming=11 and rmd<=0.5) set me='曉彤' if (ming=12 and rmd<=0.5) set me='春琪' if (ming=13 and rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='

31、;小璐' if (ming=0 and rmd<=0.5) set me='蓉蓉' end else if xing=2 begin set na='李' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪軍' if (ming=4 and rmd>0.5) set me=

32、9;天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凱' if (ming=8 and rmd>0.5) set me='小寶' if (ming=9 and rmd>0.5) set me='海軍' if (ming=10 and rmd>0.5) set me='勇' if (ming=

33、11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志強(qiáng)' if (ming=14and rmd>0.5) set me='云凱' if (ming=15and rmd>0.5) set me='云龍' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5

34、) set me='克強(qiáng)' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='樂樂' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='

35、;曉旭' if (ming=7 and rmd<=0.5) set me='曉旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set me='雪嬌' if (ming=11 and rmd<=0.5) set me='曉彤' if (ming=12 and rmd<=0.5) set me='春琪' if

36、 (ming=13 and rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='小璐' if (ming=0 and rmd<=0.5) set me='蓉蓉' end else if xing=3 begin set na='張' set ming= (rmin

37、g%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪軍' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 an

38、d rmd>0.5) set me='力凱' if (ming=8 and rmd>0.5) set me='小寶' if (ming=9 and rmd>0.5) set me='海軍' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) se

39、t me='志強(qiáng)' if (ming=14and rmd>0.5) set me='云凱' if (ming=15and rmd>0.5) set me='云龍' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克強(qiáng)' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='樂樂'

40、; if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='曉旭' if (ming=7 and rmd<=0.5) set me='曉旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 a

41、nd rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set me='雪嬌' if (ming=11 and rmd<=0.5) set me='曉彤' if (ming=12 and rmd<=0.5) set me='春琪' if (ming=13 and rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd&l

42、t;=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='小璐' if (ming=0 and rmd<=0.5) set me='蓉蓉' end else if xing=4 begin set na='劉' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and r

43、md>0.5) set me='洪軍' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凱' if (ming=8 and rmd>0.5) set me='小寶' if (ming=9 and rmd>0.5) set me=&

44、#39;海軍' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志強(qiáng)' if (ming=14and rmd>0.5) set me='云凱' if (ming=15and rmd>0.5) set me='云龍' if (

45、ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克強(qiáng)' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='樂樂' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd&

46、lt;=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='曉旭' if (ming=7 and rmd<=0.5) set me='曉旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set me='雪嬌' if (ming=11 and rmd<=0.5) set

47、 me='曉彤' if (ming=12 and rmd<=0.5) set me='春琪' if (ming=13 and rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='小璐' if (ming=0 and rmd<=0.5) set me='

48、;蓉蓉' end else if xing=5 begin set na='蘇' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪軍' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='

49、;杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凱' if (ming=8 and rmd>0.5) set me='小寶' if (ming=9 and rmd>0.5) set me='海軍' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=1

50、2 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志強(qiáng)' if (ming=14and rmd>0.5) set me='云凱' if (ming=15and rmd>0.5) set me='云龍' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克強(qiáng)' if (ming=1 and rmd<=0.5

51、) set me='洪霞' if (ming=2 and rmd<=0.5) set me='樂樂' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='曉旭' if (ming=7 and rmd<=0.5) set me='

52、;曉旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set me='雪嬌' if (ming=11 and rmd<=0.5) set me='曉彤' if (ming=12 and rmd<=0.5) set me='春琪' if (ming=13 and rmd<=0.5) set me='明月' i

53、f (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='小璐' if (ming=0 and rmd<=0.5) set me='蓉蓉' end else if xing=6 begin set na='陳' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏&

54、#39; if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪軍' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凱' if (ming=8 and

55、 rmd>0.5) set me='小寶' if (ming=9 and rmd>0.5) set me='海軍' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志強(qiáng)' if (ming=14and rmd>0.5) set

56、 me='云凱' if (ming=15and rmd>0.5) set me='云龍' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克強(qiáng)' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='樂樂' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5