MC9213 DATABASE MANAGEMENT SYSTEMS SYLLABUS | ANNA UNIVERSITY MCA 1ST SEMESTER SYLLABUS REGULATION 2009 2011 2012-2013 BELOW IS THE ANNA UNIVERSITY FIRST SEMESTER MCA MASTER OF COMPUTER APPLICATIONS DEPARTMENT SYLLABUS, TEXTBOOKS, REFERENCE BOOKS,EXAM PORTIONS,QUESTION BANK,PREVIOUS YEAR QUESTION PAPERS,MODEL QUESTION PAPERS, CLASS NOTES, IMPORTANT 2 MARKS, 8 MARKS, 16 MARKS TOPICS. IT IS APPLICABLE FOR ALL STUDENTS ADMITTED IN THE YEAR 2011 2012-2013 (ANNA UNIVERSITY CHENNAI,TRICHY,MADURAI,TIRUNELVELI,COIMBATORE), 2008 REGULATION OF ANNA UNIVERSITY CHENNAI AND STUDENTS ADMITTED IN ANNA UNIVERSITY CHENNAI DURING 2009
MC9213 DATABASE MANAGEMENT SYSTEMS L T P C
3 0 0 3
UNIT I INTRODUCTION 9
Historical perspective - Files versus database systems - Architecture - E-R model -
Security and Integrity - Data models.
UNIT II RELATIONAL MODEL 9
The relation - Keys - Constraints - Relational algebra and Calculus - Queries -
Programming and triggers
UNIT III DATA STORAGE 9
Disks and Files - file organizations - Indexing - Tree structured indexing - Hash Based
indexing
4
UNIT IV QUERY EVALUATION AND DATABASE DESIGN 9
External sorting - Query evaluation - Query optimization - Schema refinement and
normalization - Physical database design and tuning - Security
UNIT V TRANSACTION MANAGEMENT 9
Transaction concepts - Concurrency control - Crash recovery - Decision support - Case
studies
TOTAL : 45 PERIODS
REFERENCES:
1. Raghu RamaKrishnan and Johannes Gehrke, “Database Management Systems”,
McGraw Hill International Editions, 2000.
2. C. J. Date, “An Introduction to Database Systems”, Seventh Edition, Addison
Wesley, 1997.
3. Abraham Silberschatz, Henry. F. Korth and S. Sudharshan, “Database system
Concepts”, Third Edition, Tata McGraw Hill, 1997.
MC9213 DATABASE MANAGEMENT SYSTEMS L T P C
3 0 0 3
UNIT I INTRODUCTION 9
Historical perspective - Files versus database systems - Architecture - E-R model -
Security and Integrity - Data models.
UNIT II RELATIONAL MODEL 9
The relation - Keys - Constraints - Relational algebra and Calculus - Queries -
Programming and triggers
UNIT III DATA STORAGE 9
Disks and Files - file organizations - Indexing - Tree structured indexing - Hash Based
indexing
4
UNIT IV QUERY EVALUATION AND DATABASE DESIGN 9
External sorting - Query evaluation - Query optimization - Schema refinement and
normalization - Physical database design and tuning - Security
UNIT V TRANSACTION MANAGEMENT 9
Transaction concepts - Concurrency control - Crash recovery - Decision support - Case
studies
TOTAL : 45 PERIODS
REFERENCES:
1. Raghu RamaKrishnan and Johannes Gehrke, “Database Management Systems”,
McGraw Hill International Editions, 2000.
2. C. J. Date, “An Introduction to Database Systems”, Seventh Edition, Addison
Wesley, 1997.
3. Abraham Silberschatz, Henry. F. Korth and S. Sudharshan, “Database system
Concepts”, Third Edition, Tata McGraw Hill, 1997.
No comments:
Post a Comment
Any doubt ??? Just throw it Here...