DBMS LECTURE PLAN
Course Code & Name
: 080250009/Database
Management Systems
Faculty :
Class & Semester : II Year BE (CSE) – IV Semester
|
Sl. No.
|
PROPOSED
|
TOPIC
|
|
|
DATE
|
PERIOD |
||
|
1.
|
08.12.2011
|
2
|
MODULE 1 [UNIT-1]
Purpose of Database System
|
|
2.
|
09.12.2011
|
1
|
Views of data
|
|
3.
|
12.12.2011
|
8
|
Data
Models
|
|
4.
|
13.12.2011
|
7
|
Database Languages
|
|
5.
|
15.12.2011
|
2
|
Database System Architecture
|
|
6.
|
16.12.2011
|
1
|
Database users and Administrator
|
|
7.
|
19.12.2011
|
8
|
Entity-Relationship
model
(E-R
model )
|
|
8.
|
20.12.2011
|
7
|
E-R Diagrams
|
|
9.
|
22.12.2011
|
2
|
Introduction to relational databases
|
|
10.
|
23.12.2011
|
1
|
[UNIT-II] The
catalog- Types
|
|
11.
|
26.12.2011
|
8
|
Keys, Relational
Algebra
|
|
12.
|
27.12.2011
|
7
|
Domain Relational Calculus
|
|
13.
|
29.12.2011
|
2
|
Tuple Relational Calculus
|
|
14.
|
30.12.2011
|
1
|
Fundamental operations
|
|
15.
|
02.01.2012
|
8
|
Additional
Operations
|
|
16.
|
03.01.2012
|
7
|
SQL fundamentals
|
|
17.
|
05.01.2012
|
2
|
Integrity Security , Triggers
|
|
18.
|
06.01.2012
|
1
|
Advanced
SQL features
|
|
19.
|
09.01.2012
|
8
|
Embedded SQL– Dynamic SQL
|
|
20.
|
10.01.2012
|
7
|
Missing
Information– Views
|
|
CYCLE TEST – I (12.01.2012 – 14.01.2012)
|
|||
|
21
|
19.01.2012
|
2
|
[MODULE II] Introduction to Distributed
Databases
|
|
22
|
20.01.2012
|
1
|
Client/Server Databases
|
|
23.
|
23.01.2012
|
8
|
[UNIT-III] Functional Dependencies
|
|
24.
|
24.01.2012
|
7
|
Non-loss Decomposition
|
|
25.
|
27.01.2012
|
1
|
Functional Dependencies
|
|
26.
|
30.01.2012
|
8
|
First,
Second, Third Normal Forms
|
|
27.
|
31.01.2012
|
7
|
Dependency Preservation
|
|
28.
|
02.02.2012
|
2
|
Boyce/Codd Normal Form
|
|
29.
|
03.02.2012
|
1
|
Multi-valued Dependencies
|
|
30
|
06.02.2012
|
8
|
Fourth Normal
|
|
31.
|
07.02.2012
|
7
|
Form Join
Dependencies and Fifth Normal Form
|
|
32.
|
09.02.2012
|
2
|
[UNIT-IV ] Transaction
Recovery- ACID Properties
|
|
33.
|
10.02.2012
|
1
|
System Recovery Media Recovery
|
|
34.
|
13.02.2012
|
8
|
Two Phase Commit, Save Points
|
|
35.
|
14.02.2012
|
7
|
SQL Facilities for recovery
|
|
36.
|
16.02.2012
|
2
|
Concurrency – Need for Concurrency
|
|
37.
|
17.02.2012
|
1
|
Locking Protocols
|
|
CYCLE
TEST – II (20.02.2012 – 22.02.2012)
|
|||
|
38.
|
23.02.2012
|
2
|
[MODULE III]Two Phase Locking –Intent
Locking
|
|
39.
|
24.02.2012
|
1
|
Deadlock-
Serializability
|
|
40.
|
27.02.2012
|
8
|
Recovery Isolation Levels
|
|
41.
|
28.02.2012
|
7
|
SQL
Facilities for Concurrency
|
|
42.
|
01.03.2012
|
2
|
Locking
protocols-revision
|
|
43.
|
02.03.2012
|
1
|
[UNIT-V ]
Overview of Physical Storage Media
|
|
44.
|
05.03.2012
|
8
|
Magnetic Disks – RAID
|
|
45.
|
06.03.2012
|
7
|
Tertiary storage
|
|
46.
|
08.03.2012
|
2
|
File
Organization
|
|
47.
|
09.03.2012
|
1
|
Organization
of Records in Files
|
|
48.
|
12.03.2012
|
8
|
Indexing and Hashing
|
|
49.
|
13.03.2012
|
7
|
Ordered Indices
|
|
49.
|
15.03.2012
|
2
|
B+
tree Index Files,
|
|
50.
|
16.03.2012
|
1
|
B tree Index Files
|
|
51.
|
19.03.2012
|
8
|
Static Hashing – Dynamic Hashing
|
|
52.
|
20.03.2012
|
7
|
Query Processing Overview
|
|
53.
|
22.03.2012
|
2
|
Catalog Information for Cost Estimation
|
|
54.
|
23.03.2012
|
1
|
Database Tuning
|
|
CYCLE TEST III (26.03.12 – 28.03.12)
|
|||
Faculty in- charge HOD/CSE
PRINCIPAL
No comments:
Post a Comment