CO312: Database Systems
| Course Number : CO312 | ||||||
|---|---|---|---|---|---|---|
| Course Title : Database Systems | ||||||
| Credits : 3 | ||||||
| Prerequisites : Computer Programming (CO212), Data Structures and Algorithms (CO214) | ||||||
| No | Course Content | Time Allocated (hours) | ||||
| L | T | P | A | |||
| 01 | 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 | 3 | 1 | |||
| 02 | Data Modelling:
Motivation, roll in system development, levels of abstraction and practice, Conceptual models; ER and UML, Logical models; Relational and OO Models | 6 | 2 | 5 | 3 | |
| 03 | RDBMS Concepts:
Relational algebra and relational calculus, Relational integrity, Normalization, object oriented extensions | 6 | 2 | 3 | ||
| 04 | Database Query Languages:
4GL environments, SQL; DDL, DML and DCL, query optimization; rule based and cost based approaches, embedded SQL | 6 | 8 | |||
| 05 | Transaction Processing:
Transactions, concurrency control, serialization, failure and recovery | 4 | 1 | 3 | ||
| 06 | Distributed Databases:
Data fragmentation, replication and allocation, distributed query processing, distributed transaction model, concurrency control, homogeneous and heterogeneous environments | 1 | ||||
| 07 | Physical Database Design:
Storage and file structures, indexed, hashed and signature files, B-trees, sparse and dense indexes, variable length records, database tuning | 2 | 3 | 3 | ||
| Total | 28 | 4 | 17 | 13 | ||
| Assessment | Percentage Marks | |||||
| Continuous Assessment | 40 | |||||
| Tutorials | 10 | |||||
| Practicals | 15 | |||||
| Assignments | 15 | |||||
| Written Examinations | 60 | |||||
| Mid-semester | 20 | |||||
| End-semester | 40 | |||||