| Name of the Faculty |
Priyanka Sharma |
| Discipline |
B.TECH |
| semester |
IV Sem |
| subject |
Database Management System & DBMS Lab |
| Paper Code |
CSE-202F & CSE-212F |
| Lesson plan duration |
From Jan 2018 to April 2018 |
| work load lecture per week(in hours) |
3 lectures |
| Week |
Theory |
Practical |
|
Lecture Day |
Topic (including assignment/test) |
Practical Day |
Topic |
|
| 1st |
1 |
Overview of database Management System |
1 |
Add a record in the database |
| 2 |
Various views of data |
|
|
| 3 |
data Models |
|
|
| 2nd |
4 |
Introduction to Database Languages. |
2 |
Delete a record in the database |
| 5 |
Advantages of DBMS over file processing systems |
|
|
| 6 |
Responsibility of Database Administrator |
|
|
| 3rd |
7 |
Introduction to Client/Server architecture |
3 |
Modify the record in the database |
| 8 |
Three levels architecture of Database Systems |
|
|
| 9 |
ER Diagram (Entity Relationship) |
|
|
| 4th |
10 |
mapping Constraints, Keys, |
4 |
Generate queries |
| 11 |
Reduction of E-R diagram into tables |
|
|
| 12 |
Reduction of E-R diagram into tables |
|
|
| 5th |
13 |
Sequential Files, index sequential files, direct files |
5 |
Generate the report |
| 14 |
Hashing, |
|
|
| 15 |
B-trees Index files |
|
|
| 6th |
16 |
Relational Model |
6 |
List all the records of database in ascending order |
| 17 |
Relational Algebra & various operations |
|
|
| 18 |
Relational and Tuple calculus. |
|
|
| 7th |
19 |
QLB , QBE, |
7 |
use of join operation in SQL |
| 20 |
Structured query language – with special reference of (SQL of ORACLE) |
|
|
| 21 |
integrity constraints, functional dependencies |
|
|
| 8th |
22 |
NORMALISATION – (up to 4th Normal forms), |
8 |
use of natural join in SQL |
| 23 |
BCNF (Boyce – code normal forms) |
|
|
| 24 |
Introduction to Distributed Data processing |
|
|
| 9th |
25 |
parallel Databases |
9 |
use of equi join in SQL |
| 26 |
data mining & data warehousing |
|
|
| 27 |
network model & hierarchical model |
|
|
| 10th |
28 |
Introduction to transaction |
|
|
| 29 |
properties of transaction and life cycle of transaction |
|
|
| 30 |
Introduction to Concurrency control |
|
|
| 11th |
31 |
Introduction to Concurrency control |
|
|
| 32 |
Recovery systems |
|
|
| 33 |
need of concurrency control and recovery system |
|
|
| 12th |
34 |
need of concurrency control and recovery system |
|
|
| 35 |
problems in concurrent transactions |
|
|
