SJCE/AIDS/SER/014
Name of the Faculty : Mrs.VINCYSAHANA R Sub Code : AD3391
Dept / Year / Sem /Sec : AI&DS/ II / III Subject :Database Design and Management
Regulation : R -2021 Lesson Plan Academic Year : 2024- 2025
Teaching
Cumulative Planned Method Dependencies
Unit Description Actual Date Book Remarks
hours Date BB/PPT/ (page no.)
Video
Database environment 1 BB T1 83
CONCEPTUAL DATA MODELING
Database system development 2 T1 ASSIGNMENT
BB 347
lifecycle
Requirements collection 3 T1
BB 350
(8 HOURS)
T1
UNIT-1
Database design 4 BB/PPT 369
5 T1
Entity-Relationship model BB 405
6 T1
Entity-Relationship model BB 405
Enhanced-ER model 7 T1
BB/w2 433
UML class diagrams 8 T1 ASSIGNMENT
BB/w2 433
Teaching
Cumulative
Description Planned Date Actual Date Method Dependencies Remarks
Unit hours Book
BB/PPT/Video (page no.)
9 BB T1 149
Relational model concepts
10 BB T1 149
Relational model concepts
11 BB T1 161
Integrity constraints
RELATIONAL MODEL AND SQL
12 BB T1 191 ASSIGNMENT
SQL Data manipulation
13 BB T1 200
SQL Data manipulation
(10 HOURS)
UNIT II
14 BB T1 233
SQL Data definition
15 BB T1 233
SQL Data definition
16 BB T1 251
Views
17 BB T1 272 ASSIGNMENT
SQL programming
18 BB T1 272
SQL programming
Teaching
Cumulative Planned
Description Actual Date Method Boo Dependencies Remarks
Unit hours Date
BB/PPT/Video k (page no.)
19 T2 BB 289 ASSIGNMENT
ER
RELATIONAL DATABASE DESIGN AND NORMALIZATION
20 T2 BB 290
EER-to-Relational mapping
21 T2 BB 290
EER-to-Relational mapping
22 T1 BB 454
Update anomalies
UNIT-III
23 T1 BB 456
Functional dependencies
24 T1 BB 456
Functional dependencies
25 T2 BB 505 ASSIGNMENT
Inference rules
26 T2 BB 510
Minimal cover
513
27 T2 BB
Properties of relational
decomposition
HOU
( 10
28 T2 BB 520
Normalization
Teaching
Cumulative
Description Planned Date Actual Date Method Dependencies Remarks
Unit hours Book
BB/PPT/Video (page no.)
Transaction
29 ASSIGNMENT
T2 BB
746
Transaction concepts
30
T2 BB
TRANSACTION MANAGEMENT
746
Transaction Properties BB
31 T2 748
(8 HOURS)
UNIT IV
BB
32 T2 757
properties
33 T2 BB 759
Schedules – Serializability
34 T2 BB 759
Schedules – Serializability
35 T2 BB 781
Concurrency Control-Introduction
36 T2 BB ASSIGNMENT
Two phase locking technique 782
Teaching
Cumulative Planned
Actual Date Method BB/PP/ Dependencies Remarks
Unit hours Date Book
Description (page no.)
Video
37 W1,R3 PPT Online Chapter 29
Mapping EER to ODB schema ASSIGNMENT
38 W1,R3 PPT Online Chapter 29
OBJECT RELATIONAL AND NO-SQL DATABASES
Object identifier
39 PPT Online Chapter 29
Reference types W1,R3
40 PPT
W1,R3 Online Chapter 29
Row types – UDTs
(9 HOURS)
UNIT V
41 PPT
W1,R3 Online Chapter 29
User-defined routines
42 PPT
W1,R3 Online Chapter 29
Collection types
43 PPT
W1,R3 Online Chapter 29
Object Query Language
44 BB
T2/W3 888
No-SQL: CAP theorem
Document-based: MongoDB data BB
model and CRUD operations 45 T2 /W4 890 ASSIGNMENT
(Note: BB= Black Board, PP=Power Point Presentation, VIDEO = Video Lecture,T=Teaching)
TEXT BOOKS:
1.Database Systems – A Practical Approach to Design, Implementation, “Thomas M. Connolly, Carolyn E. Begg, Sixth Edition,
Global Edition, Pearson Education, 2015”.
2. Fundamentals of Database Systems,” Ramez Elmasri, Shamkant B. Navathe, 7th Edition, Pearson, 2017.
REFERENCES:
1. "Database Systems:The Complete Book", Hector Garcia-Molina, Jeffrey D Ullman, Jennifer Widom, 2nd edition, Pearson.
2. Hector Garcia-Molina, Jeffrey D Ullman, Jennifer Widom, 2nd edition, Pearson.
3. Database Systems: Design, Implementation, and Management, Carlos Coronel, Steven Morris, and Peter Rob, Ninth Edition, Cengage
learning, 2012.
PREPARED BY VERIFIED BY
APPROVED BY
DATE DATE
DATE
Syllabus Completion Report
S. No Units Planned No Actual hours From To Staff HOD
of Hours Taken Signature Signature
1 Unit-1
2 Unit-2
3 Unit-3
4 Unit-4
5 Unit-5
PREPARED BY VERIFIED BY
APPROVED BY
DATE DATE
DATE
