国立东华大学试题系所资讯管理学系课件

1、 國立東華大學試題 系所：資訊管理學系 科目：資料庫管理 第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%)How index are used? 有哪三項? 試以上圖解釋之。How to get record with key = 18, and how many disk I/O are neede

2、d to get it?If we want to print out all records, at least, how many disk I/O are needed?In general, what are the advantages and disadvantages of using “index”?1E.g. Consider weak entity payment that depends on entity loan Question 2: E-R Model Tables (20%)Draw a relational table for entity loan What

3、 is the primary key for your table laon? Draw a relational table for weak entity paymentWhat is the primary key for your table payment?.2 Question 3: Entity Sets vs. Attributes (10%)Case 1: telephone-number as an attributesCase 2: Create a entity set: telephone Discuss case 1 之優缺點Discuss case 2 之優缺點

4、Consider a Entity Set: employeewith attributes (employee-id, employee-name, telephone-number)3Explain the following termsblobclobLogical database design Specialization vs. Generalization in E-R diagramUML DiagramUpdate Anomalies!Question 4: Explain Terms (20%)grant on to EXEC SQL END-EXEC4According

5、to your final project as “Design and implement a useful database application system”What is the title of your project?Names of members in your team.Draw the E-R Diagram of your application system. (You can just give a similar diagram.)Draw a table to show one relation used in the systemCheck your answer in d) to see whether it is in the 1NF? Why? Please answer “why” by using the definition of the 1NF.Same as e) to see whether it is in the 2NF? Why?Same as e