Information Systems and Databases

Semester: 3
Number of lecture classes (per week): 2
Number of computer exercises classes (per week): 2
Contents / Structure of the subject:
Types of information systems. Procedures for development of information systems. Process modeling. File Organization. The concept of database (DB). System for database management. Basic concepts and characteristics of data models. EP data model. Relational data model. Classification and types of constraints in the relational data model. Functional dependency and key patterns of the relationship. The use of questionable language in the description of the SQL database schema and manipulate data in the DB. Basics of transaction processing. Distributed database. Data Warehouse Systems.
Literature:
1. Mihajlovic D. Information systems and database design, Faculty of Technical Sciences, Novi Sad, 1998 2. Mogin P. The structure and organization of data files, Faculty of Technical Sciences, Novi Sad, 1994 3. Mogin P., Lukovic I. Principles of databases, Faculty of Technical Sciences, Novi Sad, 1996 4. C. Date J. An Introduction to Database Systems, Addison Wesley, 2004