Fundamentals of Data Models and Databases

Course Title  

Fundamentals of Data Models and Databases

Course Code

IT5482

Level  

5

Status            

Compulsory

Credits

15

Prerequisite 

None

Course offered in

Refer to Programme Course Selection Sheet, Online

 

 

Duration

1 trimester

 

Aim

To introduce students to the concepts of data models and databases

 

Indicative course content

Introduction & Systems Theory, Introduction to design of database systems, System Development Lifecycle (SDLC), Modelling System Requirements , Entity Relationship Concepts , ERD Exercises (1:1, 1:M), ERD Exercises (M:N), Entity Relationship Modelling,  Business Rules, Cardinality, Introduction to MS Visio , Business Process Modelling (BPM), Introduction to Database Design , Database Design (Continued), Introduction to Functional Modelling, (Function Hierarchy Diagrams – FHDs), CRUD Matrix Diagrams, Normalization (UNF, 1NF) , Data Definition Language (DDL) and MS SQL Server, OO Modelling

 

Learning outcomes

  1. Design a logical model that defines the data requirements of a simple system that conforms to second normal form.
  2. Create a functional hierarchy diagram that defines the functional requirements of a simple system and their logical groupings.
  3. Develop a CRUD matrix that documents the database operations required to perform the steps defined in a process model.
  4. Build a simple database that includes tables, columns, primary keys, foreign keys and

 

 

 

Got a question or feedback?
Call us on 0800 944 847
or send us a message