VSFS:B_UDS Introduction to Database Sys. - Course Information

B_UDS Introduction to Database Systems

Extent and Intensity

2/2/0. 6 credit(s). Type of Completion: zk (examination).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_UDS/cAPH: Wed 15:45–16:29 E306, Wed 16:30–17:15 E306, except Wed 6. 3. ; and Thu 21. 3. 10:30–12:00 E007KC, V. Nulíček
B_UDS/pAPH: Wed 14:00–14:44 E007KC, Wed 14:45–15:30 E007KC, except Wed 6. 3. ; and Thu 21. 3. 8:45–10:15 E007KC, V. Nulíček
B_UDS/vAPH: Fri 9. 2. 17:30–19:00 E307, 19:15–20:45 E307, Sat 24. 2. 14:00–15:30 E307, 15:45–17:15 E307, Fri 22. 3. 17:30–19:00 E307, 19:15–20:45 E307, Fri 26. 4. 17:30–19:00 E307, V. Nulíček

Prerequisites

There are no prerequisites for this course.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

The goal of the course is to teach students the basics of relational database creation from the design phase through the creation of ERDs and relational models to the actual implementation of database creation in the SQL environment. The student will also learn about the theoretical basics of relational database creation, database normalization, relational algebra and relational calculus. Students will also learn to use SQL query language, create SQL queries and other scripts in this language.

Learning outcomes

At the end of this course, the student will be able to:
- create an ER-model in compliance with the normalization rules
- convert the ERD into a relational model with integrity constraints set
- create SQL scripts to create a database
- define basic and more advanced SQL queries over one or more tables

Syllabus

• 1. Basic concepts from DBS theory
• 2. DBS modeling, ER diagram
• 3. Normalization of the database
• 4. Armstrong's rules, determining keys
• 5. Logical model level, relational model
• 6. Relational algebra and relational calculus
• 7. Query languages, SQL - basic definition of
• 8. SQL – creation and modification of tables, referential integrity
• 9. SQL – SELECT command, board connection
• 10.SQL - aggregation function
• 11.SQL - nested queries
• 12.SQL - internal functions,
• data types

Literature

required literature
• POKORNÝ, Jaroslav a Michal VALENTA. Databázové systémy. Praha: České vysoké učení technické v Praze, 2013. ISBN 978-80-01-05212-9.
• LAURENČÍK, Marek. SQL: podrobný průvodce uživatele. Praha: Grada Publishing, 2018. Průvodce (Grada). ISBN 978-80-271-0774-2¨.

recommended literature
• OPPEL, Andrew J. Databáze bez předchozích znalostí: [průvodce pro samouky]. Brno: Computer Press, 2006. ISBN 80-251-1199-7
• Date, C. J. An Introduction to Database Systems. Addison-Wesley, 1995. ISBN 0-201-82458-2.
• STEPHENS, Ryan K., Ronald R. PLEW a Arie JONES. Naučte se SQL za 28 dní: [stačí hodina denně]. Brno: Computer Press, 2010. ISBN 978-80-251-2700-1.
• OPPEL, Andrew J. SQL bez předchozích znalostí: [průvodce pro samouky]. Brno: Computer Press, 2008. ISBN 978-80-251-1707-1.

Teaching methods

Lectures and seminars in the full-time study, seminars in the combined study

Assessment methods

Several seminar examples given in the exercises need to be written on the credit. The exam consists a written test and an oral exam verifying student knowledge that affects the final score.

Language of instruction

Czech

Follow-Up Courses

• B_RD Relation Database

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 14 hodin KS/semestr.

• Enrolment Statistics (Summer 2024, recent)
  
• Permalink: https://is.vsfs.cz/course/vsfs/summer2024/B_UDS