714-0393/03 – Database Systems (DBS)
Gurantor department | Department of Mathematics and Descriptive Geometry | Credits | 2 |
Subject guarantor | Mgr. Petr Otipka, Ph.D. | Subject version guarantor | Mgr. Petr Otipka, Ph.D. |
Study level | undergraduate or graduate | Requirement | Optional |
Year | 3 | Semester | summer |
| | Study language | English |
Year of introduction | 2015/2016 | Year of cancellation | 2017/2018 |
Intended for the faculties | FS | Intended for study types | Bachelor, Master, Follow-up Master |
Subject aims expressed by acquired skills and competences
Introduction to basics of professional computer data storing and
processing to database systems.
Teaching methods
Lectures
Individual consultations
Tutorials
Other activities
Summary
The subject introduces to basics of professional computer data storing and
processing, to database systems. Although two most available models are
described, the relational database model is preferred. The different data types
are demonstrated regarding to theirs memory forms, ranges, access methods, and
operations.
Compulsory literature:
Microsoft Access: Users Guide. Microsoft Corporation, Redmond(Wa,USA), 1999.
Recommended literature:
Miller, H. J. - Han, J.: Geographic Data Mining and Knowledge Discovery. ISBN 203468023. Taylor & Francis, London, 2001.
Ponniah, P.: Database Design and Development. John Wiley & Sons, London, 2003.
Way of continuous check of knowledge in the course of semester
Course-credit
- participation on tutorials is obligatory, 20% of absence can be apologized,
- elaborate programs (max. 40 points, min. 20 points),
- pass the written tests (max. 60 points, min. 31 points),
Point classification:
51-65 points,
66-85 points,
86-100 points.
E-learning
Other requirements
PC skills in a range of previous studies.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Lectures
1. Fundamental concept definition.
2. Data levels organisation.
3. Data structure.
4. Data storage.
5. Forms of data organisation.
6. Data organisation in database management systems.
7. The basis of sets theory. Mathematical principle of relational databases.
8. Operations over the relations.
9. The basis of the relational database systems.
10.Structured query language (SQL) and the elementary commands.
Practices
1. The data storage methods. The file types and relationships among them.
2. The system task modes: dialogs and programs.
3. The databases file structure definition and its change.
4. The data insertion into database files, the data changes.
5. Expressions and commands.
6. Fundamental input commands.
7. Multiple data manipulation commands.
8. Interactive form creation, the usage of it.
9. Interactive report creation, the usage of it.
10.The sample of programming.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.