Credit Points: 3
Lecture: 2 hours,
Exercise: 2 hours
Prerequisites: Data Structures
General: The course covers design and implementation of database systems.
Databases are one of the main components of today's modern information systems.
The emphasis is on Entity Relation Modeling for relational databases. Extensions to
object oriented are also covered. With the knowledge of design, the students then
learn the implementation principles (relation algebra) and practice (SQL language).
Topics:
1. Introduction to data management and principles of database systems
2. Definition and structures of databases
3. Operation and performance of databases, OLTP database.
4. Design of data model – entity-relationship model
5. Design of data model – normalization of database
6. Survey of classical models – networks and hierarchies
7. Principles of the table model
8. Table algebra – principles and operators
9. SQL language – structure and data retrieval
10. SQL language – database definition and update
11. Reliability, missing data and optimization
12. Distributed databases, data distribution methods
13. Object oriented databases
