Course detail

Introduction to Database Technology

FAST-BU03Acad. year: 2011/2012

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.

Language of instruction

Czech

Number of ECTS credits

2

Mode of study

Not applicable.

Guarantor

doc. RNDr. Jiří Macur, CSc.

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Learning outcomes of the course unit

Knowledge for database application design, data analysis and documentation

Prerequisites

Oprating systems, file managing, speadsheets

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

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

Work placements

Not applicable.

Aims

Basics of database technology, modern database techniques, introduction into data analysis

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 optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Jaroslav Pokorný: Dotazovací jazyky. Science, 1994.

Recommended reading

Rebecca Riordan: Vytváříme relační databízové aplikace. Computer Press, 2000.

Classification of course in study plans

  • Programme B-K-C-SI Bachelor's

    branch E , 3 year of study, summer semester, elective

  • Programme B-P-C-SI Bachelor's

    branch E , 3 year of study, summer semester, elective

  • Programme B-P-E-SI Bachelor's

    branch E , 3 year of study, summer semester, elective

Type of course unit

 

Lecture

13 hod., optionally

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.

Exercise

13 hod., compulsory

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.