資料庫系統

臺北科技大學 115-1 學期課程，課號 362048。

課程大綱

This course is designed to introduce concepts and skills essential in the database systems. Relational database will be the main focus with related topics such as relational model, design concepts, and structured query language. The topics to be covered include: introduction to database systems, record storage and file organizations, indexed structures for files, the relational model, relational algebra and calculus, SQL, conceptual and logical design for relational database, functional dependencies, normalization and database management system technology.

課程進度

Week Topics ---- ----------------------------- 1 Databases and Database User 2 Database System Concepts & Architecture 3 Entity-Relationship Data Modeling 4 Enhanced Entity-Relationship & UML Modeling 5 Relational Data Model & Constraints 6 Relational Database Design 7 SQL 8 Midterm Exam 9 Project Presentation 10 More SQL 11 Functional Dependencies and Normalization 12 Relational Database Design Algorithms 13 Practical Database Design Methodology 14 Disk Storage and Basic File Structures 15 Indexing Structures for Files 16 Final Exam 17 Project Presentation 18 Project Presentation

評量方式

1. Homework and Attendance (15%) 2. Exams a. Midterm (30%) b. Final (30%) 3. Team Project (25%)

教材

【遵守智慧財產權觀念，請使用正版教科書，不得使用非法影印教科書】 使用外文原文書：是 Textbook: Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems, 7th Edition, Pearson, 2017. Reference Books: Abraham Silberschatz, Henry F. Kotth, and S. Sudarshan, Database System Concepts, 7th Edition, McGraw Hill, 2019. Thomas Connolly and Carolyn Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition, Pearson Education Limited, 2015.