DEPARTMENT OF ELECTRONICS & COMMUNICATIONS

ENGINEERING

COURSE HANDOUT

PART-A
Name of Course Instructor : Dr. Kavuluru VenuGopal
Course Name & Code : DATABASE MANAGEMENT SYSTEM CONCEPTS & 20ITM3
L-T-P Structure : 3-1-0 Credits : 4
Program/Sem/Sec : B. Tech (Minor)., ASE, ECE, EEE,MECH A. Y : 2024-24

PREREQUISITE: Elementary set theory, concepts of relations and functions, propositional logic data
structures (trees, Graphs, dictionaries) & File Concepts.
COURSE EDUCATIONAL OBJECTIVES (CEOs): This course enables the students to
know about DBMS basic concepts, Database Languages, Database Design, Normalization process and
Transaction processing and Indexing.

COURSE OUTCOMES (COs): At the end of the course, students are able to

CO 1 Demonstrate the Basic Components of Database Management System. (Understand -L2)

CO 2 Design Entity-Relationship Diagrams for different applications. (Apply –L3)
CO 3 Examine the relational data model and various constraints. (Apply- L3)
CO 4 Demonstrate Structured Query Language languages (SQL) to manage relational databases
and perform various operations on the data. (Apply- L3)
CO 5 Employ principles of normalization for effective database design & transaction
management. (Apply- L3)

COURSE ARTICULATION MATRIX (Correlation between COs, POs & PSOs):

COs PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3
1 1 2 - - - - - - - - - 3 2 2
CO1
3 3 - - - - - - - - - - 2 3 2
CO2
3 2 - - - - - - - - - - 2 3 2
CO3
2 1 2 - - - - - - - - - 3 2 3
CO4
2 1 2 - - - - - - - - - 2 3 3
CO5

Note: Enter Correlation Levels 1 or 2 or 3. If there is no correlation, -

1- Slight (Low), 2 Moderate (Medium), 3 - Substantial (High)
TEXT BOOKS :
T1

Hill, 6th edition, 2009.

T2 RamezElmasri, Shamkanth
Wesley, 6th edition, 2010.

REFERENCE BOOKS:
R1 Raghu Ramakrishna, Johannes
3rd edition, 2000.
R2
R3
New Delhi, 2005.

PART-B

COURSE DELIVERY PLAN (LESSON PLAN):

UNIT-I: Introduction
No. of Tentative Actual Teaching HOD
S.No. Topics to be covered Classes Date of Date Learning Sign
Required Completion of Methods Weekly
Completion
1. Introduction to Course and COs 2 3-07-2024 TLM1,2
Introduction, An overview of
2. database management 2 4.07. 2024 TLM1,2
system, Database
system Vs file system
Database system concepts
3. and architecture, Data 2 10.07. 2024 TLM1,2
models
schema and instances
Data independence and database
4. language and interfaces 2 11.07. 2024 TLM1,2
Data definitions language, DML,
5. Overall Database Structure 2 18-07. 2024 TLM1,2
Revision on Unit-1 24.07. 2024
6. 2 TLM1,2
No. of classes required to complete UNIT-I: 10 No. of classes taken:

UNIT-II: Entity Relationship Model

No. of Tentative Actual Teaching HOD
S.No. Topics to be covered Classes Date of Date of Learning Sign
Required Completion Completion Methods Weekly
ER model concepts - attributes, 25.07. 2024 TLM1,2
1. 2
entity, Relationships
notation for ER diagram, Mapping 31.07. 2024 TLM1,2
2. 2
constraints
Relationships of higher degree, 01.08. 2024 TLM1,2
3. keys -Concepts of Super Key, 2
and identity key, primary key
07.08. 2024 TLM1,2
4. Generalization,Aggregation 2
Reduction of ER diagrams to 14.08. 2024 TLM1,2
5. 2
tables
Revision on Unit - II 21.08. 2024 TLM1,2
6. 2
No. of classes required to complete UNIT-II: 12 No. of classes taken:
UNIT-III: Relational Data Model:

No. of Tentative Actual Teaching HOD

S.No. Topics to be covered Classes Date of Date of Learning Sign
Required Completion Completion Methods Weekly
Relational data model 22.08. 2024 TLM1,2
1. 2
concepts
Integrity constraints: entity 28.08. 2024 TLM1,2
2. integrity, referential integrity,
2
Keys constraints, Domain
constraints
referential integrity 29.08. 2024 TLM1,2
3. 2
Keys constraints 11.09. 2024 TLM1,2
4. 2
Domain constraints 12.09. 2024 TLM1,2
5. 2
Relational Algebra 18.09. 2024 TLM1,2
6. 2
Revision of UNIT-3 & 19.09. 2024 TLM1,2
7. 2
Assignment-I
No. of classes required to complete UNIT-III: 14 No. of classes taken:
I MID EXAMINATIONS 28/08/ 2024 TO 02/09/ 2024

UNIT-IV: Introduction to SQL

No. of Tentative Actual Teaching HOD

