数据库设计课程论文游戏平台系统课程设计

1、游戏平台系统课程设计 专业：电子信息工程组员：10021226 蔺子杰 10021228陈浩 10021230 彭锦程 10024151 保罗 10024152 AZAT指导教师：刘芳完成日期：2012/12/12 我们是处在21世纪的孩子，而21世纪是一个以网络为核心的信息时代，它的主要特征是数字化，网络化和信息化。网络已经成为信息社会的命脉和发展知识经济的重要基础。对我们大学生来说，网络与我们最密切相关的就是网上资讯和网络游戏，尤其是很多大学生都“沉迷”于网络游戏世界，所以我们觉得对于这个游戏平台系统的设计是一个很贴近生活的课题。近年来，我国电子竞技产业得到越来越多的人的欢迎，游戏对战平台

2、发展极其迅速。数据库在游戏平台系统中发挥极大的作用，无论对于其中的商业价值还是方便玩家的游戏生活都是不言而喻的。经过本小组讨论，最终决定设计和游戏对战平台有关的数据库。考虑到自身编程水平的限制，我们把数据的主要功能定位有关游戏玩家身份的层面，并希望在此基础上能有创新性的开发。一：系统功能分析游戏平台系统所要实现的功能是能记录每一个玩家的登录信息，所玩游戏的基本信息以及玩家在玩游戏的情况。玩家的登录信息是对玩家的管理，主要用于验证登录到该系统的用户身份。系统用户信息包括系统用户的用户名、密码、注册邮箱等信息，用户登录管理模块需要完成系统用户信息的添加、修改、删除以及查询操作。而所玩游戏的基本信息

3、是对平台内所含游戏的管理，主要用于管理平台内部的游戏。游戏的火热程度是随时间的变化而不断变化的，在某段时间以内某些游戏十分吸引人玩，过了一段时间可能因为失去新意而失去游戏群体。游戏的信息主要包括游戏性质，名称以及所开发的公司、游戏管理模块需要完成游戏信息的添加和删除操作。玩家玩游戏的情况是对实现对当前玩家所玩游戏的信息的一个汇总，可以方便用户自己了解自己的当前情况。二：系统ER图 三：关系模型玩家（编号 密码 ID 好友 邮箱 ）管理员（编号 密码 ID 联系方式）游戏（编号 名称 开发商）开发商（编号 名称 电话 地址）平台（名称 版本 性质）四：数据源代码玩家信息：create table

4、 a10021225player(p_number char(10) primary key,p_code char(10) not null,p_name char(10) not null,p_email char(20) not null);insert into a10021225player(p_number,p_code,p_name,p_email)values('1','123','liyang','buhuiwan');insert into a10021225player(p_number,p_code,p_n

5、ame,p_email)values('12','12345','wangwei','dashadan');insert into a10021225player(p_number,p_code,p_name,p_email)values('25','43992','sunwu','yuge');insert into a10021225player(p_number,p_code,p_name,p_email)values('28','xia

6、y','wuyu','wuyu');insert into a10021225player(p_number,p_code,p_name,p_email)values('7','tucao','binge','fanren');管理员信息：create table a10021225admin(a_number char(10) primary key,a_code char(10) not null,a_name char(10) not null,a_tel char(20) not n

7、ull);insert into a10021225admin(a_number,a_code,a_name,a_tel)values('1','admin1','lzj','#39;);insert into a10021225admin(a_number,a_code,a_name,a_tel)values('2','admin2','ch','#39;);游戏信息：create table a10021225game(g_numb

8、er char(10) primary key,g_name char(10) not null);insert into a10021225game(g_number,g_name)values('1','war3');insert into a10021225game(g_number,g_name)values('2','CF');insert into a10021225game(g_number,g_name)values('3','dota');开发商信息：create table a1

