460-2056/02 – Database Systems I (DS I)
| Gurantor department | Department of Computer Science | Credits | 4 |
| Subject guarantor | doc. Ing. Radim Bača, Ph.D. | Subject version guarantor | doc. Ing. Radim Bača, Ph.D. |
| Study level | undergraduate or graduate | | |
| | Study language | English |
| Year of introduction | 2019/2020 | Year of cancellation | |
| Intended for the faculties | FEI | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
The primary 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 general knowledge of the basic SQL commands according to the SQL92 standard.
Teaching methods
Lectures
Tutorials
Project work
Summary
This course is a basic introduction to 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:
H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
Recommended literature:
C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
Additional study materials
Way of continuous check of knowledge in the course of semester
- Each student has to pass two tests during the computer exercises. The first test is focused on the SQL language and the second test practice database design, database schema creation and its modification.
- Presentation and defense of a semestral project is based on a design of IS (conceptual model, SQL DDL scripts, SQL Select scripts).
E-learning
Other requirements
There are no additional requirements are placed on a student.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Lectures:
- Introduction to database technologies. Motivation, data independence, and RDBMS architecture. Relational data
model.
- Relational algebra. Basic operations.
- SQL language (with a focus to SQL 92), an introduction of database querying using Select command.
- SQL Select - inner queries
- SQL Select - inner and outer join, aggregation functions and grouping.
- Conceptual Modeling. Entity, entity type, relation, integrity constraints, ER diagram, UML diagram. Transformation
of a conceptual model to a relational data model.
- SQL - data modification language (DML), data definition language (DDL).
- Functional and dynamic analysis.
- Functional dependencies.
- Normal forms and BCNF.
- Comparison of existing RDBMS.
Exercises:
- Relational data model.
- SQL Select statement practices. SQL Server is used to evaluate the language.
- Conceptual modeling using Oracle data modeler.
- Conceptual modeling using Toad data modeler.
- SQL JDD and JMD.
- Functional dependencies.
- Database design, BCNF.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction