Introduction to Databases

Course guarantor:

Dana Majerová

Lecturer:

Dana Majerová

Tutor:

Dana Majerová

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:

Time-table for winter semester 2024/2025:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Wed
Thu
Fri	roomTR:115 Majerová D. 14:00–15:50 (lecture parallel1) Trojanova 13

Time-table for summer semester 2024/2025:

Time-table is not available yet

The course is a part of the following study plans:

• Aplikace informatiky v přírodních vědách (elective course)