nba球員球隊(duì)信息管理系統(tǒng)項(xiàng)目設(shè)計(jì)方案(劉嘯塵-魏春月)(編輯修改稿)
2025-05-30 01:54 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 ull,)創(chuàng)建外鍵球隊(duì)名Alter Table QC Add Constraint FK_球隊(duì)名_QC Foreign Key(球隊(duì)名)References Team(球隊(duì)名)創(chuàng)建外鍵比賽類型Alter Table QC Add Constraint FK_比賽類型Foreign Key(比賽類型)References race(比賽類型)球員參賽表列名數(shù)據(jù)類型寬度是否主外鍵是否為空描述1.球隊(duì)名Varchar20球隊(duì)表FKNot Null球隊(duì)名2比賽類型Varchar10比賽表FKNot Null比賽類型3.場(chǎng)均得分FloatNot Null場(chǎng)均得分4.個(gè)人獎(jiǎng)項(xiàng)Varchar15個(gè)人獎(jiǎng)項(xiàng)球員參賽表建表TSQL語(yǔ)句創(chuàng)建球員參賽表create table PC(球員姓名char(20)not null,比賽類型char(10) not null,場(chǎng)均得分float not null,個(gè)人獎(jiǎng)項(xiàng)char(15),)創(chuàng)建外鍵球員姓名Alter Table PC Add Constraint FK_球員姓名Foreign Key(球員姓名)References player(球員姓名)創(chuàng)建外鍵比賽類型Alter Table pc Add Constraint FK_比賽類型_PC Foreign Key(比賽類型)References race(比賽類型)以上是六個(gè)表格的建立及代碼，下面是數(shù)據(jù)庫(kù)的插入數(shù)據(jù)和創(chuàng)建索引，代碼如下：向賽區(qū)表加入數(shù)據(jù)Insert into Division values (39。EN39。, 39。東北39。)insert into Division values (39。WS39。, 39。西南39。)insert into Division values (39。ES39。,39。東南39。)insert into Division values (39。WN39。,39。西北39。)向球隊(duì)表加入數(shù)據(jù)insert into Team values(39。凱爾特人39。,39。波士頓39。, 39。1439。, 39。1739。, 39。EN39。, 39。739。)insert into Team values(39。熱火39。,39。邁阿密39。,39。1539。,39。239。,39。ES39。,39。239。)insert into Team values(39。湖人39。,39。洛杉磯39。,39。1539。,39。1639。,39。WS39。,39。1139。)insert into Team values(39。雷霆39。,39。俄荷拉何馬39。,39。1439。,39。139。,39。WN39。,39。239。)向球員表加入數(shù)據(jù)insert into player values (39。Kobe Byrant39。,39。3439。,39。19839。,39。9339。,39。美國(guó)39。,39。得分后衛(wèi)39。,39。湖人39。,39。200039。,39。1996081239。)Insert into player values(39。Dwight Howard39。,39。2739。,39。21139。,39。12039。,39。美國(guó)39。,39。中鋒39。,39。湖人39。,39。170039。,39。2012080939。)insert into player values(39。Steve Nash39。,39。3839。,39。19139。,39。8039。,39。加拿大39。,39?？厍蚝笮l(wèi)39。,39。湖人39。,39。120039。,39。2012082239。)insert into player values(39。Dwyane Wade39。,39。3039。,39。19339。,39。9939。,39。美國(guó)39。,39。得分后衛(wèi)39。,39。熱火39。,39。170039。,39。2003091139。)insert into player values(39。Chris Bosh39。,39。2839。,39。21139。,39。10639。,39。美國(guó)39。,39。中鋒39。,39。熱火39。,39。166539。,39。2010072539。)insert into player values(39。Leborn James39。,39。2839。,39。20339。,39。11339。,39。美國(guó)39。,39。得分后衛(wèi)39。,39。熱
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1