mca Syllabus

Data Base Management System I
Code: MCA204
CONTACTS: 3L + 1 T
CREDITS: 4
Introduction to DBMS, architecture, administration roles, data dictionary, Traditional models, three-level architecture, hierarchical model, network model and relational model Relational model – definitions and properties, keys integrity rules, relational algebra, joins, set operations, Tuple relational calculus and Domain relational calculus.
SQL constructs, PL/SQL,Query & its optimisation techniques Singled valued functional dependencies.
Database design, conceptual, logical and physical models, ER diagram and model, normal forms (1,2,3,BCNF).
Storage structure- Sequential, Indexed Sequential.
B+ tree – creation, insertion & deletion.
Indexing- Primary, Secondary, Multi Level.

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