mca Syllabus

Data Base Management System II
Code: MCA403
CONTACTS: 3L + 1 T
CREDITS: 4
Database Design: Multivalued dependencies, theory of normalisation-4NF, 5NF, 6NF DKNF ANSI SQL2: DDL, DML, constraints and assertions, views, database security. Transaction processing, concurrency control, Recovery management. Transaction model properties, lock base protocols, Two-phase locking, Live – Lock, Time- Stamp Protocol.  Brief introduction to distributed database, temporal database and object-oriented database. Embedded SQL & Applications.

Books:
1.Database System Concepts, Silberschatz Korth, Sudarshan, MH
2. Database Management Systems,Ramakrishnan, MH
3. Database Management Systems, A.k. Pujari, ISTE/EXCEL
4.Oracle PL/SQL Programming,Feuerstein, SPD/O’REILLY
5. Database Management Systems, Leon, VIKAS
6. Data Base Processing:Fundamentals, Design & Implementation, Kroenke,PHI
7. SQL PL/SQL for Oracle 8 & 8i, P.S Deshpande, Wiley Dreamtech
8.Data Base Management Systems, V.K Jain, Wiley Dreamtech
9. Beginning SQL Programming,Kauffman, SPD/WROX