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.
Students need to practice using language of relational, object and XML databases for projecting database schema, setting queries and database data manipulation.
Study program: Information Technologies – Engineering (Bachelor degree)
Biljana Radulovic, full professor
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.