MC9212 Problem Solving and Programming Anna university Question Bank Question paper subject notes lecturer notes unit wise Notes , syllabus for First Semester MCA students...

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


Syllabus :


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
indexing

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
studies

Click The Below Link To Download the notes for all the five units

UNIT I

UNIT II
     
UNIT 3     
               
UNIT IV
               
UNIT V

        


Previous
Next Post »