Academy of Technical and
Art Applied Studies Belgrade

Databases Course code: 117002* | 5 ECTS credits

Basic information
Level of Studies: Undergraduate applied studies
Year of Study: 3
Semester: 6
Requirements:
Goal: Enabling students to acquire basic knowledge of information system design and organization relational databases, so that they can immediately apply the acquired knowledge in practice. In practice classes, each student needs to "design" his small information system.
Outcome: Independent work on creating and updating databases.
Contents of the course
Theoretical instruction:
  1. he concept of databases, physical, conceptual, and user level of the database, basic concepts of the model data, classical data model (hierarchical, network, and relational).
  2. Entity-relationship model (E-R model), Entities and sets of entities, attributes, relations and sets of relations, existential dependence, primary keys, diagram of E-R model, information structure of E-R model.
  3. Representation of strong sets of entities.
  4. Relational model, Relation-basic information structure of the relational model. Relational algebra, set operations, selection operator, projections, merging,
  5. Cartesian product, natural connection, external connection, division.
  6. Entorki relational account, domain relational account.
  7. Relational query languages, SQL query language, definition data, schema, base tables, indexes, views, data manipulation.
  8. Views, defining a view, creating a view, searching, removing a view. A new approach to views, union, cross-section. difference, restriction, projection, natural fusion.
  9. Logical database design, decomposition relational schemes (Normal forms) of SUBP, SUBP functions, data integrity, and security.
Practical instruction (Problem solving sessions/Lab work/Practical training):
  1. MS ACCESS: database creation, data types in Access, table creation, query, creation reports, creating screen forms. Realization of 10 queries using relational algebra and SQL. Practical realization of a database in Access.
Textbooks and References
  1. Vulović, R., „Baze podataka“, Visoka železnička škola strukovnih studija, Beograd, 2011.
  2. Veljović, A., Papić, M., „Microsoft Access 2010 priručnik“, Tehnički fakultet, Čačak, 2014.
  3. Obradović, S., Kaluđerović, P., „Projektovanje baza podataka i aplikacija“, Visoka elektrotehnička škola, Beograd, 2003.
  4. Lazetić, G., „Uvod u relacione baze podataka“, Prirodno-matematički fakultet, Beograd, 2004.
  5. Lazarević, B., Marjanović, Z., Aničić, N., Babarogić, S., „Baze podataka“, Fakultet organizacionih nauka, Beograd, 2012.
Number of active classes (weekly)
Lectures: 2
Practical classes: 2
Other types of classes: 0
Grading (maximum number of points: 100)
Pre-exam obligations
Points
activities during lectures
5
activities on practial excersises
5
seminary work
20
colloquium
20
Final exam
Points
Written exam
25
Oral exam
25