Database and Information Systems

News

• Exam, June 11, 2020: exam.pdf
• 7.5.2020 - The solution of the test is presented here. The repair of the test will be on 13.5.2020 at 13:00.
• 16.5.2020 - The solution of the repair test is presented here. The last repair of the test will be on 20.5.2020 at 13:00.

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: pdf (last change: 3.4.2020)
• script (last change: 3.4.2020)

Models for the real-time test from last years:

• Data model:
  • data model.
  • script
  • Example and solution: here
• Data model: pdf (last change: 16.3.2018), scripts:
  • Oracle: script (last change: 21.3.2018)
  • SQL Server: script (last change: 21.3.2018)
• Data model: pdf (last change: 21.3.2017), scripts:
  • Oracle: script (last change: 21.3.2017)
  • SQL Server: script (last change: 21.3.2017)

The real time tests with the solutions are presented here, here, and  here.

Project deadlines

• Analysis (6-10 points):
  • 1. attempt: 31.03.2020, 23:59 (10 points for correct analysis)
  • 2. attempt: 07.04.2020, 23:59 (10 points for correct analysis)
  • 3. attempt: 14.04.2020, 23:59 (8 points for correct analysis)
  • 4. attempt: 21.04.2020, 23:59 (6 points for correct analysis)

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: 10 points, min. 6 points (1. submission 10 points, 2. submission 8 points, 3. submission 6 points)
• ORM: 10 points, min. 5 points
• IS: 10 points, min. 5 points

Lectures and Exercises