9、0021225company(c_number char(10) primary key,c_name char(10) not null,c_tel char(20) not null,c_address char(20) not null);insert into a10021225company(c_number,c_name,c_tel,c_address)values('1','chenhao','56746234','pandaomiao');insert into a10021225company(c_number,

10、c_name,c_tel,c_address)values('2','lsb','39485720','jinsong');insert into a10021225company(c_number,c_name,c_tel,c_address)values('3','lwc','59403720','chaoyang');平台信息：create table a10021225platform(pl_name char(10) primary key,pl_editi

11、on char(20) not null);insert into a10021225platform(pl_name,pl_edition)values('11','4.76d');其它的代码：insert into a10021225player(p_number,p_code,p_name,p_email)values('1','123','liyang','buhuiwan'); insert into a10021225player(p_number,p_code,p_name,p_ema

12、il)values('12','12345','wangwei','dashadan');insert into a10021225player(p_number,p_code,p_name,p_email)values('25','43992','sunwu','yuge');insert into a10021225player(p_number,p_code,p_name,p_email)values('28','xiay',&#

13、39;wuyu','wuyu');insert into a10021225player(p_number,p_code,p_name,p_email)values('7','tucao','binge','fanren');insert into a10021225admin(a_number,a_code,a_name,a_tel)values('1','admin1','lzj','#39;);insert into a1

14、0021225admin(a_number,a_code,a_name,a_tel)values('2','admin2','ch','#39;);insert into a10021225game(g_number,g_name)values('1','war3');insert into a10021225game(g_number,g_name)values('2','CF');insert into a10021225game(g_number

15、,g_name)values('3','dota');insert into a10021225company(c_number,c_name,c_tel,c_address)values('1','chenhao','56746234','pandaomiao');insert into a10021225company(c_number,c_name,c_tel,c_address)values('2','lsb','39485720','

16、jinsong');insert into a10021225company(c_number,c_name,c_tel,c_address)values('3','lwc','59403720','chaoyang');insert into a10021225platform(pl_name,pl_edition)values('11','4.76d');insert into a10021225(sno,sname,sgrade)values('12347','

17、tom','2');create table a10021225k(kno char(6) not null,kname char(8) not null,kcredit char(2),primary key (kno);create table a10021225g_c(g_number char(10) not null, c_number char(10) not null, primary key(g_number,c_number), foreign key(g_number) references a10021225game on delete casca

18、de, foreign key(c_number) references a10021225company on delete cascade);insert into a10021225g_c(g_number,c_number)values('1','1');insert into a10021225g_c(g_number,c_number)values('2','2');insert into a10021225g_c(g_number,c_number)values('3','3');cr

19、eate table a10021225g_p(p_number char(10) not null, g_number char(10) not null, score char(10), primary key(g_number,p_number), foreign key(g_number) references a10021225game on delete cascade, foreign key(p_number) references a10021225player on delete cascade);insert into a10021225g_p(p_number,g_nu

20、mber,score)values('1','1','89');insert into a10021225g_p(p_number,g_number,score)values('1','2','67');insert into a10021225g_p(p_number,g_number,score)values('1','3','57');insert into a10021225g_p(p_number,g_number,score)values(

21、'12','1','86');insert into a10021225g_p(p_number,g_number,score)values('12','2','34');insert into a10021225g_p(p_number,g_number,score)values('12','3','31');insert into a10021225g_p(p_number,g_number,score)values('25',&#

22、39;1','47');insert into a10021225g_p(p_number,g_number,score)values('25','2','45');insert into a10021225g_p(p_number,g_number,score)values('25','3','37');insert into a10021225g_p(p_number,g_number,score)values('28','1','

23、25');insert into a10021225g_p(p_number,g_number,score)values('28','2','42');insert into a10021225g_p(p_number,g_number,score)values('28','3','37');insert into a10021225g_p(p_number,g_number,score)values('7','1','100');insert into a10021225g_p(p_number,g_number,score)values('7','2','98');insert into a10021225g_p(p_number,g_number,score)values('