Technologies of database designing for Computer Engineering

Field of study: Computer Engineering

Assessment methods: Exam (for the second year of study)

Contents of the Education Lectures
Item number	Study programme						Amount of hours
1	Organizational classes, conditions of the credit						1
2	Review of relational databases. Database model – introduction. Logical data models. Relationships and functions.						4
3	Definitions: instance, schema, table, rows etc., DML or DDL, ERD.						4
4	Mission Critical Applications, VLDB, Selecting a DBMS. Relational Databases Design. Relations: 1 to 1, 1 to many, many to many. Planning. Replication.						2
5	Indexes in data bases						2
6	SQL – Structured Query Language. Data Definition Commands. Data Types. SQL Constraints. SQL Indexes.						5
7	SQL – Structured Query Language. Data Manipulation Commands. Arithmetic Operators and Special Operators. Aggregate Functions and Virtual Tables. Joining Database Tables						5
8	DDL – Data Definition Language. Data Model. Introduction to Object-oriented databases. OQL. ODL. Data Warehouse.						4
9	Technologies of database designing Exam 0 (for the second year of study) – Date on the Moodle platform. Technologies of database designing Exam 1 (for the second year of study) –  Date on the Moodle platform. Technologies of database designing Exam 2 (for the second year of study) – Date on the Moodle platform.						2

Entries to index/USOS System: –

Organisational Remarks:

1. An Final Exam is scheduled at the end of series of lectures.
2. Only three approaches to pass the lectures are possible. Positive evaluations cannot be corrected (however there are some exceptions permitted J).
3. In urgent cases, it is possibile to contact with me via e-mail. The e-mail should be signed.
4. After an assignment each student has the possibility to look exam during consultations.
5. A student loses chance to pass the course in case of absence on the final Exam.
6. Please monitor this page just before classes, because in case of any rearrangements of lectures, a brief information on this topic will appear here.