DBMS Q papers 2016

DBMS Notes Compilation

A very good study resource (First 4 Chapters):

https://drive.google.com/file/d/0B9dNjCEOeajVOE1KVkR3andjdEE/view?usp=sharing



Original Link:
http://archive.mu.ac.in/myweb_test/MCA%20study%20material/M.C.A.%20(Sem%20-%20III)%20Paper%20-%20II%20-%20Database%20Management%20System.pdf

Notes

ER Diagram

https://drive.google.com/file/d/0B9dNjCEOeajVVUFHcWJkNVh5Vjg


Relational Model

https://drive.google.com/open?id=0B9dNjCEOeajVMVBrWWg1UjY5V2c


SQL

https://drive.google.com/open?id=0B9dNjCEOeajVZEJiV0ZuNi16aEU

DBMS 101

This lecture covers 'Introduction to DBMS"

Link

Primary topics covered:

• History of Database Systems
• Purpose of Database Systems
• Database Languages
• Relational Databases
• Database Design
• Data Models
• Database Internals
• Database Users and Administrators
• Overall Structure

Course Books

Textbook 1

Title: Database System Concepts
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudharshan
Edition: 4th or 5th or 6th
Publisher: Tata McGraw Hill
Link 1
Link 2

Textbook 2

Title: Fundamentals of Database Systems
Authors: Elmsari and Navathe
Edition: 4th
Publisher: Addison Wesley

Link

Syllabus

UNIT-I

Introductory Concepts of DBMS: Introduction and application of DBMS, Data Independence, Database System Architecture – levels, Mapping, Database users and DBA, Entity – Relationship model, constraints, keys, Design issues, E-R Diagram, Extended E-R features- Generalization, Specialization, Aggregation, Translating E-R model into Relational model.

UNIT-II

Relational Model: The relational Model, The catalog, Types, Keys, Relational Algebra, Fundamental operations, Additional Operations-, SQL fundamentals, DDL,DML,DCL PL/SQL Concepts, Cursors, Stored Procedures, Stored Functions, Database Integrity – Triggers.

UNIT-III

Functional Dependencies, Non-loss Decomposition, First, Second, Third Normal Forms, Dependency Preservation, Boyce/Codd Normal Form, Multi-valued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form.

UNIT-IV

Transaction Management: ACID properties, serializability of Transaction, Testing for Serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks), Time stamping methods, Database recovery management.

Implementation Techniques: Overview of Physical Storage Media, File Organization, Indexing and Hashing, B+ tree Index Files, Query Processing Overview, Catalog Information for Cost Estimation, Selection Operation, Sorting, Join Operation, Materialized views, Database Tuning.