| Abbreviation: BAZEPO
|
Load: 30(L)
+ 15(E)
+ 30(LE)
+ 0(S)
+ 0(FLE)
+ 0(PEE)
|
| Lecturers in charge: |
dr. sc. Tonči Carić |
| Lecturers: |
Tomislav Erdelić mag. ing. el. techn. inf.
(
Exercises, Laboratory exercises
)
Martina Erdelić mag. ing. traff.
(
Laboratory exercises
)
|
| Course description: Basic tasks, types, and the architectures of the database management system (DBMS). An interpretation of the Codd rules and
the mathematical model for relational databases (set theory and predicate logic). Uses of entity-relationship (ER) diagrams
Database design. Introduction to the relational model. Rules for converting an ER model into a relational model. Reference
and domain integrity. Normal forms, normalization, and denormalization of the database. Using SQL language to define the structure
of a database by creating tables, defining data types, and defining constraints. SQL language data manipulation using selection,
projection, table joins, subqueries, and use of built-in and aggregation functions. Introduction to data structures and physical
data representation. Query optimization using indexes. Introduction to the concept of mobile object databases for tracking
traffic entities. Display GPS tracks of different types of vehicles on a digital map.
|
| Compulsory literature: |
| 1. |
Carić, T., Buntić, M.: Autorizirana predavanja iz Baza podataka, Fakultet prometnih znanosti, 2013. |
| 2. |
Elmasri, R., Navathe, S., B.: Fundamentals of Database Systems 5th Edition, Addison-Wesley, 2006. |
| Recommended literature: |
| 3. |
Date, C. J.: The SQL Standard, Addison Wesley, 1996. |
| 4. |
Ullman, D.J.: Database and Knowledge - base Systems, Computer Science Press, 1999.
|
|