Introduction to Database Systems

Lectures:

- Introduction into database technologies. Motivation, data independence and RDBMS architecture. Relational data model.
- Relational algebra. Basic operations.
- SQL language (with focus to SQL 92), introduction of database querying using Select command.
- SQL Select - inner queries
- SQL Select - inner and outer join, aggregation functions and grouping.
- Conceptual modeling. Entity, entity type, relation, integrity constraints, ER diagram, UML diagam. Transformation of an conceptual model to a relational data model.
- SQL - data modification language (DML), data definition language (DDL).
- Functional and dynamic analysis.
- Functional dependencies.
- Normal forms and BCNF.
- Comparison of existing RDBMS.

Exercises:

- Relational data model.
- SQL Select statement practising using a SQL Server.
- Conceptual modeling using Oracle data modeler.
- Conceptual modeling using Toad data modeler.
- SQL JDD and JMD.
- Functional dependencies.
- Database design, BCNF.