Course Unit Code | 460-4125/01 |
---|
Number of ECTS Credits Allocated | 5 ECTS credits |
---|
Type of Course Unit * | Compulsory |
---|
Level of Course Unit * | Second Cycle |
---|
Year of Study * | First Year |
---|
Semester when the Course Unit is delivered | Winter Semester |
---|
Mode of Delivery | Face-to-face |
---|
Language of Instruction | Czech |
---|
Prerequisites and Co-Requisites | There are no prerequisites or co-requisites for this course unit |
---|
Name of Lecturer(s) | Personal ID | Name |
---|
| BAC027 | doc. Ing. Radim Bača, Ph.D. |
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. |
Learning Outcomes of the Course Unit |
---|
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. |
Course Contents |
---|
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 modelling using Oracle data modeler.
- Conceptual modelling using Toad data modeler.
- SQL JDD and JMD.
- Functional dependencies.
- Database design, BCNF. |
Recommended or Required Reading |
---|
Required Reading: |
---|
H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001. |
1. Jeffrey Ullman, Jennifer Widom, Héctor García-Molina: Database Systems: The Complete Book. Pearson; 2 edition (January 11, 2011), ISBN 978-0131873254.
2. J. Pokorný, I. Halaška: Databázové systémy. 2. vyd. Praha: Vydavatelství ČVUT, 2003. 148 s. ISBN 80-01-02789-9.
3. J. Pokorný: Dotazovací jazyky. Karolinum, 2002. 255 s. ISBN 80-246-0497-3.
4. J. Pokorný: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992 |
Recommended Reading: |
---|
C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003. |
M. Krátký, R. Bača: Databázové systémy. http://db.cs.vsb.cz/edu/dbsys.pdf. |
Planned learning activities and teaching methods |
---|
Lectures, Tutorials, Project work |
Assesment methods and criteria |
---|
Task Title | Task Type | Maximum Number of Points (Act. for Subtasks) | Minimum Number of Points for Task Passing |
---|
Graded credit | Graded credit | 100 (100) | 51 |
SQL SELECT | Written test | 40 | 20 |
SQL and Database Design | Written test | 20 | 10 |
Task Specification and Database Design | Project | 30 | 15 |
Final Test | Written test | 10 | 5 |