Database Systems

General Course Info

Professor: Dr Miroslav Bojović (office 23)
Assistant: Mr Miloš Cvetanović (office 36)

Class Excercises:

  • IR3BP1, Mondays 14-16h, room 312;
  • SI2BP1, Wednesdays 14-16h, room 309;
  • SI2BP1, Thursdays 16-18h, room 61;

Welcome to the Database Systems Course online. This site contains lots of useful information for your successful completion of this course. Please visit it often as we are trying to keep it up to date.

Assistant will answer only questions submitted through email cmilos@etf.rs or asked during classes and lab exercises.


Get The Latest!

11.04.2008. Relational DB Book
12.02.2007. Homework Results 2007
27.12.2006. Homework 2006
12.10.2005. SQL Syntax Part 1, Part 2
04.01.2005. Homework 2004
04.01.2005. Sample exams
28.11.2004. Announcement

Project Recommendations

For years students have expressed interests in completing real-life projects as part of their coursework. In order to help you in selecting a topic we have assembled a list of previous projects.

Oracle SQL Developer is Free

Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements.

OTN LogoAlso learn how to Build Database-driven Applications with JSF


Course Statistics

Percentage of passing scores per exam during academic year 2005

Graph shows percentage of students who passed the exam at exam terms during the academic year 2005.

Exam Results

16.02.2010. Results
24.01.2010. Results (Solutions)
05.12.2009. Results (Solutions)
23.09.2009. Results
03.09.2009. Results
16.06.2009. Results (Solutions)
17.02.2009. Results (Solutions)
29.01.2009. Results (Solutions)
29.11.2008. Results (Solutions)
24.09.2008. Results
04.09.2008. Results
10.07.2008. Results
02.07.2008. Results
11.05.2008. Results
29.02.2008. Results (Solutions)
07.02.2008. Results (Solutions)
30.01.2008. Results
02.12.2007. Results
02.12.2007. Results (Solutions)
28.09.2007. Results
06.09.2007. Results (Solutions)
05.07.2007. Results
13.05.2007. Results
05.03.2007. Results (Solutions)
08.02.2007. Results (Solutions)
20.01.2007. Results (Solutions)
17.12.2006. Results
28.09.2006. Results
31.08.2006. Results
10.07.2006. Results
29.06.2006. Results
18.04.2006. Results
26.03.2006. Results
09.02.2006. Results

Lecture Notes

Part 1: Introduction
Part 2: E-R Model
Part 3: Relational Model
Part 4: Query Languages 1
Part 5: Query Languages 2
Part 6: Database Design
Part 7: Transaction Management

 

Exercise Notes

Part 1: Model Entiteta i ...
Part 2: Model Entiteta i ...
Part 3: Formalni upitni je...
Part 4: Optimizacija upita
Part 5: SQL (DML)
Part 6: SQL (DDL, DCL)
Part 7a: SQL (SQL92, SQL99)
Part 7b: Programski SQL
Part 8: Normalizacija
Part 9: Normalizacija (Pr...
Part 10: Serijalizovanost
Part 11: Zaključavanje
Part 12: Vremenske Marke
Part 13: Sistemski Dnev...
Part 14: Prateće Stranice

 

Lab Excercise

ER Diagramer manual
Lab Schedule 09/10
Lab Results 09/10
ADVICE

 

 

ETF School Seal
 
  "Have no fear of perfection - you'll never reach it."
Salvador Dali (1904 - 1989)