Academy of Technical and
Art Applied Studies Belgrade

Databases Course code: T62036 | 8 ECTS credits

Basic information
Level of Studies: Undergraduate applied studies
Year of Study: 1
Semester: 2
Requirements:
Goal: Introduction to data models, a relational model in particular, as well as the standard (ANSI) SQL language. Basic knowledge of the logical and physical levels of databases. Simple databases design and implementation.
Outcome: Students should be able to use the standard SQL language in creating and manipulating a database, apply specific tools for working with a database, design and implement simple databases. Students should be able to participate in the design and implementation of the project, individually or in a team, with full responsibility in the process of database design and administration.
Contents of the course
Theoretical instruction:
  1. Basic concepts from data structure and data model. SQL Basics: Data types, syntax rules
  2. SELECT Queries
  3. Operators and functions
  4. Data grouping
  5. Joins
  6. Subqueries
  7. Database integrity constraints
  8. Functional dependences and normal forms
  9. Mapping from conceptual to physical model
Practical instruction (Problem solving sessions/Lab work/Practical training):
  1. The concept of a database. The main functions of a database management system (DBMS).
  2. Basic concepts from data structure and data model. SQL Basics: Data types, syntax rules
  3. SELECT Queries
  4. Operators and functions
  5. Data grouping
  6. Join
  7. Subqueries
  8. Database integrity constraints
  9. Functional dependences and normal forms
  10. Mapping from conceptual to physical model
Textbooks and References
  1. Chris Fehily, Visual Quickstart Guide SQL, (ISBN: 0-321-33417-5), Peachpit Press, 2005
  2. V.Blagojević, Relacione Baze Podataka, Klub NT, 1998
  3. B.Lazarević, Z.Marjanović, N.Aničić, S.Babarogić, Baze Podataka elek, Fakultet Organizacionih Nauka, Beograd, 2003
  4. R.Ramakrishnan, J.Gehrke, Database Management Systems, McGraw-Hill Education, New York, 2003
  5. Rebecca M.Riordan, Designing effective database systems, Boston : Addison-Wesley, 200
Number of active classes (weekly)
Lectures: 4
Practical classes: 4
Other types of classes: 0
Grading (maximum number of points: 100)
Pre-exam obligations
Points
activities during lectures
0
activities on practial excersises
0
seminary work
0
colloquium
70
Final exam
Points
Written exam
30
Oral exam
0