Course detail

Databases I

FAST-GE51Acad. year: 2018/2019

Basic concepts of database technology, ANSI/SPARC levels, data models, architecture of database systems (DBS).
Coceptual modelling, E/R diagrams,languges of relation DBS, SQL language.
Relational data model, theory of dependence.
Interior data organization, indexing, hashing.
Security and integrity of data, trigery.
Distributed DBS, architecture client- server, current trends of database technology development, postrelation systems.
Databases in GIS. Database systems Mircosoft Access, Oracle SQL plus.

Language of instruction

Czech

Number of ECTS credits

2

Mode of study

Not applicable.

Department

Institute of Geodesy (GED)

Learning outcomes of the course unit

design of a data model, creating tables, design relations, 1:1, 1: N, M: N, creating SQL queries, forms and reports design a simple database in MS Access,

Prerequisites

Handling with personal computers

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching methods depend on the teaching methods are described in Article 7 of the Study and Examination Regulations of the University. Teaching theories hold presentations and direct instruction. Practical skills students will acquire the solution of several subtasks and 2 projects. The course will be based on the LMS Moodle.

Assesment methods and criteria linked to learning outcomes

Attendance, submission of laboratory reports, activity in the exercises, written tests, submission of final project

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

Theory of relation database systems. Creation tables of relations, queries. Basic 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 optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Date, C.F.: An Introduction to Database System. Addison-Wesley, 1995. (EN)
Korth H.,F. Silberschatz A.: Database System Concepts. Mc Graw-Hill, 1996. (EN)
Pokorný J.: Databázová abeceda. Science Valetiny, 1998. (CS)

Recommended reading

Not applicable.

Classification of course in study plans

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

    branch G , 2. year of study, summer semester, compulsory-optional

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

    branch G , 2. year of study, summer semester, compulsory-optional

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

    branch GI , 2. year of study, summer semester, compulsory

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

    branch GI , 2. year of study, summer semester, compulsory

Type of course unit

 

Exercise

26 hours, compulsory

Teacher / Lecturer

Syllabus

• fundamental terms of database technology
• E/R diagrams, relational database languages, SQL.
• relational data model, theory of dependence, normal forms.
• Internal data organization, indexing, hashing.
• Security and data integrity, triggers, transactions
• Database in GIS
• Database systems Mircosoft Access, Oracle, SQL plus