Database Systems II

Credit conditions

Student has to pass one test from procedural languages PL/SQL. Minimimal number of points is 8 and maximal 15. At most two attempts of the test will be possible. Another part of the credit is a home project which is focused on a analysis and implementation of an information system under platform .NET or Java.

Real-time test

Real time test from PL/SQL will be in 6th week. Student can use any type of materials during the test (except the social networks and the communication with other people).

• Description of the test relation data model  (last update 8.3.2022)
• SQL script for the test (last update 15.10.2021)
• Test, Solution of the test
• The repair test from PL/SQL language will be on 12.4., 12:30, EB113. 

Project

Project should be defended in the last week. Student can implement the chosen project under platform .NET or Java.              
Requirements:

• IS will have at least 7 tables and 5 non-trivial methods. At least 3 methods will be implemented as stored procedures.
• At lest 3 of the implemented non-trivial methods will be as transactions. Non-trivial method is not CRUD command.
• Cascade delete is not allowed as a non-trivial method.
• The implementation has to follow the analysis.
• The architecture has to contain layers. Data layer has to contain own Object-Relation Mapping (ORM)
• Student can implement in ASP.NET or J2EE (in the case of web application) or .NET or Java (in the case of desktop application).
• ORM will support also lazy evaluation and update only changed attributes.
• ORM will support transaction (at least level of isolation SERIALIZABLE).
• A part of ORM will be a test method utilizing all methods of ORM.
• IS will support basic validation of input values.
• Only two forms of the IS have to be implemented. The forms will be chosen by a teacher according to the analysis. The forms have support basic validation of input values.
• The complete project has to contain documentation with analysis, SQL scripts and implementation.
• Example analysis of the project here
• Example ASP.NET project here

Evalution of the project:

• Analysis: 15 points, min. 7 points (1. submission 15 points, 2. submission 15 points, 3. submission 11 points, 4. submission 7 points)
• ORM: 8 points, min. 5 points (1. submission 8 points, 2. submission 5 points)
• IS: 7 points, min. 4 points (1. submission 7 points, 2. submission 4 points)

Deadlines of the project:

• Analysis:
  • 1. submission 6.3.2022 23:59 (4.week)
  • 2. submission 20.3.2022 23:59 (6.week)
  • 3. submission 3.4.2022 23:59 (8.week)
  • 4. submission 10.4.2022 23:59 (9.week)
• ORM:
  • 1. submission 17.4.2022 23:59 (10.week)
  • 2. submission 1.5.2022 23:59 (12.week)
• IS:
  • 1. submission 8.5.2022 23:59 (13.week)
  • 2. submission 15.5.2022 23:59 (14.week)

Lectures and Exercises