DBMS

Subject : Database Management System

Module :

1.  Introduction Database Concepts :       
•  Introduction to data processing. Overview of file systems
•  Drawbacks of file system, Concept of a database.
•  Comparison of  Database systems and File system.
•  Data abstraction,3-Layered Architecture and data
   independence.
•  Data models, Database languages.
•  Database users and administrators.
•  Database system structure

2 Entity–Relationship Model : 
•  Basic concepts
•  Constrains
•  Design issues, Entity–Relationship diagram
•  Strong - Weak entity sets
•  Extended ER features
•  Mapping an ER schema to tables.

3 Relation Model : 
•  Concept of a relation•   Notion of primary and secondary keys•   Structure relation database•   The relation algebra and extended algebra operations•   Formation of queries, Modification of database, Views

4 SQL : 
•  Background, Basic structure
•  Set operations, Aggregate function, Null values.
•  Nested  queries,  Views,  Complex  queries,  Database
   modification
•  *DDL, embedded SQL, Stored procedures and functions

5 Integrity and Security : 
•  Domain Constraints, Referential integrity
•  Assertions, Triggers
•  *Security and Authorization , Authorization in SQL

6 Relational–Database Design :
•  First Normal form, Pitfalls in relational – database design
•  Function dependencies, Armstrong Axioms
•  2nd, 3rd, BCNF , and 4th normal form
•  Decomposition, Desirable properties of decomposition
•  Overall database design process

7 File structure, Indexing and Hashing: 
•  File  organization,  Organization  of  records  in  files. 
   DataDictionary storage.
•  Basic  Indexing  concepts, Ordered Indices,  B+  Tree and  B Tree
   Index Files
•  Static Hashing, Dynamic hashing
•  Index Definition in SQL, Multiple Key access.

8 Transactions:

•  Transaction concept, Transaction states
•  Implementation of atomicity and durability
•  Concurrent Executions, Serializability, Recoverability
•  Implementation of isolation, Transaction definition in SQL

9 Concurrency Control :• Lock-based protocols
•  Timestamp-based protocols
•  Validation-based protocols
•  Deadlock handling

10 Recovery System :
•  Failure Classification, Storage structure
• Recovery & atomicity
•  Log based recovery, Shadow paging
•  Recovering with concurrent transactions
•  Buffer Management

Notes :

1) DBMS (Sem-IV) Sadguru's - Junaid A. Khateeb.pdf
http://www.mediafire.com/?4bsfracbh528mgf

2) Database Systems-Nilkamal Surve-TachMax Publications.pdf
http://www.mediafire.com/?dmiixtz9yr9tbye


3) Database Management system - (SE-TE) Vidyalankar.pdf
 http://www.mediafire.com/?du97h6avxg8bf9f