157-0340/01 – Fundamentals of Database Systems (ZDBSB)
Gurantor department | Department of Systems Engineering | Credits | 5 |
Subject guarantor | prof. Ing. Dušan Marček, CSc. | Subject version guarantor | doc. Ing. Ludmila Kalužová, CSc. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 2 | Semester | summer |
| | Study language | Czech |
Year of introduction | 2008/2009 | Year of cancellation | 2012/2013 |
Intended for the faculties | EKF | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
- To interpret a three level conception of data modelling.
- To design the data structures in the relational database environment.
- To use Oracle database system environment.
- To apply SQL definition, manipulation commands.
- To use SELECT command for data selection, projection, restriction, join operations.
Teaching methods
Lectures
Tutorials
Summary
The objective of the course is to obtain a basic knowledge of the database
design in environment of relational databases. The methodology of a database
design comprises a three level conception, i.e. semantic, conceptual and
logical level. The course also involves using SQL language as definition,
manipulation and query language in the database system.
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
E-learning
Other requirements
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Subject Syllabus
1.Database systems and Features of DBS, the Database architecture.
2.Semantic data modelling, forms of data requirements analysis and their structuring.
3.Conceptual data modelling, ER model – constructs, graphical representation.
4.Conceptual data modelling - generalisation and specialisation.
5.Relational data modelling, basic constructs, definition, entities and relationships modelling.
6.Normalisation of relations - first , second, third normal form, Boyce-Codd normal form.
7.Functions of DBMS, Oracle database10g.
8.SQL – Data Definition Language ,SQL history, table creation, table constraints.
9.SQL – Data Manipulation Language, Inserting data into table, changing data, deleting data.
10.SQL – statement SELECT – From ,Where, Order by, syntax of condition
11.SQL - Select – join operation, inner join, outer join, Cartesian product, natural join.
12.SQL – SELECT- Select – Group by and Having, group functions.
13.SQL – Creating View and Materialized View
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction