CO226 - Database Systems
Course Code
CO226
Course Title
Database Systems
Credits
3
Course Type
CORE
Textbooks and References
- Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems 7th Edition, 2016
- Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems, 3rd Edition, McGrawHill, 2004
| Topic | Time Allocated / hours | |||
|---|---|---|---|---|
| L | T | P | A | |
|
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 modelling Importance of data modelling in system development; Levels of abstraction and practice; Conceptual models; ER/EER and UML; Logical models; Relational and OO Models, Relational mapping |
- | - | - | - |
|
RDBMS concepts Relational algebra and relational calculus; Relational integrity, 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 |
- | - | - | - |
|
Introduction to indexes and query optimization Types of indexes; primary and secondary indexes, Query optimization; rule based and cost based approaches |
- | - | - | - |
|
Introduction to transaction processing Transactions, ACID properties, Concurrency control, Serialization, Failure and recovery |
- | - | - | - |
|
Database Project |
- | - | - | - |
|
Total (hours) |
31 | 4 | 12 | 8 |
L = Lectures, T = Tutorial classes, P = Practical classes, A = Homework Assignments
| Assessment | Percentage Marks |
|---|---|
| Practicals | 10 |
| Projects | 20 |
| Mid-Exam | 20 |
| End-Exam | 50 |
Last Update: 08/02/2023
|
Edit this page