relational data model, candidate key, foreign key, database normalization, data integrity, relational database, SQL query language, architectures of database systems
Abstract:
Basic concepts of database systems, conceptual model, relational data model, the principles of normal forms, relational database design, security and integrity of data, database queries, relational algebra, SQL language, client / server, multilayer architectures, distributed database systems. Access to data via the WWW.
Objectives:
Fundamentals of relational database theory, practical skills in using database technology at a level required for database design and creation of queries to the database. Introduction to database administration, architectures of database systems, trends in database technologies.
Calendars at the Faculty of Transportation Sciences, CTU in Prague