S.No. Topics to be covered Classes Date of Date of Learning Sign
Required Completion Completion Methods Weekly
Characteristics of SQL, 15.09. 2024 TLM1,2
1. 2
Advantage of SQL
25.09. 2024 TLM1,2
2. SQL Data types and Literals 2
Insert, Update and Delete 26.09. 2024 TLM1,2
3. 2
Operations
02.10. 2024 TLM1,2
4. Tables, Views and Indexes 2
Nested Queries, Aggregate 09.10. 2024 TLM1,2
5. 2
Functions
16.10. 2024 TLM1,2
6. Joins, Unions, Intersection, Minus. 2
Revision of Unit-4 17.10. 2024 TLM1,2
7. 1
No. of classes required to complete UNIT-IV: 14 No. of classes taken:
 Unit -V : Normalization
No. of Tentative Actual Teaching HOD
S.No. Topics to be covered Classes Date of Date of Learning Sign
Required Completion Completion Methods Weekly

17.10. 2024 TLM1,2

1. Functional Dependencies 2
23.10. 2024 TLM1,2
2. Normal Forms - First, Second 2
23.10. 2024 TLM1,2
3. Third Normal Forms, BCNF. 1
Transaction System, Testing of 24.10. 2024 TLM1,2
4. 1
Serializability
Serializability of Schedules, 24.10. 2024 TLM1,2
5. Conflict 1
& View Serializability
30.10. 2024 TLM1,2
6. Recoverability, Deadlock Handling. 1
Revision of UNIT-5 & 30.10. 2024 TLM1,2
7. Assignment-II 2
No. of classes required to complete UNIT-V: 7 No. of classes taken:

Teaching Learning Methods

TLM1 Chalk and Talk TLM4 Demonstration (Lab/Field Visit)
TLM1,2 PPT TLM5 ICT (NPTEL/Swayam Prabha/MOOCS)
TLM3 Tutorial TLM6 Group Discussion/Project

PART-C
Evaluation Task Marks

Assignment – I(Units-I, II & UNIT-III (Half of the Syllabus)) A1=5

I – DescriptiveExamination (Units-I, II & UNIT-III (Half of the Syllabus)) M1=15

I – QuizExamination (Units-I, II & UNIT-III (Half of the Syllabus)) Q1=10

Assignment – II(Unit-III (Remaining Half of the Syllabus), IV & V) A2=5

II – Descriptive Examination (UNIT-III (Remaining Half of the Syllabus), IV & V) M2=15

II – Quiz Examination (UNIT-III (Remaining Half of the Syllabus), IV & V) Q2=10

Mid Marks =80% of Max ((M1+Q1+A1), (M2+Q2+A2)) + 20% of Min ((M1+Q1+A1),

M=30
(M2+Q2+A2))

Cumulative Internal Examination (CIE): M 30

Semester End Examination (SEE) 70

Total Marks = CIE + SEE 100

 PART-D
PROGRAMME OUTCOMES (POs):

PO 1 Engineering knowledge: Apply the knowledge of mathematics, science, engineering

fundamentals, and an engineering specialization to the solution of complex engineering
problems.
PO 2 Problem analysis: Identify, formulate, review research literature, and analyze complex
engineering problems reaching substantiated conclusions using first principles of mathematics,
natural sciences, and engineering sciences.
PO 3 Design/development of solutions: Design solutions for complex engineering problems and
design system components or processes that meet the specified needs with appropriate
consideration for the public health and safety, and the cultural, societal, and environmental
considerations.
PO 4 Conduct investigations of complex problems: Use research-based knowledge and research
methods including design of experiments, analysis and interpretation of data, and synthesis of the
information to provide valid conclusions.
PO 5 Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern
engineering and IT tools including prediction and modelling to complex engineering activities
with an understanding of the limitations
PO 6 The engineer and society: Apply reasoning informed by the contextual knowledge to assess
societal, health, safety, legal and cultural issues and the consequent responsibilities relevant to
the professional engineering practice
PO 7 Environment and sustainability: Understand the impact of the professional engineering
solutions in societal and environmental contexts, and demonstrate the knowledge of, and need for
sustainable development.
PO 8 Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms
of the engineering practice.
PO 9 Individual and team work: Function effectively as an individual, and as a member or leader in
diverse teams, and in multidisciplinary settings.
PO 10 Communication: Communicate effectively on complex engineering activities with the
engineering community and with society at large, such as, being able to comprehend and write
effective reports and design documentation, make effective presentations, and give and receive
clear instructions.
PO 11 Project management and finance: Demonstrate knowledge and understanding of the

leader in a team, to manage projects and in multidisciplinary environments.

PO 12 Life-long learning: Recognize the need for, and have the preparation and ability to engage in
independent and life-long learning in the broadest context of technological change.

PROGRAMME SPECIFIC OUTCOMES (PSOs):

PSO 1 Organize, Analyze and Interpret the data to extract meaningful conclusions.
PSO 2
Design, Implement and Evaluate a computer-based system to meet desired needs.
PSO 3 Develop IT application services with the help of different current Engineering tools.

Course Instructor Course Coordinator Module Coordinator HOD

Dr. Kavuluru Venu Gopal Dr. Kavuluru Venu Gopal Dr. B.Srinivasa Rao Dr.B.Srinivasa Rao