Double degree

Real time test

• Real-time test on PL/SQL: 11/20points
• Date of test: 2.3.2011
• Duration of test: 1 hour 15 minutes
• Examples of test: test
• Own computers are not allowed
• Allowed literature: Oracle Documentation

Project

Project should be defended in the 7th week. Maximal number of points is 25, minimal is 13:
Requirements:

• enviroment: J2EE or ASP.NET
• RDBMS: Oracle 11g
• Data model: object-relational
• Analysis and design: conceptual model (ER diagram). Typical SQL commands and indexes.
• IS will have minimaly 7 tables and 5 non-trivial stored functions or procedures.
• IS will contain non-trivial forms: foreing keys will be selected from combo-boxes and so on.
• ORM will support transactions. Lazy evaluation, actualization only values changed.
• Forms for actualization and inserting will be separated from the display forms.
• Example of project: project
• Example of analysis: analysis + description of stored procedures and triggers

Information Systems Development

Project - 1st part

First part of project should be defended in the 9th week. Maximal number of points is 20, minimal is 10.
It has to contain generator of collections and measurement of efficiency of the imports.

Project - 2st part

First part of project should be defended in the 11th week. Maximal number of points is 25, minimal is 13.
Project has to contain:

• Data model: object-relational
• First part of project with description of collection and measurment of efficiency of the imports
• List of 15 queries (at least 5 complex queries) and 5 updates/inserts
• Usage of at least two kinds of indexes (f.e. B-tree, Composite B-tree, Bitmap,...)
• Usage of at least one kind of table except traditional heap table (f.e. IOT, Hash Table,...)
• Measurment of time, I/O Cost, Consistent gets and Physical reads before and after application of indexes/tables

Lectures and Exercises