hero-image

Teaching database courses at the Department of Computer Science

Database and Information Systems

News

  1. (15.04.) The last repair test will be in Friday 24.4.2015, room: EB213, 1O:15. Students that want to come, please write email to the guarantee of the subject (michal.kratky@vsb.cz), students: imj0009, koz0216

Credit conditions

Student has to pass one test from procedural languages PL/SQL and T-SQL. Minimimal number of points is 12 and maximal 20. 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 will be in 7. week. Each student will get randomly chosen test from PL/SQL or T-SQL. Student can use any type of materials during the test (except the social networks and the communication with other people).

Model

Project

Project should be defended in the last week. Student can implement the chosen project under platform .NET or Java. The maximal number of points is 25, minimal is 13.
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.
  • Implementation has to follow the analysis.
  • 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).
  • 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: 12 points, min. 6 points (1. submission 12 points, 2. submission 9 points, 3. submission 6 points)
  • ORM: 8 points, min. 4 points
  • IS: 5 points, min. 3 points

 

Lectures and Exercises

WeekLectureExercise
1.Introduction to PL/SQL I - PL/SQL block, Procedures and functions, Static and dynamic PL/SQL, Exceptions
pdf (last update: 18/2/2015)
SQL Language --> Tasks and Examples
tasks, solutions (last update: 11/2/2015)

PL/SQL Language -> Tasks and Examples
taskssolutions (last update: 11/2/2015)
2.PL/SQL II - Triggers, Cursors, Bind variables, Access rights of the stored procedures, Packages, Bulk SQL operations in PL/SQL, COMMIT, SQL Injection
pdf (last update: 18/2/2015)
PL/SQL Language -> Tasks and Examples
taskssolutions (last update: 27/2/2015)
3.PL/SQL III
pdf (last update: 25/02/2015)
PL/SQL Language -> Tasks and Examples
Scripts: league_create.sql, league_init.sql, league_drop.sql
tasks, solutions (last update: 25/2/2015)
4.T-SQL
pdf (last update: 04/03/2015)
T-SQL Language -> Tasks and Examples
tasks, solutions
5.Recovery of DBMS
pdf (last update: 18/03/2015)
T-SQL Language -> Tasks and Examples
tasks, solutions (last update: 8/3/2015)
6.Object-Relational Data Model
pdf (last update: 01/04/2015)
Example test
taskssolutions (last update: 18/3/2015)

Scripts for Oracle: create.sql init.sql drop.sql
Scripts for SQL Server: create.sql init.sql drop.sql
7.-Real Time Test
8.Functional Analysis, A sample
pdf (last update: 01/04/2015)
Consultation of the project: Topic, Data Analysis, Draft of Functional Analysis
9. PL/SQL / T-SQL Repair Test,
Consultation: Functional Analysis

Deadline for 1. submission of Complete Analysis: 12.4.2015 
10.Data Accessing API
pdf (last update: 15/04/2015)
ASP.NET, ORM

Deadline for 2. submission of Complete Analysis: 19.4.2015
11.Object Relational Mapping (ORM)
pdf (last update: 22/04/2015)
      ORM,.NET (last update: 22/04/2015)
ORM

Deadline for 3. submission of Complete Analysis: 26.4.2015
12.ASP.NET, ORM Integration
pdf (last update: 28/04/2015)
      AuctionWebApp (last update: 28/04/2015)
ORM

Deadline for submission of ORM: 3.5.2015
13. Submission of complete project