460-2035/01 – Introduction to Database Systems (UDBS)
| Gurantor department | Department of Computer Science | Credits | 6 |
| Subject guarantor | doc. Ing. Radim Bača, Ph.D. | Subject version guarantor | Ing. Radoslav Fasuga, Ph.D. |
| Study level | undergraduate or graduate | | |
| | Study language | Czech |
| Year of introduction | 2011/2012 | Year of cancellation | 2014/2015 |
| Intended for the faculties | FEI | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Main goal is to introduce the basic database concepts such as the relational model and the SQL language. The students
who finish this course will be able to specify the conceptual model and the relational scheme of an information
system and they will have a deep knowledge about the basic SQL commands according to the SQL92 standard.
Teaching methods
Lectures
Tutorials
Experimental work in labs
Summary
This course is a basic introduction into database technologies. The main topics are the conceptual modeling, the
relational data model and the SQL language for data definition, manipulation and querying.
Compulsory literature:
* C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
* DBMS Oracle Documenation
Recommended literature:
* H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
Additional study materials
Way of continuous check of knowledge in the course of semester
- Student have to pass two tests during the computer exercises. The first test is focused on the SQL language and
the second practise database design.
- Presentation and defense of an semestral project is based on a design of IS (conceptual model, data model, SQL
scripts)
E-learning
Other requirements
Additional requirements are placed on the student.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Lectures:
- Introduction into database technologies.
- Conceptual modeling. Entity, entity type, relation, integrity constraints, ER diagram, UML diagam
- Relational data model. Relation, relational scheme, relational database.
- Relational algebra. Basic operations.
- SQL language (with focus to SQL 92)
- SQL - DDL, DML, data types.
- SQL - příkaz SELECT.
- SQL - join operation, efficiency of a query processing.
- Transformation of an conceptual model to a relational data model.
- Functional dependencies.
- Normal forms and BCNF.
- Functional and dynamic analysis.
Exercises:
- Introduction into a ER modeling tool.
- Creation of ER models using the ER modeling tool.
- Introduction into a DBMS interfaces.
- SQL - DDL.
- SQL - DML.
- SQL - SELECT command.
- SQL processing efficiency
- Transformation of an conceptual model to a relational data model.
- Database design, BCNF.
- Functional and dynamic analysis.
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