Database Systems I

Lectures:

- Introduction to database technologies. Motivation, data independence, and RDBMS architecture. Relational data
model.
- Relational algebra. Basic operations.
- SQL language (with a focus to SQL 92), an 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 diagram. Transformation
of a 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 practices. SQL Server is used to evaluate the language.
- Conceptual modeling using Oracle data modeler.
- Conceptual modeling using Toad data modeler.
- SQL JDD and JMD.
- Functional dependencies.
- Database design, BCNF.