Scribd
Upload
367 views3 pages

Rajalakshmi Engineering College

This lesson plan provides an overview of the Database Management System course to be taught to third year B.E. C.S.E. students. It outlines the course objectives such as learning fundamental data models, SQL, relational database design, storage structures, transaction processing techniques and emerging trends. The lesson plan lists the textbook and reference books to be used. It also includes a schedule of 14 topics to be covered across 5 units, along with the relevant textbook chapters and page numbers. The faculty and HOD signatures are present to approve the lesson plan.

Uploaded by

chituuu
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
367 views3 pages

Rajalakshmi Engineering College

This lesson plan provides an overview of the Database Management System course to be taught to third year B.E. C.S.E. students. It outlines the course objectives such as learning fundamental data models, SQL, relational database design, storage structures, transaction processing techniques and emerging trends. The lesson plan lists the textbook and reference books to be used. It also includes a schedule of 14 topics to be covered across 5 units, along with the relevant textbook chapters and page numbers. The faculty and HOD signatures are present to approve the lesson plan.

Uploaded by

chituuu
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 3

RAJALAKSHMI ENGINEERING COLLEGE

Thandalam, Chennai – 602 105

LESSON PLAN

Faculty Name : P.REVATHY Code : CS11


Subject Name : DATABASE MANAGEMENT Code : CS1301
SYSTEM
Year : III Semester : V
Degree & Branch : B.E. – C.S.E. Section : A& B

Aim:

• To provide a strong foundation in database technology and an introduction to the


current trends in this field..

Objectives:
• To learn the fundamentals of data models and to conceptualize and depict a database system
using ER diagram.
• To make a study of SQL and relational database design.
• To understand the internal storage structures using different file and indexing techniques which
will help in physical DB design.
• To know the fundamental concepts of transaction processing- concurrency control techniques
and recovery procedure.
• To have an introductory knowledge about the emerging trends in the area of distributed DB- OO
DB- Data mining and Data Warehousing and XML

TEXT BOOK
1. Abraham Silberschatz, Henry F. Korth and S. Sudarshan - “Database System Concepts”, Fourth
Edition, McGraw-Hill, 2002.

Reference Book(s):
1. Ramez Elmasri and Shamkant B. Navathe, “Fundamental Database Systems”, Third Edition,
Pearson Education, 2003.

2. Raghu Ramakrishnan, “Database Management System”, Tata McGraw-Hill Publishing


Company, 2003.
3. Hector Garcia–Molina, Jeffrey D.Ullman and Jennifer Widom- “Database System
Implementation”- Pearson Education- 2000.

Sl. T / R* Book
Unit Topic(s) Page(s)
No. Book No.
Introduction, File system
1 I T/R 1/2 1-6/9-15
VS Database system

Signature of Faculty Signature of HOD


1
Reference Book(s):
2 Database System Structure T 1 16-18
3 Data Models R 1 7-11
Introduction to Network
4 R 2 917-940
Model
Introduction to Hierarchical
5 R 2 942-948
Model
6 ER Model R 1 23-40
9 Relational Model T/R 1 63-70
Relational Algebra and
10 T/R 1/2 71-100/211,299
Calculus
13 II SQL ,Data
Data Definition T/R 1/2 111-147/251
17 Integrity and security T 1 193-201
18 Relational Database Design R 1 215
19 Functional Dependences T 1 202-210
Normalization for
21 T/R 1/2 221-231/483-495
Relational DB
Record Storage ,Primary
Primary
23 III T/R 1/2 293/113
File Organization
25 Secondary Storage Devices T/R 1/2 293-300/117-126
26 Operations on Files R 2 133-134
27 Hashing Tehniques T/R 1 358-365
29 Index Structure for files
fil s T 1 339-345
30 B Tree. B+ Tree R 1/2 346-357/169-180
31 Query Processing T 1 381-412
Transaction Processing-
Introduction,
Introduction Need For
33 IV Concurrency Control. T 1 439-449
Desirable Properties of
Transaction
Serializability and
35 T 1 451-455
Schedules
Concurrency control Tech:
37 Types Of Locks- Two T/R 1 471-481
Phase Locking. Dead Lock
Time Stamp Based
38 T 1 471-481
Concurrency Control
Sl. T / R* Book
Unit Topic(s) Page(s)
No. Book No.
Recovery Tech: Immediate
39 T 1 511-524
Update,, Deferred Update
41 Shadow Paging T/R 1 525-527
Object Oriented DB-Need
42 V for Complex Data Types T 1 251-265
,OO
OO Data Model
Nested Relations. Complex
43 T 1 275-277
Types
Inheritance & Reference
45 T 1 277-300
types

Signature of Faculty Signature of HOD


2
Reference Book(s):
Distributed DB-
46 Homogenous and R 2 766-780
Heterogenous
47 XML. Structure of XML T 1/2 346/879
Querying and
49 T 1 347
Transformation
50 Data Mining&Warehousing
Mining T 702-709

• T  Text Book / R  Reference Book

Signature of Faculty Signature of HOD


3

You might also like