|
Lecturer(s)
|
-
Borkovcová Monika, Ing. Ph.D.
-
Rejsek Ondřej, Ing.
-
Zechmeister Jiří, Ing.
-
Andrle Lubomír, Ing.
-
Budáč David
-
Greiner Karel, doc. Ing. Ph.D.
|
|
Course content
|
Overview of database models (hierarchical, network, relational, object-oriented). Transactions, parallel processing. Transactions protocols. Journals, Error processing. Relational algebra. Relational calculus. Dependency analysis. Armstrong axioms. Oracle Reporter. Oracle Forms. JDeveloper. Database administration, remote access configuration, data backup.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Methods of individual activities, Projection, Skills training
|
|
Learning outcomes
|
The main goal of the course is to familiarize students with the architectures and techniques of database systems and to broaden knowledge of database design, development and administration on Oracle platform.
The overviews in Oracle database system architecture, processes and redo technologies. The ability to apply basic security rules, transactional mechanismus, work with execution plan.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Oral examination, Home assignment evaluation
Given assignment confirms that a student has attended lessons to the extent required and fulfilled qualified requirements (hand over the functional solutions of lessons assignments and seminar work consisting of complex database design). 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 practice test and a theoretical exam. Student passes successfully the practice test as well as the theoretical part of the exam if he/she obtains at minimum 50% of possible points in each part.
|
|
Recommended literature
|
-
Johnson, James Lee. Database : models, languages, design. New York: Oxford University Press, 1997. ISBN 0-19-510783-7.
-
Johnson, James Lee. Database : models, languages, design. New York: Oxford University Press, 1997. ISBN 0-19-510783-7.
-
Lacko, Luboslav. Oracle : správa, programování a použití databázového systému. Brno: Computer Press, 2002. ISBN 80-7226-699-3.
-
Loney, K., Bryla, B. Oracle Database 10g DBA Handbook. McGraw-Hill Osborne Media, 2005. ISBN 0072231459.
-
Loney, Kevin. Mistrovství v Oracle. Praha: Computer Press, 2002. ISBN 80-7226-635-7.
|