网络游戏信息管理系统

insert into player values(4,';
insert into player values(5,'徐涛','男',2,29,5);
insert into player values(6,'石头','男',3,27,53);
insert into player values(7,'陈子文','男',3,25,5);
5.
CREATE TABLE rank
(
gid int,
peoplesum int,
moneysum int
);
6.
insert into rank values(1,25216020,35000);
insert into rank values(2,26514260,250000);
insert into rank values(3,215656560,205000);
insert into player values(20,'王十','女',1,66,37);
insert into player values(21,'赵一','男',4,66,54);
insert into player values(22,'赵二','女',3,66,35);
insert into player values(23,'赵三','男',1,69,38);
insert into salerecord values(4,4,1,350000,'2012-7-21');
insert into salerecord values(5,5,4,7000,'2014-9-3');
insert into salerecord values(6,11,4,35050,'2010-3-1');
2)查询模拟戏人生的运营公司
select operating_company from YH.dbo.game
where game.gname ='模拟人生';
3)查看游戏排行按游戏人数排列
select distinct game.gname,rank.peoplesum,rank.moneysum from YH.dbo.game,YH.dbo.rank
insert into salerecord values(7,6,5,50010,'2014-4-17');
insert into salerecord values(8,9,2,935000,'2009-8-5');
insert into salerecord values(9,6,3,835000,'2015-3-14');
2.
1.
图1玩家信息E-R图
2.
图2游戏信息E-R图
3.
图3排行信息E-R图
4.
图4职务信息E-R图
5.
图5考勤信息E-R图
6.
图6整体简洁E-R图
7.
图7用户信息E-R图
3.
1.
1)玩家信息对应的关系模型
玩家（玩家编号（主键），姓名，性别，游戏编号（外键），等级，充值总金额
2)游戏信息对应的关系模型
type varchar(5) NOT NULL,
operating_company varchar(10),
birth_date date
);
4.
insert into game values(1,'吞噬天地','网游','网易', '2014-9-1');
insert into game values(2,'英雄联盟','竞技','腾讯', '2010-5-20');
insert into gameb values(5,25,25000);
insert into gameb values(6,25,2500);
insert into gameb values(7,25,2500);
11.
create table users
(username char(10) not null,
gid int,
levels int,
money int
);
2.
insert into player values(1,'张三','男',1,58,51);
insert into player values(2,'李四','男',1,59,58);
insert into player values(3,'王五','男',2,27,65);
insert into player values(24,'赵四','男',5,66,39);
insert into player values(25,'赵五','女',4,60,5);
3.
CREATE TABLE game
(
gid int primary key,
gname varchar(10),
references game(gid);
alter table player
add constraint check_sex check (sex in('男','女'));
5.
1.
1)查询王五的等级
select levels from player
where player.pname='王五';
insert into game values(3,'DOTA2','竞技','暴雪', '2006-1-30');
insert into game values(4,'炫舞','休闲','腾讯', '2012-6-1');
insert into game values(5,'模拟人生','模拟','腾讯', '2010-2-25');
password char(30) not null,
juris char(30)
);
12.
insert into users(username,password,juris)values('YH','123','所有权限');
insert into users(username,password,juris)values('YH00','123','查询');
insert into player values(16,'王六','女',1,89,3);
insert into player values(17,'王七','女',4,54,35);
insert into player values(18,'王八','男',2,66,31);
insert into player values(19,'王九','女',4,86,35);
saledate date
);
8.
insert into salerecord values(1,1,2,35000,'2014-9-1');
insert into salerecord values(2,2,3,250000,'2013-8-12');
insert into salerecord values(3,3,4,205000,'2014-9-12');
insert into rank values(4,2515540,350000);
insert into rank values(5,1655620,3000);
7.
CREATE TABLE salerecord
(
saleid int primary key,
pid int,
gid int,
RMB int,
insert into player values(8,'王灿','女',4,66,35);
insert into player values(9,'徐香气','女',4,66,25);
insert into player values(10,'郭俊明','男',5,6,45);
insert into player values(11,'王一','男',4,66,35);
游戏（游戏编号（主键），游戏名称，运营公司，上线时间）
3)排行信息对应的关系模型
排行（游戏编号（外键），游戏人数，充值总金额）
4)交易信息对应的关系模型
交易（交易编号（主键），玩家编号，游戏编号，RMB金额，交易时间）
5)考勤信息对应的关系模型
考勤（员工编号(主键一部分)，日期（主键一部分），请假次数，迟到次数，缺勤次数）