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