Academic Year: 2024-2025 Semester: EVEN
Name of Staff : Mr. B. Yuvaraj
Designation & Dept. Assistant Professor /CSBS
ACS108- DATA BASE MANAGEMENT
Sub Code &Name: LTPC: 3 0 0 3
SYSTEM
Year/Sem/ Branch/ Section: II/III/AI&DS/A
No. Cumulativ
Reference Teaching Aids
S. Date of. e
Topic covered/Revision Book Page (LCD/ OHB/
No. Planned Peri No. of.
No BB)
ods Periods
UNIT I RELATIONAL DATABASES
1
Purpose of Database System T1 (3-5) 1 1 BB
18/06/2025
2
Views of data T1 (5-8) 1 2 BB
19/06/2025
3
Data Models T2 (30-33) 1 3 BB
20/06/2025
4
Database System Architecture T2 (33-35) 1 4 BB
23/06/2025
Introduction to relational databases -
5 24/06/2025 Relational Model T1 (37-41) 1 5 LCD
25/06/2025 Relational model keys
6 T1 (42-45) 1 6 LCD
26/06/2025 Relational Algebra
7 T1 (46-55) 1 7 LCD
27/06/2025 SQL fundamentals
8 T1 75-93 1 8 LCD
Advanced SQL features- Embedded
9 SQL T1 (134-137) 1 9 LCD
30/06/2025
01/07/2025 Dynamic SQL
10 T1 (137-145) 1 10 LCD
UNIT II DATABASE DESIGN
03/07/2025 Entity-Relationship model
11 T1 (204-210) 1 11 LCD
04/07/2025 E-R Diagrams
12 T1 (214-220) 1 12 BB
Enhanced-ER Model BB
13 T2 (103-131) 1 13
09/07/2025
ER-to-Relational Mapping ,Functional
T2 (226-234) LCD
14 10/07/2025 Dependencies T2 (349-357)
1 14
Non-loss Decomposition-Dependency
T1 (285-288) BB
15 11/07/2025 Preservation T2 (360-366)
1 15
12/07/2025 First, Second, Third Normal Forms
16 T2 (360-366) 1 16 LCD
Boyce/Codd Normal Form – Multi-
17
valued Dependencies and Fourth T2 (370-372)
1 17 BB
Normal Form T2 (396-404)
14/07/2025
Join Dependencies and Fifth Normal
18 15/07/2025 Form T2 (404-405) 1 18 LCD
16/07/2
UNIT III ADVANCED TOPICS 2
17/07/2025 Distributed Databases: Architecture T1 (783-786)
19 1 19 BB
18/07/2025 NOSQL Databases T1 (834-837)
20 1 20 BB
19/07/2025 CAP Theorem T2 (703-705)
21 1 21 BB
Access control based on privileges T2 (711-719) LCD
22 1 22
21/07/2025
21/07/2025 SQL Injection T2 (730-757) LCD
23 1 23
21/07/2025 Statistical Database security T2 (940-958) LCD
24 1 24
22/07/2025 Flow control T1 (773-776) LCD
25 1 25
Encryption and Public Key LCD
T1 (776-779)
26 22/07/2025 infrastructures 1 26
26/07/2
UNIT IV TRANSACTIONS 2
Transaction Concepts , ACID Properties T1 (609-612) LCD
27 T2 (621-622)
1 27
23/07/2025 Schedules LCD
28 T1 (617-620) 1 28
23/07/2025 Serializability LCD
29 T1 (620-625) 1 29
Concurrency Control – Need for LCD
30 Concurrency T1 (635-640) 1 30
28/07/2025
29/07/2025 Locking Protocols – Two Phase Locking LCD
31 T1 (640-643) 1 31
30/07/2025 Deadlock LCD
32 T1 (659-664) 1 32
31/07/2025 Transaction Recovery LCD
33 T1 (626-627) 1 33
31/07/2025 Save Points – Isolation Levels LCD
34 T1 (627-628) 1 34
LCD
SQL Facilities for Concurrency and
35 Recovery T1 (664-667) 1 35
13/08/2025
14/08/2
UNIT V IMPLEMENTATION TECHNIQUES 2
T1( 450- LCD
36 15/08/2025 RAID. 458) 1 36
File Organization T1 (464-468) LCD
37 1 37
Organization of Records in Files T1 (468-471) LCD
38 1 38
Indexing and Hashing –Ordered Indices LCD
T1 (481-488)
39 01/08/2025 – 1 39
02/08/2025 B+ tree Index Files T1 (489-501) LCD
40 1 40
B tree Index Files T1 (501-502) LCD
41 1 41
11/08/2025
T1 (506-511) LCD
42
Static Hashing – Dynamic Hashing 1 42
12/08/2025 T1 (511-517)
Query Processing Overview T1 (531-533) LCD
43 1 43
16/08/2025
Algorithms for SELECT and JOIN LCD
T1 (534-539)
44 17/08/2025 operations T1 (542-554)
1 44
Query optimization using Heuristics and LCD
T1 (588-591)
45 18/08/2025 Cost Estimation 1 45
TEXT BOOKS: 1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System
Concepts”, Seventh Edition, McGraw Hill, 2020. 2. Ramez Elmasri, Shamkant B. Navathe,
“Fundamentals of Database Systems”, Seventh Edition, Pearson Education, 2017
REFERENCES: 1. C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”,
Eighth Edition, Pearson Education, 2006.
Prepared By Verified by Approved By
Mr. B. Yuvaraj
HOD/CSBS PRINCIPAL
Assistant Professor /CSBS
