SubjectsSubjects(version: 948)
Course, academic year 2021/2022
  
Database Systems Design - B445011
Title: Návrhy databázových systémů
Guaranteed by: Department of Mathematics, Informatics and Cybernetics (446)
Faculty: Faculty of Chemical Engineering
Actual: from 2021
Semester: summer
Points: summer s.:5
E-Credits: summer s.:5
Examination process: summer s.:
Hours per week, examination: summer s.:1/3, C+Ex [HT]
Capacity: unlimited / unlimited (unknown)
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
Level:  
For type:  
Note: course can be enrolled in outside the study plan
enabled for web enrollment
Guarantor: Kukal Jaromír doc. Ing. Ph.D.
Interchangeability : N445052
Annotation -
Last update: Fialová Jana (15.01.2018)
The course focuses on the theory of relational database management systems, conceptual modelling and relational database schema normalization and gaining practical skills at a level required for database schema design including integrity constraints, for implementation of the design in a transactional relational database engine and for working with the database engine using the SQL query language and its procedural extension.
Aim of the course -
Last update: Fialová Jana (15.01.2018)

Students will be able to:

  • design database schemas based on relational data model and normal forms of tables,
  • create and manage database schemas using the SQL language in a modern client-server relational database system,
  • check the integrity of stored data using standard database means (keys, transactions),
  • work with the data using features of the procedural extension of the SQL language (stored procedures and functions, triggers).

Literature -
Last update: Fialová Jana (15.01.2018)

R:Ponniah P.,Database design and development: an essential guide for IT professionals,Wiley-Interscience,Hoboken,NJ,2003,0471218774

A:Ramakrishnan R. and Gehrke J.,Database management systems,McGraw-Hill,Boston,MA,2003,0072465638

A:Rob P. and Coronel C.,Database systems: design, implementation, and management,Thomson/Course Technology,Boston,MA,2007,1418836508

A:Chao L.,Database development and management,Auerbach Publ.,Boca Raton,FL,2006,0849333180

Learning resources -
Last update: Fialová Jana (15.01.2018)

http://dx.doi.org/10.1002/0471728993

http://www.sql.org/

Syllabus -
Last update: Fialová Jana (15.01.2018)

  1. Basic principles of DBS, DBMS architecture, functions of components.
  2. Conceptual, logical and physical level of view on data.
  3. Network, relational, object-relational and object oriented database models.
  4. Relational data model, entities, relationships, attributes, domains, schemas of relational databases.
  5. Normal forms of relations.
  6. Normalization of relational database model.
  7. Environment of modern client-server relational database system.
  8. Data types, schema creation, data definition using SQL statements.
  9. Data operations using SQL statements, views.
  10. Basic features and syntax of procedural extension of SQL language.
  11. Commands of procedural extension of SQL language and declaration of variables within the database system.
  12. Stored procedures and functions, triggers and sequences creation.
  13. Working with cursors in procedural extension of SQL language.
  14. Commands for definition and control of transactions.

Registration requirements -
Last update: Fialová Jana (15.01.2018)

Applications of Computer Science - N445001

Database Systems - N445003

Course completion requirements - Czech
Last update: Mareš Jan doc. Ing. Ph.D. (14.02.2018)

zápočet - odevzdání protokolů ze samostatných úkolů

zkouška - ústní

Teaching methods
Activity Credits Hours
Obhajoba individuálního projektu 0.5 14
Účast na přednáškách 0.5 14
Práce na individuálním projektu 1 28
Příprava na zkoušku a její absolvování 1.5 42
Účast na seminářích 1.5 42
5 / 5 140 / 140
 
VŠCHT Praha