COURSE AIMS AND OBJECTIVES: Acquiring basic knowledge on relational database systems, and on conceptual, logical and physical data modeling. Mastering the SQL language for working with relational databases.
COURSE DESCRIPTION AND SYLLABUS:
1. Introduction to database systems. Basic concepts and definitions. Database architecture. Database lifecycle.
2. Relational data modeling. Entity-relationship modeling. Relational modeling. Functional and multi-valued dependencies. Normalization.
3. Relational database languages. Relational algebra. Relational calculus. Structured query language - SQL. Query optimization.
4. Physical structure of a database. Blocks, records, files, pointers. Access based on the primary key. Access based on other data. Hash tables, indices, B-trees.
5. Implementation of relational operations. Implementing the natural join. Implementing other operations. Optimal evaluation of algebraic expressions.
6. Integrity and security issues. Maintaining integrity. Concurrent access. Recovery from failure. Protection from unauthorized access.
|
-
An Introduction to Database Systems, 7th edition, C. J. Date, Addison-Wesley, 1999.
-
Database System Concepts, 4th edition, A. Silberschatz, H. F. Korth, S. Sudarshan, McGraw - Hill, 2001.
-
Database Management Systems, R. Ramakrishnan, McGraw - Hill, 1998.
-
MySQL Reference Manual, M. Widenius, D. Axmark, O'Reilly & Associates, 2002.
-
Baze podataka - konceptualno, logičko i fizičko modeliranje podataka, M. Varga, DRIP, Zagreb, 1994.
|
Pristupačnost
