583 Data Bases

583 Data Bases

  • Study programme and level: Master’s joint study programme Management in Administration 2nd Cycle
  • 2nd year
  • 7 ECTS
  • Course type: proffesional elective
  • Lectures: 21
  • Seminar: 11
  • Other study activities: 118
  • Individual work: 60
  • Language: English, Serbian, Slovene
  • Lecturer: Zoran Marjanović, PhD, Slađan Babarogić, PhD

 

1. Content (Syllabus outline)

Fundamentals of Database. Evolution of database systems. Data models. The theory of relational models. The components of the data model. Models of objects and relationships.
The relational model. Object model. Object - relational model . Defining tables and queries.
Functions of database management. Reviewing the database. Structure, constraints, and operations related to the component data model. SQLODL, OQL, object extensions to SQL99. Semi-structural model. XML and its data model, XQuery.

2. Readings

  • Lazarević B., Marjanović Z., Aničić N., Babarogić S., Baze podataka, FON, 2011
  • Date, C.J., An Introduction to Database Systems, Addison-Wesley, 2000.
  • Ramakrishan, R., J. Gehrke, Database Management Systems, McGraw Hill, 1999.
  • Elmasri, R.A., B.S., Navathe, Fundamentals of Database Systems, Addison-Wesley, 2000.
  • Garcia-Molina, H., J. Ullman, J.Widom, Database Systems - The Complete Book, Prentice Hall, 2002.

3. Objectives and competences

Develop knowledge and skills in design, development and use of databases in organizations of public administration. Develop the ability to critically evaluate alternative approaches in this area. Acquiring  knowledge of database systems and database management.
Competences:

  • Further study and learning methodologies and information technology;
  • Ability to communicate with users of databases in general and administration and communications and their own knowledge;
  • Solving problems of design, development, construction and maintenance of databases in the field of administration and beyond;
  • Creative collaboration in project teams in the development of information systems, where the base data needed source of information;
  • Critically assess and analyze the impacts and consequences of the use of databases in government and the wider city and the integrity of individuals and society.

 

4. Intended learning outcomes:

Knowledge and understanding:
Student is able to independently perform tasks related to this area, connecting their knowledge with understanding. Is able to respond to questions regarding the problem thus qualifies for continuedprofessional development, and to use the knowledge gained in their practical work environment.

 

5. Learning and teaching methods:

Classes are taught through lectures, exercises and workshops. Group resolving concretely defined set of tasks and user requirements. The active role of students in project development and defense of design solutions.

 

6. Assessment

Type (examination, oral, coursework, project):

  • Project assignemnts 20%
  • Student paper 20%
  • Oral or written exam 60%