Database and Information Systems

Real time test

• Real-time test on PL/SQL: 11/20points
• Semestral project: 13/25points - an implementation of an information system in J2EE or ASP .NET. The main task is the implementation of the efficient data layer.

Project

Project should be defended on the last exercise. 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), functional analysis (DFD). 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, usage of bulk-operations, isolation levels.
• Forms for actualization and inserting will be separated from the display forms.

Lectures and Exercises