Course: 資訊庫系統─Database Systems

• Introduction
  Databases and Database Users, Database System Concepts and Architecture, Entity-Relationship Model, Relational Data Model and Relational Algebra, SQL, The Relational Calculus, Conventional Data Models, Functional Dependencies and Normalization, Relational Database Design Algorithms, System Catalog, Query Processing and Optimization, Transaction Processing Concepts, Concurrency Control Techniques, Recovery Techniques, Database Security and Authorization, Object-Oriented Databases
• Topics (Last Update: 91/5/23)
  • Chpater 1: Databases and Database Users [slide]
  • Chpater 2: Database System Concepts and Architecture [slide]
  • Chpater 3: Data Modeling Using the Entity-Relationship (ER) Model [slide]
  • Chpater 4: Enhanced Entity-Relationship and Object Modeling [slide]
  • Chapter 7: The Relational Data Model, Relational Constraints, and the Relational Algebra [slide]
  • Chapter 8: SQL-The Relational Database Standard [slide]
  • Chapter 9: ER- and EER-to-Relational Mapping, and Other Relational Languages [slide]
  • Chapter 11: Concepts for Object-Oriented Databases [slide]
  • Chapter 12: Object Database Standards, Languages, and Design [slide]
  • Chapter 13: Object Relational and Extended Relational Database Systems [slide]
  • Chapter 14: Functional Dependencies and Normalization for Relational Database [slide]
  • Chapter 18: Query Processing and Optimization [slide]
  • Chapter 19: Transaction Processing Concepts [slide]
  • Chapter 21: Recoverable Techniques [slide]
• Reference Book
  Ramenz Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems, 3rd Edition, Addison-Wesley.
• 成績評量方式
  作業 (作業繳交情形 [new, 91/6/19])，期中考，期中專題，期末考
• 預修課程
  資料結構，程式語言