Introduction to Database

Syllabus

Course Hand out (or) Lesson Plan

MID - I MARKS - THEORY   

MID - II MARKS - THEORY - QUIZ - ASSIGNMENT MARKS

Descriptive QUESTIONS

Academic Calendar ( Revised & New )

External link for Textbook

 Unit - I

1. Database System vs File System - Video
2. video2 - Unit -1 - outline
3. ppt for notes - click here

Objective Questions - Unit I

Unit - II

1. ppt for notes - click here

        Objective Questions - Unit II

Mid - I Question Paper

Mid - I Quiz Question Paper

Assignment - Answer all questions from Mid I Descriptive Question Paper

Unit - III

1. Relational Data Model Concepts
2. Integrity Constraints, Relational Algebra, SQL- Tables, Views, Index, Query, Sub Query, Aggregate Functions, DML Operations, Set Operations and Cursors. 

Unit - IV

1. Functional Dependencies
2. Normalization - 1NF,2NF,3NF,BCNF, MVD & 4NF, Lossless Join decomposition, JD & 5NF, ID-Inclusion dependency.

Unit - V

1. Transaction System - Desirable properties of transaction
2. Testing of Serializability
3. Serializability of schedules
4. Conflict & View Serializable Schedule
5. recoverability
6. Log based recovery - external link
7. Check Points
8. ARIES algorithm - external link
9. Deadlock handling - external link

EXTERNAL QUESTION PAPER