Description
Theoretical classes:
Relational data model – concepts of operational model component, relational algebra and relational calculations. Standard query language SQL. Queries. Data manipulation in database. Views. Constraints. Object data model – specification of types. Inheritance of tates and behavior. Class diagrams. Object query language OQL. XML as a data model. Definition of XML document types. Xpath and Xquery query languages. Transactions – term. Locking management.
Practical classes:
Students need to practice using language of relational, object and XML databases for projecting database schema, setting queries and database data manipulation.
General information
Study program: Information Technologies – Engineering (Bachelor degree)
ECTS: 5
Semester: 4
Lectures: 2
Exercises: 2
Lecturer
Biljana Radulovic, full professor
Email: bradulov@tfzr.uns.ac.rs
Course books
1. Ullman J., Widom J., Database Systems - Complete Book Stanford University, Addison Wesley 2002.
2. Mogin P.,LukovicI., Principles of Databases, Faculty of Technical Sciences,Novi Sad, 1996.
3. Mogin P.,LukovicI., Govedarica M., Principles of Databases Projecting (In Serbian), Faculty of Technical Sciences,Novi Sad, 2000.
4. Lazarevic B., Marjanovic Z., Anicic N, Babarogic S, Databases (In Serbian), Faculty of Organizational Sciences, 2006.
