SubjectsSubjects(version: 948)
Course, academic year 2023/2024
  
Database Systems Design - N445052
Title: Návrhy databázových systémů
Guaranteed by: Department of Computing and Control Engineering (445)
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: unknown / unknown (unknown)
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
Level:  
Is provided by: B445011
For type:  
Guarantor: Kukal Jaromír doc. Ing. Ph.D.
Is interchangeable with: B445011
Examination dates   Schedule   
Annotation -
Last update: VOVSIKJ (02.07.2013)
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: VOVSIKJ (03.07.2013)

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: VOVSIKJ (02.07.2013)

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: VOVSIKJ (02.07.2013)

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

http://www.sql.org/

Syllabus -
Last update: VOVSIKJ (03.07.2013)

  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: VOVSIKJ (03.07.2013)

Applications of Computer Science - N445001

Database Systems - N445003

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
Coursework assessment
Form Significance
Report from individual projects 50
Oral examination 50

 
VŠCHT Praha