Informatics 2

Course guarantor:

Jan Pytel

Lecturer:

Jan Pytel

Tutor:

Jan Pytel

Supervisor:

Department of Geomatics

Synopsis:

In the course, students are introduced to the relational model, session normalization, integrity constraints, logical and physical database schema, conceptual schema, as well as database model design methodology, E-R diagrams and data flow diagrams.

Requirements:

no prerequisities

Syllabus of lectures:

Relational databases and SQL language - introduction and brief history

First introduction to SQL

JOIN conditions and clauses

ANSI JOIN, repetition and examples

Aggregation functions, merging gifts and sorting

Subqueries and derived tables

Recursive queries

Creating and editing tables

Database design, ER modeling, normalization

Syllabus of tutorials:

Relational databases and SQL language - introduction and brief history

First introduction to SQL

JOIN conditions and clauses

ANSI JOIN, repetition and examples

Aggregation functions, merging gifts and sorting

Subqueries and derived tables

Recursive queries

Creating and editing tables

Database design, ER modeling, normalization

Study Objective:

The aim of the course is to introduce students to database systems based on the relational database model and the Structured Query Language (SQL). Database design and work with databases are practically demonstrated using the PostgreSQL relational database.

Study materials:

:PostgreSQL, http://www.postgresql.org/docs

:SQLtutor, http://sqltutor.fsv.cvut.cz/

Note:

Further information:

https://geo.fsv.cvut.cz/gwiki/155IN2G_Informatika_2

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	roomTH:B-870 08:00–09:50 (lecture parallel1 parallel nr.101) Thákurova 7 (budova FSv) roomTH:B-870 14:00–15:50 (lecture parallel1 parallel nr.102) Thákurova 7 (budova FSv) roomTH:C-208 12:00–13:50 (lecture parallel1) Thákurova 7 (budova FSv)
Wed
Thu
Fri

Time-table for summer semester 2024/2025:

Time-table is not available yet

The course is a part of the following study plans:

• Geodézie a kartografie (compulsory course)
• Geodézie a kartografie (compulsory course)