Course code 07 67 4020 17
Number of ECTS points 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
Type of classes
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
Unit running the course Instytut Informatyki
Course coordinator dr inż. Krzysztof Myszkorowski, dr hab. inż. Agnieszka Wosiak
Course instructors dr hab. inż. Przemysław Ignaciuk, dr hab. inż. Agnieszka Wosiak
Prerequisites
Mathematics
Course 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.
Programme learning outcomes
    Programme content W TRAKCIE UZUPEŁNIANIA
    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.)
    
     
    Grading policies W TRAKCIE UZUPEŁNIANIA
    Course content LECTURE 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 LABORATORY 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
    116
    Comments
     
    Updated on 2020-02-28 11:52:30
    Archival course yes/no no