Subject: Database Management Systems (17.E2517 )
Native organizations units: Sub-department for Applied Computer Science and Informatics
Study programmes of the course:
| Type of studies | Title |
|---|---|
| Master Academic Studies | Computing and Control Engineering (Godina: 1, Winter) |
| Master Academic Studies | Computing and Control Engineering (Godina: 1, Winter) |
| Master Academic Studies | Information and Analytics Engineering (Godina: 1, Winter) |
| Master Academic Studies | Software Engineering and Information Technologies (Godina: 1, Winter) |
| Master Academic Studies | Information and Analytics Engineering (Godina: 1, Winter) |
| Master Academic Studies | Measurement-Information Technologies and Control Engineering (Godina: 1, Winter) |
| Master Academic Studies | Power Software Engineering (Godina: 1, Winter) |
| Master Academic Studies | Computing and Control Engineering (Godina: 1, Winter) |
| Master Academic Studies | Information Engineering (Godina: 1, Winter) |
Educational goal:
Advanced education of students in the field of Database Management Systems (DBMS) applications, and database (DB) administration, with the possibility of their easy involvement in industry projects in the field of database system development.
Educational outcome:
Acquiring of skills and knowledge necessary for the application of DBMSs in practice and database administration.
Course content:
Features and tasks of DBMSs. Physical architecture of a DBMS. Memory management in a DBMS. File management in a DBMS. Physical database organization and performance management. Techniques for the usage of views, sequence generators and indexes at the DB server. Advanced SQL capabilities for database updates and queries. Query optimizers. Mechanisms for providing DB security and safety. DB backup, restore and recovery. Implementation of distributed databases. Software tools for database administration.
Teaching methods:
Teaching is performed through lessons, oral and computer exercises (in the computer classroom), as well as consultations. Through the teaching process, students are constantly motivated to an intensive discussion, problem oriented reasoning, independent study work and active participation in the whole lecturing process. The prerequisite to enter final exam is to complete all the pre-exam assignments by earning at least 30 points.
Literature:
| Authors | Title | Year | Publisher | Language |
|---|---|---|---|---|
| Mogin, P., Luković, I., Govedarica, M. | Principi projektovanja baza podataka | 2004 | Fakultet tehničkih nauka, Novi Sad | Serbian language |
| 2003 | English | |||
| 2019 | English | |||
| Grupa autora | Priručnici za obezbeđenje administriranja izabranim SUBP | 2005 | English | |
| 2000 | English | |||
| 2007 | English |
Knowledge evaluation:
| Course activity | Pre-examination | Obligations | Number of points |
|---|---|---|---|
| Complex exercises | Yes | Yes | 10.00 |
| Term paper | Yes | Yes | 20.00 |
| Complex exercises | Yes | Yes | 10.00 |
| Presentation | Yes | Yes | 10.00 |
| Complex exercises | Yes | Yes | 10.00 |
| Complex exercises | Yes | Yes | 10.00 |
| Oral part of the exam | No | Yes | 30.00 |
Lecturers:
Asistent Matkovski Marijana
Assistant - Master
Computational classes
doc. dr Čeliković Milan
Assistant - Master
Lectures
Faculty of Technical Sciences
© 2024. Faculty of Technical Sciences.
Contact:
Address: Trg Dositeja Obradovića 6, 21102 Novi Sad
© 2024. Faculty of Technical Sciences.