| Course Unit Code | 460-2035/03 |
|---|
| Number of ECTS Credits Allocated | 6 ECTS credits |
|---|
| Type of Course Unit * | Optional |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | English |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| BAC027 | doc. Ing. Radim Bača, Ph.D. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
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. |
| Course Contents |
|---|
Lectures:
- Introduction into database technologies. Motivation, data independence and RDBMS architecture. Relational data model.
- Relational algebra. Basic operations.
- SQL language (with focus to SQL 92), 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 diagam. Transformation of an 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 practising using a SQL Server.
- Conceptual modeling using Oracle data modeler.
- Conceptual modeling using Toad data modeler.
- SQL JDD and JMD.
- Functional dependencies.
- Database design, BCNF.
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
* C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
* DBMS Oracle Documenation |
* J. Pokorný, I. Halaška: Databázové systémy. 2. vyd. Praha: Vydavatelství ČVUT, 2003. 148 s. ISBN 80-01-02789-9.
* J. Pokorný: Dotazovací jazyky. Karolinum, 2002. 255 s. ISBN 80-246-0497-3.
* J. Pokorný: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992
* H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
* C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
* Dokumentace k SŘBD Oracle |
| Recommended Reading: |
|---|
| * H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001. |
* M. Krátký, R. Bača: Databázové systémy. http://db.cs.vsb.cz/edu/dbsys.pdf. leden, 2009.
* J. Pokorný: Dotazovací jazyky. Karolinum, 2002. 255 s. ISBN 80-246-0497-3.
* J. Pokorný: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992 |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials, Experimental work in labs |
| Assesment methods and criteria |
|---|
| Tasks are not Defined |