1、(2) 系统为球迷建立档案,可按球迷ID或者名称查询,档案主要包括球员ID,名字,居住地,年龄等。(3) 在系统中,管理员需要对球员数据随时录入,更新,维护,方便球迷得到球员最新动态的数据。(一般一轮比赛完就更新)(4)系统的客户端在Windows平台下运行,服务器可在Windows平台或UNIX平台下运行。系统需要有较好的安全性和可扩展性,并提供简洁方便的图形用户界面。球迷流程管理员流程2.3NBA球员管理系统具备的主要功能:本系统的主要功能如下:(1)球迷信息管理:对球迷的基本信息(如ID,姓名,年龄,居住地等)进行录入和修改。(2)球员数据信息管理:对球员的数据信息(如球员场均得分,场均
2、篮板,场均助攻,场均抢断,场均失误等)录入和更新。(3)管理员信息管理:管理个人用户信息的录入和修改。(管理员只属于重庆,北京,上海等城市)(4)每支球队信息管理:对球队的数据信息(如球队ID,球队名,战绩等)录入和更新。(5)球员年龄信息管理:对球员年龄的数据信息(如球员ID,球员名,player20to30等)录入和修改。(6)球员号码信息管理:对球员号码信息管理(如player11to20,player20to40等)录入和修改。(7)球员信息管理:对球员信息(如年龄,资金,所在球队,球员号码等)进行录入和修改。功能模块如下:2.4流程图:2.5 NBA球员管理系统的实体分析:(1)实体
3、图: (2)ER 图2.5系统运行环境: 本系统是运行在WindowsXP、Windows win7等操作系统环境;处理器型号及内存容量:内存=256M;输入及输出设备的型号和数量,联机或脱机:待定。3数据库分析:3.1 数据库的创建:NBA球员数据管理系统数据库的创建:CREATE DATABASE PlayerON PRIMARY( NAME=Player_Data, FILENAME=G:C数据库作业Player_Data.MDF, SIZE=10, MAXSIZE=UNLIMITED, FILEGROWTH=5)LOG ON NAME=Player_Log,C数据库作业Player_D
4、ata.LDF FILEGROWTH=10%GO3.2数据库表的创建:(1)球员数据表:CREATE TABLE playerdata playerID char(10) NOT NULL, playername char(25) NOT NULL, ppg float NOT NULL, rpg float NOT NULL, apg float NOT NULL, spg float NOT NULL, bpg float NOT NULL, mpg float NOT NULL, FT float NOT NULL, Fromthree float NOT NULL, jumpersho
5、t float NOT NULL, PRIMARY KEY (playerID,playername)(2)球员表: CREATE TABLE player playercapital money NOT NULL, playerage smallint NOT NULL, teamname char(30) NOT NULL, playerNO smallint NOT NULL, teamID char(15) NOT NULL,(3)球员号码表:CREATE TABLE playernum player1to20 char(25) NOT NULL, player20to40 char(
6、25) NOT NULL, player40up char(25) NOT NULL, playername char(25) NOT NULL, CONSTRAINT pkplayernum PRIMARY KEY (playerID,playername), FOREIGN KEY (playername) REFERENCES scancategory(playername)(4)球员年龄表:CREATE TABLE playerage playerID char(10) NOT NULL, playeradd smallint NOT NULL, player20to23 char(2
7、5) NOT NULL, player23to27 char(25) NOT NULL, player27to32 char(25) NOT NULL, player32up char(25) NOT NULL, CONSTRAINT pkplayerage PRIMARY KEY (playerID,playername),)(5)每支球队表:CREATE TABLE everyteam teamcapital money NOT NULL, combatgains float NOT NULL, playername char(25) REFERENCES scancategory(pla
8、yername), CONSTRAINT pkeveryteam PRIMARY KEY (teamID)(6)管理员表:CREATE TABLE Administrator ADMID char(10) NOT NULL, name char(25) NOT NULL, age smallint NOT NULL, sex char(2) NOT NULL, city char(15) NOT NULL CONSTRAINT chkcity CHECK(city IN (chongqing,sichuanbeijingshanghaixianggangaomentaiwandalian),
9、PRIMARY KEY (ADMID,name)(7)登录用户表:CREATE TABLE Registrant funID char(10) NOT NULL, lname char(25) NOT NULL, lkey char(16) NOT NULL, age smallint NOT NULL, sex char(2) NOT NULL, lcity char(15) NOT NULL CONSTRAINT chklcity CHECK (lcity IN ( PRIMARY KEY (funID,lname)(8)浏览目录表:CREATE TABLE scancategory pl
10、ayerNO smallint NOT NULL, PRIMARY KEY (playername)CREATE UNIQUE NONCLUSTERED INDEX idx_categoryON scancategory (playername)3.3表的约束:(1)检查约束:管理员用户表:(2)外键约束:球员年龄信息表: playerID char(25) NOT NULL,(3)主键约束:每支球队信息表:3.4 索引:3.5数据插入:(1)目录数据插入:INSERT scancategory(playername ,teamname ,playerNO,playerage)VALUES (
11、Tracy McGradyDetroit Pistons,1,32),(Tayshaun Prince,22,31),(Richard Hamilton,32,33),(Greg Monroe,10,21),(Rodney Stuckey,3,25),(Charlie Villanueva,31,27),(Ben Gordon,7,28),(Jason Maxiell,54,28),(Ben Wallace,6,37),(Austin Daye,5,23), (Kevin MartinHouston Rockets,12,28),(Luis Scola,4,31),(Kyle Lowry,7,
12、25),(Chase Budinger,10,23),(Courtney Lee,5,26),(Chuck Hayes,44,28),(Goran DragicPatrick Patterson,54,24),(Terrence Williams,1,24),(Hasheem Thabeet,32,24),Kevin DurantOklahoma City Thunder,35,23),(Russell Westbrook,0,23),(James Harden13,22),(Serge Ibaka,9,22),(Thabo Sefolosha,2,27),(Kendrick Perkins,
13、5,27),(Nazr Mohammed,8,34),(Eric Maynor,6,24),(Nate Robinson,3,27),(Nick Collison4,31),Derrick RoseChicago Bulls,1,23),(Luol Deng,9,26),(Carlos Boozer,5,30),(Kyle Korver26,30),(Taj Gibson,22,26),(Joakim Noah,13,26),(Ronnie Brewer,11,26),(C.J. Watson,32,27),(Keith Bogans,6,31),(Omer Asik,3,25),Amare
14、StoudemireNew York Knicks,1,29),(Carmelo Anthony,7,27),(Chauncey Billups,4,35),(Toney Douglas,23,25),(Landry Fields,6,23),(Shawne WilliamsBill Walker,5,24),(Ronny Turiaf,14,28),(Shelden Williams,13,28),(Derrick Brown,2,24) select *from scancategory (2)每支球队插入:INSERT everyteam(teamID,combatgains ,team
15、capital,teamname ) VALUES (001,0.54,2500,),(002,0.75,2650,),(003,0.50,2750,),(004,0.65,2700,),(005,0.54,3200,),(006,0.61,2800,Portland Trail Blazers(3)球员数据插入:INSERT playerdata (playerID ,playername ,spg ,rpg ,ppg ,bpg ,apg ,mpg ,FT ,Fromthree ,jumpershot ) VALUES (a,3.21,5.4,25.5,1.21,5.6,0.32,89.5,
16、42.5,45.4), (b,1.21,5.4,25.5,1.21,5.6,0.32,89.5,42.5,40.4),c,2.21,5.4,25.5,1.21,5.6,0.32,89.5,42.5,30.4),d,2.21,5.4,25.5,1.21,5.6,0.32,89.5,42.5,45.4),e,1.31,5.4,25.5,1.21,5.6,0.32,89.5,42.5,40.4),f,0.21,8.4,25.5,1.21,5.6,0.32,89.5,42.5,35.4)(4)球员号码插入:INSERT playernum (playerID , player1to20 ,player20to40 ,player40up ,playername ),1,0,0,),(,2,0,0,3,0,0,4,0,0,5,0,0,6,0,0, select *from playernum(5)球员插入:INSERT Player (playerID ,playername ,playerNO ,playerage ,playercapital ,teamID ,teamname ) VALUES (Trac
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1