Database and Information Systems
News
- The lecture on March 25 is canceled.
Real time test 1
An example of the first test is here.
Scripts: PL/SQL
T-SQL
- league_create.sql
- league_init.sql
- league_drop.sql
- Real-time test on PL/SQL: 6/10points
- 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: 6/10points
- 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. The maximal number of points is 25, minimal is 12.
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
- J2EE Example: SampleStruts2AppOrm.zip
- ASP.NET Example: AspNetExampleApp.zip
- ASP.NET Example with login and procedures: Project.zip
Lectures and Exercises
| Week | Lecture | Exercise |
| 1. | Introduction to PL/SQL - PL/SQL block, Procedures and functions, Static and dynamic PL/SQL, Exceptions pdf (last update: 11/2/2013) | SQL Language --> Tasks and Examples tasks, solutions (last update: 9/2/2013) |
| 2. | PL/SQL - Triggers, Cursors, Bind variables, Access rights of the stored procedures, Packages, Bulk SQL operations in PL/SQL, COMMIT, SQL Injection pdf (last update: 15/2/2013) | PL/SQL Language --> Tasks and Examples tasks, solutions (last update: 9/2/2013) |
| 3. | Transactions, Recovery pdf (last update: 25/2/2013) | PL/SQL Language --> Tasks and Examples tasks, solutions (last update: 9/2/2013) |
| 4. | Functional analysis of a sample project pdf (last update: 04/03/2013) | PL/SQL Language --> Tasks and Examples tasks, solutions (last update: 23/2/2013) |
| 5. | T-SQL pdf (last update: 11/03/2013) | PL/SQL Test |
| 6. | API to Data Accessing pdf (last update: 18/03/2013) | T-SQL Language --> Tasks and Examples tasks, solutions (last update: 18/3/2013) |
| 7. | - | T-SQL Language --> Tasks and Examples tasks, solutions (last update: 18/3/2013) |
| 8. | - | T-SQL Test |
| 9. | ASP.NET pdf (last update: 08/04/2013) | Consultation: Project description and conceptual model |
| 10. | Object Relational Mapping (ORM) pdf (last update: 15/4/2013) ORM,ASP.NET (last update: 15/04/2013) | Submission: IS description, conceptual and data model (4 points) Consultation: Functional Analysis |
| 11. | ORM - Common Patterns pdf (last update: 22/4/2013) ORM,ASP.NET (last update: 22/04/2013) | Submission: Functional Analysis (4 points) Consultation: ORM and ASP.NET |
| 12. | Physical Database Design, Query processing pdf (last update: 29/04/2013) | Consultation: ORM and ASP.NET |
| 13. | - | Submission: ORM (4 points) |
| 14. | - | Submission of complete project (13 points) |