Course: Database Systems II

» List of faculties » DFJ » KID
Course title Database Systems II
Course code KID/PXD2K
Organizational form of instruction Lecture
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 4
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Rulićová Iva, RNDr.
  • Rejsek Ondřej, Ing.
Course content
Relational database. Database server. Table. SQL language. Models DDL, DML. Basic commands. Basic data types, operators, SQL functions. SELECT command. Projection. Restriction. Inner join, Outer join. Group aggregation. Sorting query. Nested query. View. Sequence, Transaction. SQL*Plus Language. PL/SQL procedural language. DBMS_OUTPUT unit. Cursors, procedures, functions, triggers. Primary key, index. ER-diagrams, UML diagrams. Normal form. Time reserve.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Demonstration, Projection, Skills training
Learning outcomes
The main objective is to familiarize students with SQL databases. After the course, students should be able to work with certain database software (Oracle).
The student controls the majority of the database functionality of Oracle upon the completion of the course. They can define and solve their own routine work in Oracle. The student also can use the language SQL and PL/SQL.
Prerequisites
Passing the course Database Systems I and knowledge of structured programming.
KID/PXD1K
----- or -----
KID/PXD1P

Assessment methods and criteria
Written examination, Home assignment evaluation, Creative work analysis, Discussion

Given assignment confirms that a student has attended lessons to the extent required and fulfilled qualified requirements. Conditions for credit are: active work at exercises, min. 75% presence, 2 examinations on computer, student passes if he/she obtains 50 points of 100 possible. Form, contents and length of the exam are determined in accordance with Study and Examining Rules of University of Pardubice. The exam consists of two parts, a written test and a theoretical exam. Student passes successfully the computer test as well as the theoretical part of exam if he/she obtains at minimum 50% of possible points in each part.
Recommended literature
  • Lacko, Luboslav. Oracle : správa, programování a použití databázového systému. Brno: Computer Press, 2002. ISBN 80-7226-699-3.
  • Lacko, Luboslav. Oracle : správa, programování a použití databázového systému. Brno: Computer Press, 2007. ISBN 978-80-251-1490-2.
  • Loney, K., Bryla, B. Oracle Database 10g DBA Handbook. McGraw-Hill Osborne Media, 2005. ISBN 0072231459.
  • Oppel, A. Databases Demystified. McGraw-Hill Osborne Media, 2004. ISBN 10- 00722-5364-1.
  • Oppel, Andrew J. Databáze bez předchozích znalostí : [průvodce pro samouky]. Brno: Computer Press, 2006. ISBN 80-251-1199-7.
  • Šimůnek, Milan. SQL : kompletní kapesní průvodce. Praha: Grada, 1999. ISBN 80-7169-692-7.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Transport Engineering Study plan (Version): Applied Informatics in Transport (2016) Category: Informatics courses 3 Recommended year of study:3, Recommended semester: Winter
Faculty: Faculty of Transport Engineering Study plan (Version): Applied Informatics in Transport (2014) Category: Informatics courses 3 Recommended year of study:3, Recommended semester: Winter
Faculty: Faculty of Transport Engineering Study plan (Version): Applied Informatics in Transport (2013) Category: Informatics courses 3 Recommended year of study:3, Recommended semester: Winter