MSIM3201 - Database Design and Management

學分: 3
時間: 45小時
先修單元: MSIM1201 Programming Methodology
單元概要
This course provides students a comprehensive framework and practical foundation on the design, implementation and management concepts of database systems. The critical database fundamentals including data query, data integrity, database design, normalization and views, database implementation and administration are covered. In addition, techniques for improving database performance are introduced.
學習成果
Upon completion of this module, students should be able to:
  1. Describe database management system concepts and architecture

  2. Apply appropriate relational models for data manipulation and administration

  3. Design database using modeling techniques, such as normalization, and Entity-Relationship (ER)

  4. Implement database for real-life problems or cases.

  5. Identify suitable administration and management approaches for improving database efficiency and interoperability.