Information System of Masaryk University 

Course Information

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2007

Extent and Intensity

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

Teacher(s)

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

Supervisor

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 Wed 12:00–12:50 B311, V. Dohnal
PV003/02 Wed 13:00–13:50 B311, V. Dohnal
PV003/03 Thu 14:00–14:50 B116, V. Dohnal
PV003/04 Thu 15:00–15:50 B116, V. Dohnal
PV003/05 Thu 16:00–16:50 B311, V. Dohnal

Prerequisites (v češtině)

! P003 RDBS Architecture

Course Enrollment Limitations

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

Fields of study the course is directly associated with

there are 18 fields of study the course is directly associated with, display

Course objectives (v češtině)

Výklad je zaměřen na relační DB systémy a dotazovací jazyk 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

• Definice jazyka SQL, firemní dokumentace

Assessment methods (v češtině)

Ucast na cviceni neni povinna. Pro ziskani zapoctu je treba prezentovat jednoduchy projekt a napsat pisemnou zapoctovou zkousku (prikaz select). Pro ziskani zkousky je treba navic uspesne absolvovat pisemku - test z princiou SQL, PL/SQL,PRO*C.

Further Comments

Study Materials
The course is taught annually.

Listed among pre-requisites of other courses

• FF:VIKMB04 Introduction to Structured Query Language
  !1433:PV003 && !1433:PB155 && !1433:PB154 && !1433:PV136 && !1433:P002 && !1433:P502 && !1433:P003 && !1433:P136  

The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014.

---

• Enrollment Statistics (Spring 2007, recent)
  
• Permalink: https://is.muni.cz/course/fi/spring2007/PV003

---