MC9212 Problem Solving and Programming Anna university Question Bank Question paper subject notes lecturer notes unit wise Notes , syllabus for First Semester MCA students...
Posted by R.Anirudhan
UNIT I INTRODUCTION
Historical perspective - Files versus database systems - Architecture - E-R model -
Security and Integrity - Data models.
UNIT II RELATIONAL MODEL
The relation - Keys - Constraints - Relational algebra and Calculus - Queries -
Programming and triggers
UNIT III DATA STORAGE
Disks and Files - file organizations - Indexing - Tree structured indexing - Hash Based
UNIT IV QUERY EVALUATION AND DATABASE DESIGN
External sorting - Query evaluation - Query optimization - Schema refinement and
normalization - Physical database design and tuning - Security
UNIT V TRANSACTION MANAGEMENT
Transaction concepts - Concurrency control - Crash recovery - Decision support - Case