MCA 403-Data Base Management System II |
|
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.
|
|