My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
Advertisements
|
Syllabus of Andhra University MCA - MCA 2.2.2 Database Management Systems
Posted Date: 16 Feb 2008 Resource Type: Articles/Knowledge Sharing Category: General
|
Posted By: rajasekhar Member Level: Gold
Rating:  Points: 5
|
|
|
Syllabus of Andhra University MCA - MCA 2.2.2 Database Management Systems
With effect from 2004-05 admitted batch
Instruction: 3 Periods/week
Sessional Marks: 50
Univ-Exam-Marks:100
Time: 3 Hours
1. Database Systems Concepts And Architecture:
Introduction, data models, schemas and instance; three-schema architecture and data independence; database language and interface, the database system environment; centralized and client/server architecture of DBMSs; classification of DBMSs.
2. Data Modeling Using The E-R Model:
High- level conceptual data models for database design; Entity types, entity sets, attributes and keys; relationship types, relationship sets, roles and structural constraint; weak entity types, ER diagrams, naming conventions and design issues; Notation for UML class diagrams
3. Enhanced ER And UML Modeling:
Subclasses, super classes and inheritance; specialization and generalization; constraints and characteristics of specialization and generalization, modeling of union types using categories; representing specialization/ generalization and inheritance in UML class diagrams; relationship types of degree higher than two; data abstraction, knowledge representation and ontology concepts
4. The Relational Data Model And Relational Database Constraints:
Relational model concepts, relational model constraints and relational database schemas; updating operations and dealing with constraints violations
5. The Relational Algebra And Relational Calculus
Unary relational operations: SELECT and PROJECT; relational algebra operations from set theory; binary relational operations: JOIN and DIVISION; additional relational operations; the tuple relational calculus; the domain relational calculus
6. Relational Database Design By ER And EER-To-Relational Mapping:
Relational database design using ER-to-Relational mapping; mapping EER model constructs to relations
7. Functional Dependencies And Normalization For Relational Databases:
Informal design guidelines for relational schemas; functional dependencies; normal forms based on primary leys; general definitions of 2nd and 3rd normal forms; Boyce-Codd normal forms
8. Transaction Processing Concepts:
Introduction to transaction processing; transaction and system concepts; desirable properties of transaction; characteristics schedule based on recoverability; characteristics schedule based on serializability.
9. Concurrency Control Techniques:
Two phase locking techniques for concurrency control; concurrency control based on timestamp ordering; multi-version concurrency control techniques; validation(optimistic) concurrency control techniques; granularity of data items and multi granularity locking.
10. Database Recovery Techniques:
Recovery concepts; recovery techniques based on deferred updates; recovery techniques based on immediate update; shadow paging; the ARIES recovery algorithm.
Text Book:
Fundamentals of Database Systems Ramez Elmasri and Shamkant B. Navathe, 4th edition, Pearson education.
Reference:
Database Concepts, Abraham Silberschatz, Henry F Korth, S.Sudarshan, McGraw-Hill
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|
|