數(shù)據(jù)庫(kù)系統(tǒng)實(shí)驗(yàn)課實(shí)驗(yàn)報(bào)告(編輯修改稿)
2024-08-31 00:00 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 f the instructors also, not just the IDs.(8) Find the maximum and minimum enrollment across all sections, considering only sections that had some enrollment, don39。t worry about those that had no students taking that section(9) As in Question (8), but now also include sections with no students taking them。 the enrollment for such sections should be treated as 0. Do this in two different ways (and create require data for testing) 1). Using a scalar subquery 2). Using aggregation on a left outer join (use the SQL natural left outer join syntax)(10) Find all courses whose identifier starts with the string CS101 (11) Find instructors who have taught all the above courses 1). Using the not exists ... except ... structure 2). Using matching of counts which we covered in class (don39。t forget the distinct clause!) 3. The university rules allow an F grade to be overridden by any pass grade (A, B, C, D). Now, create a view that lists information about all fail grades that have not been overridden (the view should contain all attributes from the takes relation).4. Find all students who have 2 or more nonoverridden F grades as per the takes relation, and list them along with the F出現(xiàn)問題解決方案（列出遇到的問題及其解決方法）《數(shù)據(jù)庫(kù)系統(tǒng)》實(shí)驗(yàn)報(bào)告四學(xué)號(hào)姓名實(shí)驗(yàn)時(shí)間實(shí)驗(yàn)名稱表數(shù)據(jù)管理實(shí)驗(yàn)學(xué)時(shí)2準(zhǔn)備材料1. SQL Plus命令手冊(cè)2. Oracle數(shù)據(jù)字典擴(kuò)展實(shí)驗(yàn)1. 利用企業(yè)管理器的圖形界面輸入數(shù)據(jù)2. 利用企業(yè)管理器或PL SQL Developer導(dǎo)入、導(dǎo)出TXT文檔、Excel表格中的數(shù)據(jù)。(此部分內(nèi)容不要求在實(shí)驗(yàn)室完成，不用寫入實(shí)驗(yàn)報(bào)告。)實(shí)驗(yàn)環(huán)境Oracle 9i(及以上版本)服務(wù)器SQL Plus/ SQL Plus work sheet客戶端實(shí)驗(yàn)?zāi)康?．掌握使用SQL語(yǔ)句對(duì)表進(jìn)行插入、修改和刪除數(shù)據(jù)的操作。2. 掌握索引創(chuàng)建與使用方法實(shí)驗(yàn)內(nèi)容及步驟1. 執(zhí)行文件ddl+，創(chuàng)建數(shù)據(jù)庫(kù)University中所有表。執(zhí)行文件 ，插入實(shí)驗(yàn)數(shù)據(jù)。2. 刪除department表中39。Physics39。記錄，觀察能否成功刪除。若不能刪除，說(shuō)明原因。若能刪除，觀察有外關(guān)聯(lián)的表中數(shù)據(jù)的變化。3. 插入一門新課，課程名“Weekly seminar”,課號(hào)CS001，由Engineering department開出，學(xué)分1，觀察實(shí)驗(yàn)結(jié)果，說(shuō)明原因。4. 調(diào)整各系員工工資，原工資50000的增加10%，否則 增加6%，觀察結(jié)果.5. 第3小題新插入的課程，課程名“Weekly seminar”,課號(hào)CS001，改為由39。Co
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1