|
Teaching Scheme |
Exam Scheme |
|||||
|
Th. |
Pract. |
Total |
Th. |
Pract. |
TW/Viva |
Total |
|
04 Marks |
02 Marks |
06 Marks |
100 Marks |
25 Marks |
25 Marks |
150 Marks |
|
Hrs./Week |
Hrs./Week |
Hrs./Week |
(3 Hrs.) |
(3 Hrs.) |
(3 Hrs.) |
(3 Hrs.) |
Introductory Concepts
Three scheme architecture of DBMS, Brief history of DBMS development introduction to er model, relational data model, design. Theory of normalization.
Relation Theory and SQL Relation Concepts :
Relational algebra, relational calculus. ANSI-SQL-2 : DDL, DML, constraints and assertions, views, database security.
Application Development Using SQL :
Host language interface and embedded SQL programming 4 GL's, forms management and report, writes stored procedures and triggers. internals of RDBMS physical data structures, data systems architecture,
Query Optimization :
Join algorithm, statistics and cost base optimization transaction processing, concurrency control and recovery management transaction model properties and state serializabilaty, lock protocols, two phase locking.
Special Topics :
Brief introduction to distributed database systems, temporal databases and object oriented database.
Texts/References :
Database systems concepts -By H. F. Korth and silbrschatz abraham, McGraw Hall, 1991.
Fundamental of database systems -By Ramez Elmasri and Shamkant B. Navatha, The Bejamin/Cummings publishing co., second edition, 1994.
