Subject: Information Systems and Databases
(06 -
GI205) Basic Information
Course specification
Course is active from 01.10.2007.. Basic education in the field of information systems and databases. Enabling students in following projects in the filed of information system and database development. Introduction to the notion and role of information systems in an organization system. Introduction to current data models, especially relation model. Mastering basic techniques in the application of structured query language (SQL) on database servers. Types of information systems. Procedures for developing information systems. Process modelling. Data file organization. Notion of a database (DB). System for database management. Basic concepts and properties of data models. ER data model. Relational data model. Classification and types of limitations in relational data model. Functional dependency and the key relation schemes. Usage of the query language SQL in describing database schemes and in data manipulation in DB. Basic transaction processing. Distributed databases. Data storage systems. Teaching is held in the form of lectures, auditory and computer practice (in computer laboratory) and consultations. During the entire teaching process, students are encouraged to participate in an active communication, critical thinking, individual work, as well as in active relationship toward the teaching process. A precondition for obtaining the signature of attendance and for taking the final examination is having all prerequisites done.
|