CO2050 Database Systems

Introduction to database systems Information models and systems, database system evolution, file based systems, DBMS approach, database environment and components, DBMS functions, DBMS architecture, data independence, database system life cycle. Data modeling Conceptual models (ER/EER and UML), logical models (relational and object oriented models), relational mapping, NoSQL, Comparison of NoSQL data model with relational data model.. RDBMS concepts Normalization (1NF, 2NF, 3NF and BCNF), object oriented extensions. Database query languages 4GL environments; SQL (DDL, DML and DCL), triggers, views. Database programming techniques Embedded SQL, database programming with function/procedure calls (ODBC, JDBC), stored procedures, Object-relational mapping. Introduction to indexing and transaction processing Types of indexes, transactions, ACID properties, concurrency control, failure and recovery. Database security Security issues and threats, access privileges, relationship between database security and privacy, encryption.