Databases Course code: P62036 | 8 ECTS credits
Basic information
Level of Studies:
Undergraduate applied studies
Year of Study:
3
Semester:
6
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:
- Basic concepts from data structure and data model. SQL Basics: Data types, syntax rules
- SELECT Queries
- Operators and functions
- Data grouping
- Joins
- Subqueries
- Database integrity constraints
- Functional dependences and normal forms
- Mapping from conceptual to physical model
Practical instruction (Problem solving sessions/Lab work/Practical training):
- The concept of a database. The main functions of a database management system (DBMS).
- Basic concepts from data structure and data model. SQL Basics: Data types, syntax rules
- SELECT Queries
- Operators and functions
- Data grouping
- Join
- Subqueries
- Database integrity constraints
- Functional dependences and normal forms
- Mapping from conceptual to physical model
Textbooks and References
- Chris Fehily, Visual Quickstart Guide SQL, (ISBN: 0-321-33417-5), Peachpit Press, 2005
- V.Blagojević, Relacione Baze Podataka, Klub NT, 1998
- B.Lazarević, Z.Marjanović, N.Aničić, S.Babarogić, Baze Podataka elek, Fakultet Organizacionih Nauka, Beograd, 2003
- R.Ramakrishnan, J.Gehrke, Database Management Systems, McGraw-Hill Education, New York, 2003
- 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