Objective of the course – aims of the course unit:|
Basics of database technology, modern database techniques, introduction into data analysis
Objective of the course – learning outcomes and competences:|
Knowledge for database application design, data analysis and documentation
Oprating systems, file managing, speadsheets
Course contents (annotation):|
Basic concepts of databases technology, data modeling, database tools.
Relational database and algebra, integrity limitations.
Conceptual modeling, E-R diagrams.
Relational languages, Strucured Query Language.
Database system architecture.
ISAM adatabase architecture (MS Access) and database server SQL (MS SQL2000).
Training of data modeling analytical skills using environment of database application.
Teaching methods and criteria:|
Assesment methods and criteria linked to learning outcomes:|
Requirements for successful completion of the subject are specified by guarantor’s regulation updated for every academic year.
Data models and their interpretations in databases
Relational data model
Techniques of foreign keys, E-R diagrams
Views and indices
Reference and data integrity
Basics of SQL language
Specification of controlled education, way of implementation and compensation for absences:|
Extent and forms are specified by guarantor’s regulation updated for every academic year.
Jaroslav Pokorný: Dotazovací jazyky. Science 1994
Rebecca Riordan: Vytváříme relační databízové aplikace. Computer Press 2000