ME/M.Tech. Computer Tech. & Applications, Software Systems 1st semester MCTA 104 Advance DBMS Syllabus
Computer Tech. & Applications (UTD, RGTU, Bpl)
Software Systems SATI (Vidisha)
ME/M.Tech. 1st FIRST SEMESTER SYLLABUS
MCTA 104 Advance DBMS Syllabus
DBMS Concept introduction, data models, E-R diagram, Keys, Relational database schemas, integrity constraints, relational algebra and calculus, normalization, normal form.
Indexing, Query processing and optimization, concurrency control. Distributed database: fragmentation transparency, distributed query processing and optimization, distributed transaction modal and concurrency control, distributed deadlock and commit protocol.
Object oriented and object relational databases: specialization generalization, aggregation and association, object, object identity, architecture of object oriented and object relational databases.
Web databases: accessing databases through web, web server, XML database.
Introduction to image and multimedia database and data structure. Data structure RTree, K-D tree, Quad tree, content based retrieval: color histogram.
1.R. Elmasri, S. Navathe, Benjamin Cumming, Fundamentals of Database system
2. H.F. Korth and A. Silberschatz, Database concept, (II ed) McGraw Hill, 1991
3. C.J. Date, An Introduction to Database Sys tem Volume I (V ed), Addision W esley
4. Narang, Object Oriented Database, Prentice – Hall of India, New Delhi.
5. W. Kim “Modern Database System”, 1995, Acin Press, Addision – W esley.