《国立东华大学试题系所资讯管理学系课堂PPT》由会员分享，可在线阅读，更多相关《国立东华大学试题系所资讯管理学系课堂PPT（7页珍藏版）》请在金锄头文库上搜索。
1、國立東華大學 資訊管理學系 資料庫管理資料庫管理 試題試題Wei-Pang Yang, IM.NDHU, 2007 國立東華大學試題國立東華大學試題 系所：資訊管理學系系所：資訊管理學系 科目：資料庫管理科目：資料庫管理 第第1頁頁/共共6頁頁 50 8296 97 9991 93 9489 9483 85 8971 78 8260 62 7051 52 5858 7035 40 5015 18 326 8 1212 32 index set (nondense) Sequence set (dense)- Question 1: About B+ Tree (20%)(a)How index
2、 are used? 有哪三項? 試以上圖解釋之。(b)How to get record with key = 18, and how many disk I/O are needed to get it?(c)If we want to print out all records, at least, how many disk I/O are needed?(d)In general, what are the advantages and disadvantages of using “index”?1國立東華大學 資訊管理學系 資料庫管理資料庫管理 試題試題Wei-Pang Yang
3、, IM.NDHU, 2007nE.g. Consider weak entity payment that depends on entity loan Question 2: E-R Model Tables (20%)a)Draw a relational table for entity loan a)What is the primary key for your table laon? b)Draw a relational table for weak entity paymentc)What is the primary key for your table payment?.
4、2國立東華大學 資訊管理學系 資料庫管理資料庫管理 試題試題Wei-Pang Yang, IM.NDHU, 2007 Question 3: Entity Sets vs. Attributes (10%)nCase 1: telephone-number as an attributesnCase 2: Create a entity set: telephone a)Discuss case 1 之優缺點b)Discuss case 2 之優缺點nConsider a Entity Set: employeenwith attributes (employee-id, employee-n
5、ame, telephone-number)3國立東華大學 資訊管理學系 資料庫管理資料庫管理 試題試題Wei-Pang Yang, IM.NDHU, 2007nExplain the following termsa)blobb)clobc)Logical database designd) e) f)Specialization vs. Generalization in E-R diagramg)UML Diagramh)Update Anomalies!Question 4: Explain Terms (20%)grant on to EXEC SQL END-EXEC4國立東華大學
6、 資訊管理學系 資料庫管理資料庫管理 試題試題Wei-Pang Yang, IM.NDHU, 2007a)When we delete a tuple in branch, eg. Brighton Broklyn 7100000,what will happen in account? create table account (account-number char(10), branch-name char(15), balance integer, primary key (account-number), foreign key (branch-name) references br
7、anch on delete set null on update cascade ) 5. account 1. branchreferencesQuestion 5: Referential Integrity (15%) b) When we update the first tuple in branch, eg. Donghwa Broklyn 7100000,what will happen in account?c) When we delete the first tuple in account,what will happen in branch?5國立東華大學 資訊管理學
8、系 資料庫管理資料庫管理 試題試題Wei-Pang Yang, IM.NDHU, 2007nAccording to your final project as “Design and implement a useful database application system”a)What is the title of your project?b)Names of members in your team.c)Draw the E-R Diagram of your application system. (You can just give a similar diagram.)d)D
9、raw a table to show one relation used in the systeme)Check your answer in d) to see whether it is in the 1NF? Why? Please answer “why” by using the definition of the 1NF.f)Same as e) to see whether it is in the 2NF? Why?g)Same as e) to see whether it is in the 3NF? Why?Question 6: About Your Final Term Project (15%)6 素材和资料部分来自素材和资料部分来自网络，如有帮助请下载网络，如有帮助请下载!
