數(shù)據(jù)庫系統(tǒng)原理(實(shí)驗(yàn)二)

沈陽工程學(xué)院學(xué)生實(shí)驗(yàn)報(bào)告〔課程名稱：數(shù)據(jù)庫系統(tǒng)原理〕實(shí)驗(yàn)題目：數(shù)據(jù)更新班級計(jì)算C131學(xué)號2013443133姓名何鑫日期2014-11-06地點(diǎn)F608指導(dǎo)教師孫憲麗、李東鵬一、實(shí)驗(yàn)?zāi)康恼莆誗QL的數(shù)據(jù)更新功能，包括：插入數(shù)據(jù)、修改數(shù)據(jù)和刪除數(shù)據(jù)。二、實(shí)驗(yàn)環(huán)境Oracle10g數(shù)據(jù)庫系統(tǒng)。三、實(shí)驗(yàn)內(nèi)容與要求對實(shí)驗(yàn)一中的三個(gè)表student，course，sc進(jìn)行更新操作。(1)在student表中輸入6條記錄。(2)在course表中輸入4條記錄。(3)在sc表中輸入10條記錄，注意有些課程可有多人選，有些課程可能沒人選。(4)練習(xí)數(shù)據(jù)的刪除和修改。(5)練習(xí)多個(gè)記錄的增加，刪除和修改。四、實(shí)驗(yàn)過程及結(jié)果分析〔1〕insertintostudent_1values('10','何鑫','男',20,'is');insertintostudent_1values('11','王澤研','男',20,'is');insertintostudent_1values('12','張勝昔','男',22,'is');insertintostudent_1values('13','姚天馳','男',22,'is');分析：改正：結(jié)果：(2)InsertIntocourseValues('1','cs',4);InsertIntocourseValues('2','Is',3);InsertIntocourseValues('3','Eg',4);InsertIntocourseValues('3','Sx',6);1rowcreated.

1rowcreated.

1rowcreated.InsertIntocourseValues('3','Sx',6)*ERRORatline1:

ORA-00001:uniqueconstraint(JSJC13236.SYS_C0054380)violated分析：課程號要唯一。改正：InsertIntocourseValues('4','Sx',6);結(jié)果：(3)insertintoscvalues('1','1',80);insertintoscvalues('1','3',85);insertintoscvalues('2','1',73);insertintoscvalues('3','1',92);insertintoscvalues('3','2',73);insertintoscvalues('3','4',86);insertintoscvalues('4','1',85);insertintoscvalues('4','3',70);insertintoscvalues('5','1',69);insertintoscvalues('5','6',75);insertintoscvalues('5','6',75)*ERRORatline1:

ORA-02291:integrityconstraint(JSJC13236.SYS_C0054647)violated-parentkeynotfound分析：外碼必須與所關(guān)聯(lián)的表的主碼相一致,course表中找不到cno=6.改正：insertintoscvalues(‘5’,’4’,75);結(jié)果：〔4〕刪除和修改修改：Updatestudent_1Setsdept='sdept'Wheresno='3';結(jié)果：刪除：DeleteFromstudent_1Wheresno='6';結(jié)果：〔5〕多條記錄插入、刪除、修改插入：insertIntostudent_1(sno,sname,ssex,sage,sdept)Values('6','何鑫','男',20,'IS');insertIntocourse(cno,cname,ccredit)Values('5','l',20);刪除：deleteFromscWheregrade=92;deleteFromscWheresno=‘4’andcno=‘3’;結(jié)果：修改：Updatestudent_1Setsage=22Wheresno='1';Updatestudent_1Setsage=23Wheresno='2';Updatestudent_1Setsage=24Wheresno='3';Updatestudent_1setsdept=’cs’wheres