NBA球员球队信息管理系统项目设计方案

--向球队表加入数据

insert into Team values('凯尔特人','波士顿', '14', '17', 'EN', '7') insert into Team values('热火','迈阿密','15','2','ES','2') insert into Team values('湖人','洛杉矶','15','16','WS','11') insert into Team values('雷霆','俄荷拉何马','14','1','WN','2')

--向球员表加入数据

insert into player values ('Kobe Byrant','34','198','93','美国','得分后卫','湖人','2000','1996-08-12')

Insert into player values('Dwight Howard','27','211','120','美国','中锋','湖人','1700','2012-08-09')

insert into player values('Steve Nash','38','191','80','加拿大','控球后卫','湖人','1200','2012-08-22')

insert into player values('Dwyane Wade','30','193','99','美国','得分后卫','热火','1700','2003-09-11')

insert into player values('Chris Bosh','28','211','106','美国','中锋','热火','1665','2010-07-25')

insert into player values('Leborn James','28','203','113','美国','得分后卫','热火','1770','2010-07-31')

insert into player values('Kevin Garnett','36','211','115','美国','大前锋','凯尔特人','1455','2007-08-01')

insert into player values('Leandro Babosa','30','191','88','巴西','小前锋','凯尔特人','774','2008-08-06')

insert into player values('Paul Pierce','35','201','106','美国','得分后卫','凯尔特人','1520','2010-07-09')

insert into player values('Russel Westbrook','24','191','85','美国','控球后卫','雷霆','1600','2008-03-06')

insert into player values('Kevin Durant','24','206','106','美国','得分后卫','雷霆','1863','2007-03-15')

insert into player values('Serge Ibaka','23','208','106','西班牙','中锋','雷霆','236','2008-04-05')

--向比赛表加入数据

insert into race values ('常规赛','2011-10-03 ','2012-04-22') insert into race values ('季前赛','2011-08-31','2011-09-30') insert into race values ('季后赛','2012-04-22','2012-07-25')

--向球队参赛表加入数据

insert into QC values ('凯尔特人','季前赛','2','0.8') insert into QC values ('凯尔特人','常规赛','4','0.32') insert into QC values ('凯尔特人','季后赛','3','0.47') insert into QC values ('热火','季前赛','1','0.88') insert into QC values ('热火','常规赛','2','0.76')

13

insert into QC values('热火','季后赛','4','0.36') insert into QC values('湖人','季前赛','3','0.54') insert into QC values('湖人','常规赛','1','0.90') insert into QC values('湖人','季后赛','1','1') insert into QC values('雷霆','季前赛','4','0.25') insert into QC values('雷霆','常规赛','3','0.66') insert into QC values('雷霆','季后赛','2','0.88')

--向球员参赛表加入数据

insert into PC values('Kobe Byrant', '常规赛','28','MVP')

insert into PC values ('Dwight Howard', '季前赛','22','篮板王') insert into PC values ('Steve Nash', '季后赛','17','助攻王') insert into PC values ('Dwyane Wade', '常规赛','26',null) insert into PC values ('Chris Bosh', '季后赛','15',null)

insert into PC values ('LeBorn James', '常规赛','31','盖帽王') insert into PC values ('Kevin Garnett', '季前赛','12',null) insert into PC values ('Leandro Babosa', '季前赛','6',null) insert into PC values ('Paul Pierce', '季后赛','20','抢断王')

insert into PC values ('Russel Westbrook','季前赛','24','最佳新秀') insert into PC values ('Kevin Durant','常规赛','32','得分王') insert into PC values ('Serge Ibaka','季后赛','22',null)

--创建索引--球队名

create unique index IX_球队名on team(球队名)

--创建索引--身高

create index IX_身高on player(身高)

--创建索引--球员姓名

create index IX_球员姓名on player(球员姓名)

该数据的查询功能—查询语句 多条件组合查询

-查询球员表中国籍是美国的所有球员 select * from player where 国籍='美国' 截图结果

14

--查询球员表中加盟时间在-08-01到-08-01的球员

select * from player where 加盟时间between '1996-08-01 00:00:00.000'and'2008-08-01 00:00:00.000' 截图结果

--查询球员表中球员年龄不超过的人数 select Count (*) AS '年龄不超过的人数' from player

15

截图结果

--查询球员表中球员的平均年龄 select Sum(年龄)/12 AS '平均年龄' from player 截图结果

16