數(shù)據(jù)庫實(shí)驗(yàn)報(bào)告四(編輯修改稿)
2024-08-17 11:37 本頁面
【文章內(nèi)容簡介】 PJIndex索引l 實(shí)驗(yàn)結(jié)果(1) 實(shí)驗(yàn)主要截圖（2） 實(shí)驗(yàn)主要截圖數(shù)據(jù)表student的建立和數(shù)據(jù)的輸入數(shù)據(jù)表course的建立和數(shù)據(jù)的輸入數(shù)據(jù)表sc的建立和數(shù)據(jù)的輸入（3） 1） 數(shù)據(jù)表S的創(chuàng)建和數(shù)據(jù)的輸入use ShiYancreate table S(SNO char(4) primary key,SNAME varchar(20) not null,STATUS smallint,CITY varchar(30),)use ShiYaninsert into S values(39。S139。,39。精益39。,20,39。天津39。)insert into S values(39。S239。,39。盛錫39。,10,39。北京39。)insert into S values(39。S339。,39。東方紅39。,30,39。北京39。)insert into S values(39。S439。,39。豐泰盛39。,20,39。天津39。)insert into S values(39。S539。,39。為民39。,30,39。上海39。)2） 數(shù)據(jù)表P的創(chuàng)建和數(shù)據(jù)的輸入use ShiYancreate table P(PNO char(4) primary key,PNAME varchar(20) not null,COLOR char(6),WEIGHT real default(0),)use ShiYaninsert into P values(39。P139。,39。螺母39。,39。紅39。,12)insert into P values(39。P239。,39。螺栓39。,39。綠39。,17)insert into P values(39。P339。,39。螺絲刀39。,39。藍(lán)39。,14)insert into P values(39。P439。,39。螺絲刀39。,39。紅39。,14)insert into P values(39。P539。,39。凸輪39。,39。藍(lán)39。,40)insert into P values(39。P639。,39。齒輪39。,39。紅39。,30)3） 數(shù)據(jù)表J的創(chuàng)建和數(shù)據(jù)的輸入use ShiYancreate table J(JNO char(4) primary key,JNAME varchar(20) not null,CITY varchar(30),)use ShiYaninsert into J values(39。J139。,39。三建39。,39。北京39。)insert into J values(39。J239。,39。一汽39。,39。長春39。)insert into J values(39。J339。,39。彈簧廠39。,39。天津39。)insert into J
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1