155-0379/01 – Administration of Database Systems (SDBS)
Gurantor department | Department of Applied Informatics | Credits | 5 |
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 | 3 | Semester | winter |
| | Study language | Czech |
Year of introduction | 2007/2008 | Year of cancellation | 2013/2014 |
Intended for the faculties | EKF | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Describe and use most commands DDL and DML of SQL language.
Outline such key words like database, table, view, function, stored procedure, trigger, transaction.
Create databases in Microsoft SQL Server a these databases control.
Create database projects in Microsoft Office Access set on Microsoft SQL Server.
Teaching methods
Lectures
Tutorials
Project work
Summary
Subject Administration of database systems continue subject Database applications.
His main aim is to introduce students with administration efficient database
systems like are e.g. Microsoft SQL Server or MySQL and extend further knowledge
of SQL language.
Compulsory literature:
Recommended literature:
... and anything else about MS SQL Server and SQL language.
Way of continuous check of knowledge in the course of semester
E-learning
Other requirements
Credit: project
Exam: oral
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1. Introduction to database technology: basic data processing concepts, historical development and the reasons for the emergence
2. Main features of database technology
3. Database management system, database architecture, life cycle
4. Components of database management system
5. Data models - principles of functional and data analysis
6. Physical data models and methods of physical data organization
7. Relational data model: relations, attributes, schemas, relationships
8. Relational languages: a language for data definition
9. Dependency theory, decomposition of relational schemas
10. Normal forms of relations
11. Conceptual data models, Entity-Relationship modeling
12. Network and hierarchical data model
13. Distributed database systems
14. Data warehousing: concepts, architecture, models, operations, diagrams tables of facts and dimensions, types of DS
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction