Database Systems

Learning Outcomes

Upon successful completion of the course, students will be able to:

• Understand the role and architecture of DB systems
• Model and design DB
• Program databases
• Know the Physical Organization of the DBs
• Install and manage DB systems

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