Pravděpodobně máte vypnutý JavaScript. Některé funkce portálu nebudou funkční.

Course detail

Introduction to Database Technology

Subjet code :	FAST-BU03
Faculty:	Faculty of Civil Engineering
Academic year:	2011/2012
Open:	Yes
Supervisor:	doc. RNDr. Jiří Macur, CSc.
Department:	Institute of Computer Aided Engineering and Computer Science

Study level:	Bachelor's
Study form:	full-time study
Language of instruction:	Czech
Number of credits:	2
Completion:	graded course-unit credit
Year of study:	3
Semester:	summer
Duty:	optional

The study programmes with the given course

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
Prerequisites: 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: n. a.
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.
Course curriculum: Data models and their interpretations in databases Relational data model Relational algebra Conceptual modelling 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.
Recommended reading: Jaroslav Pokorný: Dotazovací jazyky. Science 1994 Rebecca Riordan: Vytváříme relační databízové aplikace. Computer Press 2000

Type of course unit:

Lecture:	13 hours, optionally
Teacher:	doc. RNDr. Jiří Macur, CSc.
seminars:	13 hours, compulsory
Teacher:	doc. RNDr. Jiří Macur, CSc.