Course code 07 67 4020 17
ECTS credits 6
Course title in the language of instruction
Fundamentals of Databases
Course title in Polish Fundamentals of Databases (Podstawy baz danych)
Course title in English
Fundamentals of Databases
Language of instruction English
Course level first-cycle programme
Course coordinator dr inż. Krzysztof Myszkorowski, dr hab. inż. Agnieszka Wosiak
Course instructors dr hab. inż. Przemysław Ignaciuk, dr hab. inż. Agnieszka Wosiak
Delivery methods and course duration
Lecture Tutorials Laboratory Project Seminar Other Total of teaching hours during semester
Contact hours 30 30 0 60
E-learning No No No No No No
Assessment criteria (weightage) 0.55 0.45 0.00
Course objective
  1. The course covers issues regarding basic concepts in the field of database systems, presents the methodology of modeling and designing databases and describes the way of processing queries in a relational data model. The issues discussed are covered by practical exercises.
Learning outcomes
  1. A student who completed the course can design a logical database structure in accordance with the indicated requirements.
  2. A student who completed the course can formulate queries using relation algebra operators and SQL.
  3. A student who completed the course can implement and describe a relational database.
Assessment methods
Written exam (learning outcomes 1. and 2.)
Laboratory test learning outcomes 2. and 3.)
Reports during laboratory classess learning outcomes 1., 2. and 3.)

Course content with delivery methods
Lectures include the following issues:
1. Architecture of the Database Management System
2. Data models. Entity-Relationship Model
3. Relational databases. Functional dependencies and normalization
4. Relational Algebra
5. SQL - Structured Query Language
6. Transaction Management

During laboratory classes students perform exercises related to issues, which are discussed during lectures.
Basic reference materials
  1. Elmasri R., Navathe S.: Fundamentals of Database Systems. (7th edition), Pearson, 2015
  2. Ullman J., Widom J.:First Course in Database Systems. (3rd edition) Pearson, 2014
  3. Garcia-Molina H., Ullman J., Widom J.: Database systems. The complete book. (2nd edition), Pearson, 2014
  4. Connolly T., Begg C.: Database Systems: A Practical Approach to Design, Implementation, and Management. (6th edition) Pearson, 2015
  5. Date C. J.: Introduction to Database Systems. (8th edition) Pearson, 2006
  6. Hoffer J., Ramesh. V. Topi H.: Modern Database Management, 13th Edition, Pearson 2019
Other reference materials
  1. Bagui S.: Database design using entity-relationship diagrams. CRC Press/Taylor&Francis Group/An Auerbach Book, 2012
  2. Teorey T.J.: Database modeling and design : logical design. Morgan Kaufmann Publishers is an imprint of Elsevier, 2011
Average student workload outside classroom
Last update 2020-02-28 11:52:30