Module also offered within study programmes:
General information:
Name:
Databases
Course of study:
2017/2018
Code:
IES-1-609-s
Faculty of:
Computer Science, Electronics and Telecommunications
Study level:
First-cycle studies
Specialty:
-
Field of study:
Electronics and Telecommunications
Semester:
6
Profile of education:
Academic (A)
Lecture language:
English
Form and type of study:
Full-time studies
Course homepage:
 
Responsible teacher:
dr inż. Orzechowski Tomasz Marcin (tomeko@agh.edu.pl)
Academic teachers:
Module summary

Understanding the relational database model and the ability to create a database and use SQL queries.

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_U001 Student is able to design of database systems using normalization techniques. ES1A_U27, ES1A_U01, ES1A_U10, ES1A_U22 Project
M_U002 The student correctly uses SQL commands (DQL, DML and DDL) ES1A_U01 Execution of laboratory classes
M_U003 The student can use the documentation available on the web. ES1A_U01 Execution of laboratory classes
Knowledge
M_W001 Student knows SQL – Structured Query Language ES1A_W06 Execution of laboratory classes
M_W002 Student is familiar with the terminology related to relational databases model. ES1A_W06 Test,
Execution of laboratory classes
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_U001 Student is able to design of database systems using normalization techniques. - - - + - - - - - - -
M_U002 The student correctly uses SQL commands (DQL, DML and DDL) - - + - - - - - - - -
M_U003 The student can use the documentation available on the web. - - + - - - - - - - -
Knowledge
M_W001 Student knows SQL – Structured Query Language + - - - - - - - - - -
M_W002 Student is familiar with the terminology related to relational databases model. + - - - - - - - - - -
Module content
Lectures:
  1. Fundamentals (1)

    Introduction of DDL, DML, DQL & DCL
    DBMS characteristics including table stuctures.

  2. Relational databases – DQL (3)

    Queries with SELECT statement;
    Projection and Selection;
    Ordering and grouping results;
    Aggregate functions;
    The use of JOINs (CARTESIAN JOIN, LEFT/RIGHT JOIN);

  3. Relational databases – DDL and DML (3)

    Types
    Keys and constraints
    INSERT, UPDATE and DELETE statements
    CREATE TABLE statement

  4. Relational databases – VIEWS (1)

    How to create and remove VIEWs;
    Views advantages and disadvantages over tables;

Laboratory classes:
  1. Practice of DQL (12h)

    1. Projection and Selection;
    2. Ordering and grouping results;
    3. Aggregate functions;
    4. Nested statements;
    5. CARTESIAN JOIN, LEFT/RIGHT JOIN;

    1h of TEST after 2 and 4 classes.

  2. Practise of DML & DDL (6h)

    1. Types
    2. INSERT, UPDATE and DELETE statements
    3. CREATE TABLE statement
    4. Keys and constraints

    1h of TEST after 4 class.

  3. Practise of VIEWS and triggers (2h)

    1. The use of VIEWS
    2. The use if triggers

Project classes:
Normalisation – development of a relational database model

Selecting a fragment of reality and transforming a selected structure into a relational database model using normalization techniques up to the 4th normal level inclusive.

Student workload (ECTS credits balance)
Student activity form Student workload
Summary student workload 52 h
Module ECTS credits 3 ECTS
Participation in lectures 8 h
Participation in laboratory classes 20 h
Preparation for classes 10 h
Completion of a project 14 h
Additional information
Method of calculating the final grade:

TESTS – three test during laboratory classes – weight 6.
PROJECT – weight 4.

Prerequisites and additional requirements:

none

Recommended literature and teaching resources:

1. Thomas Connolly & Carolyn Begg: Database Systems – A Practical Approach to Design, Implementation, and Management; Pearson Education Limited
2. Documentation on-line: MySQL Reference Manual: https://dev.mysql.com/doc/refman/8.0/en/

Scientific publications of module course instructors related to the topic of the module:

Additional scientific publications not specified

Additional information:

None