Relational Databases

Objectives

Create a relational database and its main integrity constraints using a DBMS with SQL language

Master the basics of database construction and querying.

Understand how a database management system works (transaction management, access rights).

Design a normalized relational database (3rd normal form)

Design a normalized relational database by modeling with UML.

Course outline

Main concepts covered:

DBMS and how they are used

Definition of relational databases

Relational algebra

The SQL data manipulation language

Creating a database with SQL

Design and standardization (using UML)

Prerequisites

None