MSIM3201 - Database Design and Management

Year of Study:3
Credit Units: 3
Duration: 45hours
Prerequisites: MSIM1201 Programming Methodology
Module Description
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.
Learning Outcomes
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.