FI:PV003 RDBS Architecture - Course Information

PV003 Relational Database System Architecture

Extent and Intensity

2/1. 3 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).

Teacher(s)

RNDr. Milan Drášil, CSc. (lecturer)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)

Guaranteed by

prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: RNDr. Milan Drášil, CSc.

Timetable

Mon 16:00–17:50 D2

• Timetable of Seminar Groups:

PV003/01: Tue 8:00–8:50 B311, V. Dohnal
PV003/02: Tue 9:00–9:50 B311, V. Dohnal
PV003/03: Wed 9:00–9:50 B311, V. Dohnal
PV003/04: Wed 14:00–14:50 B311, V. Dohnal
PV003/05: Wed 15:00–15:50 B311, V. Dohnal

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

• Applied Informatics (programme FI, B-AP)
• Applied Informatics (programme FI, N-AP)
• Information Technology Security (programme FI, N-IN)
• Bioinformatics (programme FI, B-AP)
• Bioinformatics (programme FI, N-AP)
• Information Systems (programme FI, N-IN)
• Informatics with another discipline (programme FI, B-BI)
• Informatics with another discipline (programme FI, B-FY)
• Informatics with another discipline (programme FI, B-GE)
• Informatics with another discipline (programme FI, B-GK)
• Informatics with another discipline (programme FI, B-CH)
• Informatics with another discipline (programme FI, B-IO)
• Informatics with another discipline (programme FI, B-MA)
• Informatics with another discipline (programme FI, B-SO)
• Informatics with another discipline (programme FI, B-TV)
• Informatics (programme FI, B-IN)
• Informatics (programme FI, M-IN)
• Informatics (programme FI, N-IN)
• Mathematical Informatics (programme FI, B-IN)
• Parallel and Distributed Systems (programme FI, B-IN)
• Parallel and Distributed Systems (programme FI, N-IN)
• Computer Graphics and Image Processing (programme FI, B-IN)
• Computer Graphics (programme FI, N-IN)
• Computer Networks and Communication (programme FI, B-IN)
• Computer Networks and Communication (programme FI, N-IN)
• Computer Systems and Data Processing (programme FI, B-IN)
• Computer Systems (programme FI, N-IN)
• Embedded Systems (eng.) (programme FI, N-IN)
• Programmable Technical Structures (programme FI, B-IN)
• Theoretical Informatics (programme FI, N-IN)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-SS)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-TV)
• Upper Secondary School Teacher Training in Informatics (programme FI, N-SS) (2)
• Artificial Intelligence and Natural Language Processing (programme FI, B-IN)
• Artificial Intelligence and Natural Language Processing (programme FI, N-IN)
• Information Technology (programme FI, B-IN)
• Image Processing (programme FI, N-AP)

Course objectives

Basic course to relational datadase communication language SQL.

Syllabus

• 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C

Literature

• Definition of SQL, technical manuals

Assessment methods

Simple project, practical test (select command ..), final test from SQL language principles.

Language of instruction

Czech

Further Comments

Study Materials
The course is taught annually.

• Enrolment Statistics (Spring 2009, recent)
  
• Permalink: https://is.muni.cz/course/fi/spring2009/PV003