Course detail

Database Systems

FP-MdbsKAcad. year: 2019/2020

The course focuses especially on the following topics: History of database systems, architecture of database management systems. SQL server – general overview. Relational database system. Data types, data organization and storage, indexes, SQL language, Creation and connection of tables. Limitation of tables and normalization. Transactions, locks and saved operations. Use of databases in the internet. XML technology. Analytical services. Security.

Language of instruction

Czech

Number of ECTS credits

6

Mode of study

Not applicable.

Learning outcomes of the course unit

Students will acquire basic knowledge regarding database systems including up-to-date trends in the database technologies development. They will master fundamental principles of and skills in the work with SQL language by means of creation of database application for relational databases in the client/server environment and in the Internet.

Prerequisites

Knowledge of data modelling, algorithmization and programming techniques as well as fundamentals of HTML language are required.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

The course contains lectures that explain basic principles, problems and methodology of the discipline, and exercises that promote the practical knowledge of the subject presented in the lectures.

Assesment methods and criteria linked to learning outcomes

Prerequisites:
Student has to obtainat least 50% of the possible maximum during the semester (20 points of 40).
If would be detected plagiarism or unauthorized collaboration on projects, or at mid-term test, credit will be granted with consideration of disciplinary proceedings.
Mid-term test - writing, (answers could be by selecting one of several posibilities, sentence answers or a combination thereof) and developing practical task by submission. There is no trial. (20 points)
Development of the project - one project by entering the appropriate documentations. The submission is presented to students in the second lecture. (20 points)

Test conditions:
Final exam - written form, a test (answers could be by selecting one of several posibilities, sentence answers or a combination thereof) and an oral examination. (60 points for the written part of the exam, the successful completion of the exam, written exam has to be written to be evaluated by at least 30 points, otherwise the test is scored 0 points with the evaluation of F.)

Course curriculum

Topics of lectures is as follows:
- History of Database Systems
- Relational database management system, data types, data storage and index structures
- Language commands T-SQL
- Creating tables and their changes, mergers, restrictions and normalization
- Views, Stored Procedures
- Transactions and Locks
- Triggers
- Advanced queries
- SQL Server Analysis Services
- The practical part of the training is done in MS SQL Server.
- Backup and data replication
- Data Security
- XML Technology
- New trends in database technology

Work placements

Not applicable.

Aims

Not applicable.

Specification of controlled education, way of implementation and compensation for absences

Attendance at lectures is not compulsory. Seminars with computer support is required, attendance is controled. One absence from seminars, teacher apologize. Student will replace this lack of elaboration especially given homework.

Seminars with computer support are focused on teaching features and tools of MS SQL Server including query language SQL. During the semester, steudent writes semester test for maximum of 20 points. For this semester test is no trial. If a student has a well-documented and excused absence for the semester test by teacher, he/she can sign on an alternative date.

In the second lecture is given separate project for a maximum of 20 points to students. To accept this project, student has to obtain min. 10 points. The project student submits in the credit week.
Students who have an individual learning plan (ie. they do not go into lectures) must prepare and submit a special individual project for the credit. For this particular project can get 30 points.

The course ends with a written exam for a maximum of 60 points. Participation in the test is mandatory.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

VIEIRA, R.: SQL Server 2000 – programujeme profesionálně. Praha, Computer Press 2001, 1105 s., ISBN 80-7226-506-7 (CS)
STEPHENS, R.K., PLEW R.R.: Naučte se SQL za 21 dní. Brno, Computer Press 2004, 491 s., ISBN 80-722-6870-8 (CS)

Recommended reading

ŠIMŮNEK M.: SQL kompletní kapesní průvodce. Praha, Grada 1999, 244 s., ISBN 80-7169-692-7 (CS)
MORKES D.: SQL Server 2000 – tvorba, úprava a správa databází. Praha, Grada 2004, 225 s., ISBN 80-247-0732-2 (CS)
LACKO L.: Web a databáze. Praha, Computer Press, 2001, 247 s., ISBN 80-7226-555-5 (CS)

Classification of course in study plans

Type of course unit

 

Guided consultation in combined form of studies

20 hours, optionally

Teacher / Lecturer