IS112

Download as PDF

Data Management

Course (UG/PG)

Undergraduate

Offering Unit/Department

Course Description

This course will cover fundamentals of relational database theory, important data management concepts such as data modelling, database design, database implementation in current business information systems, and some basic concepts related to unstructured data.A series of in-class exercises, tests, pop quizzes and a course project will help students understand the covered topics. Students are expected to apply knowledge learned in the classroom to solve many problems based on real-life business scenarios, while gaining hands-on experience in designing, implementing, and managing database systems. Students are also expected to understand the differences between structured data and unstructured data.This course is applicable to students declaring a major from SIS.

Course Learning Outcomes

1) Explain the concepts of Entity-Relationship (ER) Model

2) Explain the concepts of Enhanced Entity-Relationship (EER) Model

3) Develop an EER model for a given application to support a given list of functions

4) Explain the concepts of relations and the seven steps required to transform a given ER/EER model to a relational schema

5) Apply the transformation from ER/EER models to relations in many scenarios

6) Explain the concepts of data normalization and the first three normal forms

7) Apply data normalization in many scenarios

8) Explain the Structured Query Language (SQL)

9) Demonstrate how to build a database and how to retrieve data from the database via MySQL

10) Build a database for a given scenario and write SQL statements to retrieve data from it

11) Explain the concepts of unstructured data and similarity search in text

Discipline-Specific Competencies

Data Design, Design Thinking Practice, Software Design, Solution Architecture, Computational Modelling