#1
17th October 2012, 10:52 AM
| |||
| |||
Anna Univ. DBMS Syllabus
I am final year data Base Management Systems student from Anna University I don’t know about my syllabus so can you provide syllabus of DBMS final year?
|
#2
17th October 2012, 11:51 AM
| |||
| |||
Re: Anna Univ. DBMS Syllabus
Syllabus for the data Base Management Systems for Anna University is as follows: UNIT I INTRODUCTION AND CONCEPTUAL MODELING Introduction to File and Database systems- Database system structure – Data Models – Introduction to Network and Hierarchical Models – ER model – Relational Model – Relational Algebra and Calculus UNIT II RELATIONAL MODEL 9 SQL – Data definition- Queries in SQL- Updates- Views – Integrity and Security – Relational Database design – Functional dependences and Normalization for Relational Databases (up to BCNF). UNIT III DATA STORAGE AND QUERY PROCESSING Record storage and Primary file organization- Secondary storage Devices- Operations on Files- Heap File- Sorted Files- Hashing Techniques – Index Structure for files –Different types of Indexes- B-Tree - B+Tree – Query Processing. UNIT IV TRANSACTION MANAGEMENT Transaction Processing – Introduction- Need for Concurrency control- Desirable properties of Transaction- Schedule and Recoverability- Serializability and Schedules – Concurrency Control – Types of Locks- Two Phases locking- Deadlock- Time stamp based concurrency control – Recovery Techniques – Concepts- Immediate Update- Deferred Update - Shadow Paging. UNIT V CURRENT TRENDS Object Oriented Databases – Need for Complex Data types- OO data Model- Nested relations- Complex Types- Inheritance Reference Types - Distributed databases- Homogenous and Heterogeneous - Distributed data Storage – XML – Structure of XML- Data- XML Document- Schema- Querying and Transformation. – Data Mining and Data Warehousing. |
Tags |
syllabus |
Thread Tools | Search this Thread |
|