Introduction to Databases

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Software Engineering

Synopsis:

This course is an introduction to relational database systems. Students will learn basic concepts and how to design a relational database. Students will be able to work with data using SQL. Credit is awarded for the seminar work (ERA model of relational database and its implementation in SQL).

Requirements:

Syllabus of lectures:

1. Basic concepts, characteristics of data in databases.

2. Relational data model.

3. Conceptual models, ERA model.

4. 4. Types of relations, decomposition of M:N relation.

5. Integrity constraints, primary key, foreign key.

6. Database schema normalization.

7. SQL - language for data definition.

8. SQL - language for data manipulation.

9. SQL - single table queries.

10. SQL - queries to multiple tables.

11. SQL - more advanced queries.

12. Views.

Syllabus of tutorials:

1.-2. Decomposition of the M:N relation.

3.-4. Normal forms of tables.

5.-7. Examples of relational database design.

8.-11. SQL language.

12. SQL: creating and using a view.

Study Objective:

Study materials:

Required literature:

[1] studijní materiály v Moodle

[2] POKORNÝ, Jaroslav a VALENTA, Michal. Databázové systémy. 2. přepracované vydání. Praha: Česká technika - Nakladatelství ČVUT, 2020. ISBN 978-80-01-06696-6.

Recommended literature:

[3] UMANATH, Narayan S. a SCAMELL, Richard W. Data modeling and database design. Second edition. Boston, MA: Cengage Learning, [2015]. ISBN 978-1-285-08525-8.

[4] CORONEL, Carlos a MORRIS, Steven. Database systems: design, implementation, and management. 11th edition. Stamford: Cengage Learning, [2015]. ISBN 978-1-285-19614-5.

[5] LAURENČÍK, Marek. SQL: podrobný průvodce uživatele. Průvodce (Grada). Praha: Grada Publishing, 2018. ISBN 978-80-271-0774-2.

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: