Module also offered within study programmes:
General information:
Code:
UBPJO-035
Name:
Introduction to database systems
Profile of education:
Academic (A)
Lecture language:
English
Semester:
Fall
Responsible teacher:
Marcjan Robert (marcjan@agh.edu.pl)
Academic teachers:
Marcjan Robert (marcjan@agh.edu.pl)
Module summary

Students will learn how to design, implement and query relational databases.

Description of learning outcomes for module
MLO code Student after module completion has the knowledge/ knows how to/is able to Connections with FLO Method of learning outcomes verification (form of completion)
Skills
M_U002 Students can program databases using SQL Completion of laboratory classes
M_U003 Students can design and implement database schemas Execution of a project
Knowledge
M_W001 Students know and undrestand principles of database systems Examination
M_W002 Students know and understand how to design, implement and query relational databases Examination
FLO matrix in relation to forms of classes
MLO code Student after module completion has the knowledge/ knows how to/is able to Form of classes
Lecture
Audit. classes
Lab. classes
Project classes
Conv. seminar
Seminar classes
Pract. classes
Zaj. terenowe
Zaj. warsztatowe
Others
E-learning
Skills
M_U002 Students can program databases using SQL - - + - - - - - - - -
M_U003 Students can design and implement database schemas - - + - - - - - - - -
Knowledge
M_W001 Students know and undrestand principles of database systems + - - - - - - - - - -
M_W002 Students know and understand how to design, implement and query relational databases + - - - - - - - - - -
Module content
Lectures:

  1. Introduction
    Basics of database systems, data models, database languages
  1. Entity-Relationship Model
    Basic concepts, keys, constraints, E-R diagrams, UML
  1. Relational model
    Structure of relational databases, relational algebra
  1. Structured Query Language (SQL)
    Queries, DML statements, select, set operation, joins, subqueries, aggregation, data manipulation
  1. Relational database design and implementation
    Principles of database design, functional dependencies, normal forms, normalisation process, database structure implementation, database integrity, integrity constraints, assertions, referential integrity, triggers
  1. Relational database programming
    Procedural SQL, stored procedures, functions

Laboratory classes:

  1. Structured Query Language (SQL)
  1. Relational database design and implementation
  1. Relational database programming

Student workload (ECTS credits balance)
Student activity form Student workload
Summary student workload 116 h
Module ECTS credits 4 ECTS
Participation in lectures 14 h
Preparation for classes 28 h
Completion of a project 30 h
Realization of independently performed tasks 30 h
Participation in laboratory classes 14 h
Additional information
Method of calculating the final grade:

The average value is calculated from all grades obtained from lectures and laboratories:
The final grade is calculated as follows:
if sr>4.75 then OK:=5.0 else
if sr>4.25 then OK:=4.5 else
if sr>3.75 then OK:=4.0 else
if sr>3.25 then OK:=3.5 else OK:=3

Prerequisites and additional requirements:

None

Recommended literature and teaching resources:
  1. C.Date, An Introduction to Database Systems (8th Edition),
  2. A.Silberschatz, H.F. Korth, S. Sudarshan,“Database System Concepts”, Sixth Edition McGrow Hill, 2010.
  3. H.Garcia-Molina, J.Ullman, J.Widom “Database Systems The Complete Book”, Prentice Hall, 2008.
  4. R.Ramakrishan, J .Gecherke “Database management systems” McGraw Hill. 2004
  5. Ravikanth V. Kothuri, Albert Godfrind, Euro Beinat, “Pro Oracle Spatial” Apress 2007
Scientific publications of module course instructors related to the topic of the module:

Additional scientific publications not specified

Additional information:

None