學(xué)生選課系統(tǒng)的數(shù)據(jù)庫(sqlserver20xx包含er圖)設(shè)計與實現(xiàn)-資料下載頁
2025-10-24 07:47本頁面
【導(dǎo)讀】將上述的E-R圖轉(zhuǎn)換為關(guān)系模型，關(guān)系的主鍵用下橫線標(biāo)出。
【正文】 t values(10006,39。sd39。,39。m39。,23,40802) insert student values(10007,39。dfc39。,39。f39。,23,40803) insert student values(10008,39。xc39。,39。m39。,25,40805) insert student values(10009,39。sd39。,39。f39。,23,40806) insert student values(100010,39。cv39。,39。f39。,27,40806) insert course values(1,39。operating39。,48,8) insert course values(2,39。puter39。,24,4) insert course values(3,39。music39。,56,12) insert course values(4,39。pile39。,48,8) insert course values(5,39。oracle39。,32,6) insert course values(6,39。sql39。,48,8) insert choice values(10001,1,80) insert choice values(10001,2,85) insert choice values(10002,3,86) insert choice values(10002,5,45) insert choice values(10003,1,80) insert choice values(10004,2,87) insert choice values(10004,6,89) insert choice values(10005,1,90) insert choice values(10005,4,100) insert choice values(10006,1,60) insert choice values(10006,3,49) insert choice values(10007,5,70) insert choice values(10008,1,70) insert choice values(10008,6,78) insert choice values(10009,2,80) insert choice values(100010,3,78) insert choice values(100010,1,80) insert choice values(100010,2,78) insert choice values(100010,4,89) insert choice values(100010,5,45) select * from student select * from choice select * from class select *from course select studentNo,studentName from student where sex=39。f39。and age25 create view Num as 東北大學(xué)秦皇島分校電子信息系 第 10 頁 指導(dǎo)教師：李佳音 select classNo,number from class where number50 select * from Num select * from student insert student values(100011,39。newstudent39。,39。f39。,24,40806)
公司管理相關(guān)推薦
鄂ICP備17016276號-1