155-0331/03 – Basics of Database Systems (ZD)
| Gurantor department | Department of Applied Informatics | Credits | 6 |
| Subject guarantor | Ing. Vítězslav Novák, Ph.D. | Subject version guarantor | Ing. Vítězslav Novák, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 1 | Semester | summer |
| | Study language | Czech |
| Year of introduction | 2016/2017 | Year of cancellation | 2023/2024 |
| Intended for the faculties | EKF | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Understand the fundamental principles of the relational databases.
Design relational databases.
Use commands SELECT, INSERT, UPDATE and DELETE of language SQL.
Create database applications in Microsoft Office Access and SQL Server.
Use the programming language Visual Basic for Application on a simple level.
Teaching methods
Lectures
Tutorials
Summary
The aim of the course is to obtain basic knowledge and skills in the design and implementation of the database applications. The course should introduce students to the SQL and Visual Basic for Applications languages and to the basic database objects such as table, view, stored procedure, or trigger. Students will practice their knowledge with help of the DBMS Microsoft Office Access and Microsoft SQL Server.
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
Hodnocení nabytých vědomostí a dovedností je ověřováno dvěma projekty v průběhu semestru.
První projekt ověřuje pochopení látky po přednášce Microsoft Access Objects a Microsoft ActiveX Data Objects. Úkolem je implementace databázové aplikace v MS Accessu.
Druhý projekt ověřuje pochopení látky celého předmětu. Úkolem je implementace databázové aplikace na MS SQL Serveru. Je odevzdáván v zápočtovém týdnu nebo později.
E-learning
Přednášky a cvičení jsou ve formátu PDF v LMS Moodle.
Other requirements
No other requirements.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Lectures:
1) Data modeling and design of data structures.
2) Normalization of relations.
3) Microsoft Office Access.
4) SQL, Data Definition Language.
5) SQL, Data Manipulation Language, SELECT statement I.
6) SQL, Data Manipulation Language, SELECT statement II.
7) SQL, Data Manipulation Language, INSERT, UPDATE, DELETE statements.
8) Fundamentals of Visual Basic for Application I.
9) Fundamentals of Visual Basic for Application II.
10) Microsoft Access Objects, Microsoft ActiveX Data Objects.
11) Microsoft SQL Server.
12) Transaction.
13) Programmable database objects - views, stored procedures, triggers.
14) Database administration- security, backup, restore of the database.
Tutorials:
Practical training with DBMS.
Conditions for subject completion
Conditions for completion are defined only for particular subject version and form of study
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction