Course detail

Database Systems

FEKT-KDATAcad. year: 2009/2010

Fundamentals of database systems (DBS). Relational database design from a conceptual model. The relational model. SQL language. Normalization-based design of a relational database. Organization of data at an internal level. Transaction processing. Introduction to database administration: data security and integrity, database recovery, performance optimization. DBS architectures: client/server, multi-tier architectures, distributed DBS. Trends in database technologies.
Development of a database application in modern development and database environment.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

doc. Ing. Jaroslav Zendulka, CSc.

Department

Faculty of Information Technology (FIT)

Learning outcomes of the course unit

Students are able to develop conceptual models of an application domain for database applications and have knowledge of relational database management system fundamentals.

Prerequisites

The subject knowledge on the secondary school level is required.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

Assesment methods and criteria linked to learning outcomes

Requirements for completion of a course are specified by a regulation issued by the lecturer responsible for the course and updated for every.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

Mastering fundamentals of relational database theory and acquiring skills in using database technology at a level required for database design, development of database applications and database administration.

Specification of controlled education, way of implementation and compensation for absences

The content and forms of instruction in the evaluated course are specified by a regulation issued by the lecturer responsible for the course and updated for every academic year.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Korth H.F, Silberschatz, A.: Database System Concepts. Third Edition. McGRAW-HILL. 1996, 821 p.
On-line nápověda a dokumentace prostředí Oracle a Centura.

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme EEKR-BK Bachelor's

    branch BK-TLI , 3. year of study, summer semester, optional specialized

Type of course unit

 

Lecture

39 hours, optionally

Teacher / Lecturer

doc. Ing. Jaroslav Zendulka, CSc.

Syllabus

Fundamental concepts of database systems.
Transformation of a conceptual model to a relational database schema.
Fundamentals of the relational model.
SQL language - data definition, SELECT statement (fundamentals).
SQL language - SELECT statement (extension), other statements for data manipulation. System catalogue.
SQL language - embedded SQL, cursor, dynamic SQL. Query by example (QBE).
Introduction to programming in systems used for projects in a laboratory (currently Oracle and Centura).
Fundamentals of schema normalization.
Data organization at the internal level - indexing and hashing.
Client/server and multi-tier architectures, load balancing - stored procedures, database triggers.
Transaction processing - failure recovery, concurrency control.
Introduction to database administration - data security, performance tuning (query optimization).
Distributed systems, trends in database technology.

Fundamentals seminar

5 hours, optionally

Teacher / Lecturer

doc. Ing. Jaroslav Zendulka, CSc.

Syllabus

Demonstration of a database application development in both environments used for projects in a laboratory (Oracle and Centura currently).
Creating an Oracle and SQL Base database.
Screen form development in Oracle Developer a SQL Windows.
Report development in Oracle Developer a SQL Windows
Stored procedures and database triggers in Oracle and SQL Base.

The other activities

8 hours, optionally

Teacher / Lecturer

doc. Ing. Jaroslav Zendulka, CSc.

Syllabus

Presentation of a conceptual model (ERD or a class diagram) and a functional requirements model (DFD or Use Case) for a given problem.
Realization of the database application in one of the two development and databaze environments.