The course participant determines the properties of the real object that can be recorded in the computer. In doing so, he has determined a computer object and its properties. The course participant determines and defines the relationships between different real objects that are functionally connected. At the same time, he determines and defines the relationships between the corresponding computer objects. This enables the course participant to form the basis of a database. Using auxiliary software, he will accelerate the design of a database and be able to prepare appropriate documentation.

After completing the course, the student has the ability to perceive functionally connected real objects and present them in the computer. This forms the foundations of a database.

1. Definition of a database. 2. Database management systems. 3. Data models. 4. Indexing. 5. Conceptual, physical, logical database model. Design problems. 6. Object-relation model. 7. Case study 1. 8. Normalization problem. Use of special programs for database design. 9. Case study 2. 10. Physical implementation and use of DBMS. 11. Case study 3.

1. Sorting and searching. 2. Indexing problem. 3. Data description systems. Linking data description systems to indexing. 4. Data modeling. Data types. BLOB data. 5. Realization of MOV in computers. Fundamentals of DBMS. 6. Implementation of case study 1. 7. Optional case study 1. 8. Implementation of case study 2. 9. Optional case study 2. 10. Implementation of case study 3.

Programming. Data structures.

SQL server, phpMyAdmin

Total assigned hours: 75

New material: 30
Elaboration and examples (recapitulation): 0

Auditory exercises: 20
Laboratory exercises: 0
Calculation tasks: 0
Seminar paper: 0
Project: 10
Consultations: 0
Discussion/workshop: 0
Research study work: 0

Review and grading of calculation tasks: 0
Review and grading of lab reports: 0
Review and grading of seminar papers: 0
Review and grading of the project: 0
Test: 10
Test: 0
Final exam: 5

Activity during lectures: 0
Test/test: 70
Laboratory practice: 0
Calculation tasks: 0
Seminar paper: 0
Project: 0
Final exam: 30
Requirement for taking the exam (required number of points): 70

Akmal Chaudhri, Mary Loomis; Object Databases in Practice; Prentice Hall ; Suad Alagić; Relation databases; Svijetlost; Grady Booch, James Rumbaugh, Ivar Jacobson; The Unified Modeling Language User Guide; Prentice Hall; Gordana Pavlović-Lažetić; Introduction to relational databases; poincare.matf.bg.ac.rs; Lex de Haan, Toon Koppelaars; Applied Mathematics for Database; Apress