Course details

Database Systems

IDS Acad. year 2004/2005 Summer semester 5 credits

Current academic year

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 advanced development and database environments.

Guarantor

Zendulka Jaroslav, doc. Ing., CSc.

Language of instruction

Czech, English

Completion

Examination

Time span

  • 39 hrs lectures
  • 5 hrs exercises
  • 8 hrs projects

Department

Department of Information Systems (UIFS)

Subject specific learning outcomes and competences

Student is able to develop conceptual models of an application domain for database applications. He/she can develop database applications for relational databases, knows the standard database language for relational databases SQL, and has experience with some integrated development environment for database applications.  and have knowledge of relational database management system fundamentals. He/she receives basic competencies for database administrator's work like user account creation, access rights assignment and performance tuning. Student acquaints with fundamentals of some important functions of advanced database system like transactional processing, concurrency and recovery. Student acquaints with basic English terminology in the subject.

Student will learn how to analyze a given problem in a small team and he/she will learn to design and implement solution of the problem individually. He/she learns to present and defend  both partial and final results of the project.

Learning objectives

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

Recommended prerequisites

Prerequisite knowledge and skills

The sets, relations and mappings. The elementary notions of the graph theory. Basics of hashing and tree-based search. Basic steps of software development. Rudiments of programming and data modeling.

Fundamental literature

  • Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Sixth Edition. McGraw-Hill. 2010, 1320 p.

Syllabus of lectures

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

Syllabus of numerical exercises

  1. Demonstration of a database application development in both environments used for projects in a laboratory (Oracle and Gupta currently).
  2. Creating an Oracle and a SQLBase database.
  3. Screen form development in Oracle Developer and SQL Windows.
  4. Report development in Oracle Developer and SQL Windows.
  5. Stored procedures and database triggers in Oracle and SQLBase.

Progress assessment

Study evaluation is based on marks obtained for specified items. Minimimum number of marks to pass is 50.

To be allowed to sit for written examination student is to write the mid-term written exam, to present and defend both projects in due dates, and to earn at least 25 points during semester.

Controlled instruction

Mid-term exam passing, realization and presentation/defence of projects in due dates.

Back to top