hero-image

Teaching database courses at the Department of Computer Science

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

WeekLectureExercise
1.-SQL
tasks, solution
2.Introduction, recovery, transactions
pdf
PL/SQL
tasks, solution
3.PL/SQL - procedures, functions, condition, cycles
pdf
PL/SQL - triggers, cursors, exceptions, packages
pdf
PL/SQL
tasks, solution
4.PL/SQL - access rights, data types, bulk operations, COMMIT, bind variables, SQL injection
pdf
PL/SQL
tasks, solution
5.Object-relational mapping I
pdf
PL/SQL
tasks, solution
6.--
7.Transactions in host languages
JDBC, ADO.NET
pdf
-
8.Object-relational mapping II
pdf
-
9.ASP.NET
pdf
sample example
-
10.--
11.Query processing, Disk I/O, Data structures
pdf
-
12.XML
pdf
-