SubjectsSubjects(version: 811)
Course, academic year 2017/2018
  
Database Systems Design - N445052
Czech title: Návrhy databázových systémů
Guaranteed by: Department of Computing and Control Engineering (445)
Actual: from 2015
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 [hours/week]
Capacity: unknown / unknown (unknown)Schedule is not published yet, this information might be misleading.
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
Level:  
For type:  
Note: předmět je možno zapsat mimo plán
povolen pro zápis po webu
Guarantor: Kukal Jaromír doc. Ing. Ph.D.
Annotation -
Last update: Vovsík Jaroslav Ing. Ph.D. (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: Vovsík Jaroslav Ing. Ph.D. (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: Vovsík Jaroslav Ing. Ph.D. (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: Vovsík Jaroslav Ing. Ph.D. (02.07.2013)

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

http://www.sql.org/

Syllabus -
Last update: Vovsík Jaroslav Ing. Ph.D. (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: Vovsík Jaroslav Ing. Ph.D. (03.07.2013)

Applications of Computer Science - N445001

Database Systems - N445003

Class 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
Evaluation of a student
Form Balance
Protokoly z individuálních projektů 50
Ústní zkouška 50

 
VŠCHT Praha