Database and Information Systems
Real time test 1
Example of first test is here.
Solutions of first test is here.
- Real-time test on PL/SQL: 7/15points
- Duration of test: 1 hour 15 minutes
- Own computers are not allowed
- Allowed literature: Oracle Documentation
Real time test 2
- Real-time test on T-SQL: 7/15points
- login/password: student login/tuo460DbEd
- Duration of test: 1 hour 15 minutes
- Own computers are not allowed
- Allowed literature: Microsoft Documentation
Project
Project should be defended in the last week of september. Maximal number of points is 15, minimal is 7:
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
- J2EE Example: SampleStruts2AppOrm.zip
- ASP.NET Example: AspNetExampleApp.zip
Lectures and Exercises
| Week | Lecture | Exercise |
| 1. | - | SQL Language --> Tasks and Examples tasks, solutions (last update: 13.2.2012) |
| 2. | Introduction to PL/SQL - PL/SQL block, Procedures and functions, Static and dynamic PL/SQL, Exceptions pdf (last change: 13.2.2012) | PL/SQL Language --> Tasks and Examples tasks, solutions (last update: 20.2.2012) |
| 3. | PL/SQL - Triggers, Cursors, Bind variables, Access rights of the stored procedures, Packages, Bulk SQL operations in PL/SQL, COMMIT, SQL Injection pdf (last change: 19.2.2012) | PL/SQL Language --> Tasks and Examples tasks, solutions (last update: 26.2.2012) |
| 4. | - | PL/SQL Language --> Tasks and Examples tasks, solutions (last update: 26.2.2012) |
| 5. | Transaction and recovery in database system pdf (last change: 12.3.2012) | PL/SQL Test |
| 6. | T-SQL pdf (last change: 12.3.2012) | T-SQL Language --> Tasks and Examples tasks, solutions (last update: 18.3.2012) |
| 7. | Host programing languages, JDBC, ADO.NET, transactions pdf (last change: 26.3.2012) | T-SQL Language --> Tasks and Examples tasks, solutions (last update: 26.3.2012) |
| 8. | J2EE pdf (last change: 26.3.2012) | T-SQL --> Consultation, Problematic Tasks |
| 9. | ASP.NET pdf (last change: 2.4.2012) | T-SQL Test |
| 10. | Query processing pdf (last change: 16.4.2012) | Consultation: Project description and conceptual model |
| 11. | Physical database design pdf (last change: 14.5.2012) | Submission: IS description, conceptual and data model (5 points) |
| 12. | Concurrency control pdf (last change: 14.5.2012) | Submission: functional analysis (5 points) |
| 13. | - | Submission: ORM (5 points) |
| 14. | - | Submission of complete project (10 points) |
| 15. | - | - |
PL/SQL Documentation