Database Systems
Module ID
Y402
Semester
4
Hours/Week - ECTS
5 – 5
Learning Outcomes
- Understanding the role and architecture of database systems.
- Acquisition of knowledge and skills on modeling, designing, and programming database systems.
- Gaining experience in installing, programming, and managing a Database Management System.
Indicative Module Content
-
Introduction to Database Management Systems (DMS)
-
The architecture of a DBMS
-
Data modeling with the Entity-Relationship (E/R) Model
-
The Relational model
-
Conversion of an Entity-Relationship Model to the Relational Model
-
Relational Algebra
-
The SQL language (data definition and management)
-
Introduction to a Relational Database System
-
Functional Dependencies and Normalization