2010 Final Test-.ppt

Introduction to Database System Wei-Pang Yang, IM.NDHU, 2010 Introduction to Database System Wei-Pang Yang, IM.NDHU, 2010 Introduction to Database System Wei-Pang Yang, IM.NDHU, 2010 Introduction to Database System Wei-Pang Yang, IM.NDHU, 2010 Introduction to Database System Wei-Pang Yang, IM.NDHU, 2010 Introduction to Database System Wei-Pang Yang, IM.NDHU, 2010 Introduction to Database System Wei-Pang Yang, IM.NDHU, 2010 Introduction to Database System Wei-Pang Yang, IM.NDHU, 2010 2010 Final Test-* Example:Banking Database 1. branch 2. customer 客戶(存款戶,貸款戶) 5. account 存款帳 3. depositor 存款戶 6. loan 貸款帳 4. borrower 貸款戶 分公司 國立東華大學試題: 資料庫管理 (每題10分；共100分) 資訊管理學系2010.06.22 Question 1: Terms Explanation (10%) Semantic Data Model Weak Entity UML Diagram Logical Database Design Functional Dependency Draw the Functional Dependency Diagram for table laon in page 1. Update Anomalies Minimize the number of Disk Access 2010 Final Test-* Question 2: Real-world vs. E-R Model vs. Tables (10%) 1. branch 2. customer 客戶(存款戶,貸款戶) 3. depositor 存款戶 分公司 Semantic Data Model: Entity-Relationship (E-R) Data Model The real-world enterprise 試討論 Real-world, E-R Model , 及Tables 之關係 2010 Final Test-* Suppose we have a relationship set borrower between customer and loan as shown in Figure 1. Draw an E-R Diagram for the application system in Figure 1. (Please show the mapping cardinalities.) What does it mean by the total participator, and which one is it? What does it mean by the partial participator, and which one is it? Question 3: E-R Model (10%) . . . . customer loan E1 E2 E3 E4 . . . Relationship Set: borrower Figure 1. 2010 Final Test-* E.g. Consider weak entity payment that depends on entity loan Question 4: E-R Model ? Tables (10%) Draw a relational table for entity loan . What