DBMS 4TH Sem Course File

Sri Devaraj Urs Educational Trust (R.), Tamaka, Kolar.
R. L. JALAPPA INSTITUTE OF TECHNOLOGY

Department of CS&E(Artificial Intelligence and
Machine Learning)
(Approved by AICTE, New Delhi & Affiliated to VTU, Belagavi)
Kodigehalli, Doddaballapur- 561 203
Phone: 080-27626800/801 Fax: 080-27625380 website: www.rljit.in
COURSE PLAN
COURSE INFORMATION SHEET
NAME OF THE COURSE DATABASE MANAGEMENT SYSTEM
SUBJECT CODE BCS403
NAME OF THE COURSE FACULTY SHRUTHI N
DESIGNATION ASSISTANT PROFESSOR
ACADEMIC YEAR 2023 - 24
SEMESTER / SECTION 4TH SEMESTER A
Page 1 of 15
Machine Learning)
NO. OF CREDITS 4
Page 2 of 15
Machine Learning)
INSTITUTE VISION INSTITUTE MISSION
“To be a premier Institution by imparting quality M1: To Provide an outstanding Teaching,

Technical education, Professional Training and Learning and Research environment through
Research”. Innovative Practices in Quality Education.
M2: Develop Leaders with high level of

Professionalism to have career in the Industry,
Zeal for Higher Education, and focus on
Entrepreneurial and Societal activities.
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING (ARTIFICIAL INTELLIGENCE

AND MACHINE LEARNING)
DEPARTMENT VISION DEPARTMENT MISSION
M1: To craft the students with Novel and Intellectual
To empower the students with
skills to capability in the field of Artificial Intelligence
knowledge and skills to develop the
and Machine Learning.
competency in the field of Artificial
M2: To train the students to have Professional career in
Intelligence and Machine Learning.
the field of AI and ML and zeal for Higher Studies and
Research.
PROGRAMME EDUCATIONAL OBJECTIVES (PEO)

PEO1: Graduates will have Prospective careers in the field of AI and ML.
PEO2: Graduates will have good Leadership Qualities, Self-Learning abilities and zeal for higher
studies and Research.
PEO3: Graduates will follow Ethical Practices and exhibit high level of professionalism by
participating and addressing Technical, Business and Environmental challenges.
Page 3 of 15
Machine Learning)
PROGRAMME SPECIFIC OUTCOMES (PSO)

PSO1: Students will have the ability to understand analyse and demonstrate the knowledge of
Human cognition, Artificial Intelligence, Machine Learning in terms of real-world problems to meet
the challenges of future.
PSO2: Students will have the knowledge of software, Hardware, Algorithms, Modelling
Networking and Application Development.
PSO3: Students will have the ability to develop computational knowledge using Innovative tools
and techniques to solve problems in the areas related to Machine learning and Artificial
Intelligence.
PROGRAMME OUTCOMES (PO)

1. Engineering knowledge: Apply the knowledge of mathematics, science, engineering fundamentals,
and an engineering specialization to the solution of complex engineering problems.
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.
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.
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.
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.
6. The engineer and society: Apply reasoning informed by the contextual knowledge to assess societal,
Page 4 of 15
Machine Learning)
health, safety, legal and cultural issues and the consequent responsibilities relevant to the professional
engineering practice.
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.
8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms of
the engineering practice.
9. Individual and teamwork: Function effectively as an individual, and as a member or leader in
diverse teams, and in multidisciplinary settings.
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.
11. Project management and finance: Demonstrate knowledge and understanding of the Engineering
and management principles and apply these to one’s own work, as a member and leader in a team, to
manage projects and in multidisciplinary environments.
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.
WEIGHTAGE OF MARKS (2022 SCHEME)

Component Marks
Internal Exam
Continuous Internal Evaluation (CIE) I, II, III : 15% 15

Assignments : 10% 10
Integrated Lab : 25% 25
External Exam
Semester End Examination (SEE) : 50% 50

Total 100
Page 5 of 15
Machine Learning)
COURSE INFORMATION SHEET
COURSE NAME / CODE DATABASE MANAGEMENT SYSTEM (BCS403)

B.E / CSE (ARTIFICIAL INTELLIGENCE AND MACHINE
DEGREE / BRANCH
LEARNING)
COURSE CREDIT 4
COURSE CATEGORY CORE SUBJECT

COURSE CONTACT DETAILS
FACULTY NAME MOBILE E-MAIL
COURSE FACULTY
CONTACT: SHRUTHI N
shrurhin@rljit.in
8197859211
HEAD OF THE
DR. MANJUNATHA B N
DEPARTMENT:
1. COURSE DESCRIPTION:
Database is a collection of related data and data is a collection of facts and figures that can be processed
to produce information. Mostly data represents recordable facts. Data aids in producing information, which is
based on facts. For example, if we have data about marks obtained by all students, we can then conclude about
toppers and average marks. A database management system stores data in such a way that it becomes easier to
retrieve, manipulate, and produce information.
Page 6 of 15
Machine Learning)
2. COURSE OBJECTIVES:
The Learning Objectives of Database Management System are such that the student will.
CO1: Understand structure of data and various types of Data Models
CO2: Study how to populate the data.
CO3: Know about manipulation of data within the database.
CO4: Appreciate allowing of multiple users at the same time with authentication.
CO5: Acquire awareness about Integrity and optimization of data.
3. COURSE OUTCOMES (CO):
At the end of the course, student would be able to demonstrate the knowledge and ability to
CO1: Implement and manipulate the computational data.
CO2: Identify and apply optimization method on computational data.
CO3: Able to demonstrate the transaction and transaction processing.
CO3: Able to demonstrate architectural view of data.
CO4: Able to develop an application, store, update and manipulate data.
CO5: Able to judge the complexity of develop a database project.
4. MAPPING OF COS WITH POS & PSOS:
Cos POs PSOs

PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3 PSO4
Page 7 of 15
Machine Learning)
CO1
1 1 1
CO2
2 2 2
CO3
3 3 3
CO4
2 3 2
CO5
3 3 3
3- Strong Correlation 2- Medium Correlation 1 – Low Correlation
5. Course Delivery and Teaching Methodology used.
From To
Page 8 of 15
Machine Learning)
1 22-4-2024 4-5-2024 MODULE-1 CO1

Introduction to Databases: Introduction
and Characteristics of database approach ClassRoom
Lecture (Chalk
and Advantages of using the DBMS Based Lecture) /
PPT presentation
approach and History of database
applications and Data Models and Schemas
and Instances and Three schema
architecture and data independence and
database languages and interfaces and The
Database System environment
2 6-5-2024 18-5-2024 Entity types and Entity sets and structural CO1 ClassRoom
Lecture (Chalk
constraints and Weak entity types and ER
Based Lecture) /
diagrams and Specialization and PPT presentation
Generalization
3 20-5-2024 1-6-2024 MODULE-2 CO2 ClassRoom
Relational Model: Relational Model Lecture (Chalk
Based Lecture) /
Concepts and Relational Model Constraints
PPT presentation
and relational database schemas and Update
operations and transactions and dealing
with constraint violations
4 3-6-2024 15-6-2024 Relational Algebra: CO2 ClassRoom
Lecture (Chalk
Unary and Binary relational operations and
Based Lecture) /
additional relational operations Examples of PPT presentation
Queries in relational algebra and Relational
Database Design using ER-to-Relational
mapping
Page 9 of 15
Machine Learning)

Normalization: Database Design Theory Lecture (Chalk
Based Lecture) /
and Introduction to Normalization using
PPT presentation
Functional and Multivalued Dependencies
and Informal design guidelines for relation
schema and Functional Dependencies
Normal Forms based on Primary Keys
Second and Third Normal Forms Boyce
Codd Normal Form Multivalued
Dependency and Fourth Normal Form Join
Dependencies and Fifth Normal Form
6 1-7-2024 13-7-2024 SQL: SQL data definition and data types, CO3 ClassRoom
Lecture (Chalk
Schema change statements in SQL,
Based Lecture) /
specifying constraints in SQL, retrieval PPT presentation
queries in SQL, INSERT, DELETE, and
UPDATE statements in SQL, Additional
features of SQL.
SQL: Advanced Queries: More complex Lecture (Chalk
Based Lecture) /
SQL retrieval queries, Specifying
PPT presentation
constraints as assertions and action triggers,
Views in SQL.
8 29-7-2024 10-7-2024 Transaction Processing: Introduction to CO4 ClassRoom
Lecture (Chalk
Transaction Processing, Transaction and
Based Lecture) /
System concepts, Desirable properties of PPT presentation
Transactions, Characterizing schedules
based on recoverability, Characterizing
schedules based on Serializability,
Page 10 of 15
Machine Learning)
Transaction support in SQL.

Lecture (Chalk
Concurrency Control in Databases: Two-
Based Lecture) /
phase locking techniques for Concurrency PPT presentation
control, Concurrency control based on
Timestamp ordering, Multiversion
Concurrency control techniques, Validation
Concurrency control techniques,
Granularity of Data items and Multiple
Granularity Locking.
10 26-7-2024 7-8-2024 NOSQL Databases and Big Data Storage CO5 ClassRoom
Lecture (Chalk
Systems: Introduction to NOSQL Systems,
Based Lecture) /
The CAP Theorem, Document-Based PPT presentation
NOSQL Systems and MongoDB, NOSQL
Key-Value Stores, Column-Based or Wide
Column NOSQL Systems, NOSQL Graph
Databases and Neo4j
Abbreviation Teaching Methodology

L Classroom Lecture (Chalk Based Lecture)
Web-Facilitated Course Delivery/ Flipped Class Lecture/ Multimedia Lecture/
EL
Animation
SS Student Seminar
Page 11 of 15
Machine Learning)
T Tutorial/ Case-Study/ Scenario

P Practical/ Laboratory Demonstration/ Model Demonstration/ Simulation
GD Group Discussion/ Debate/ Role Play
GL Guest Lecture/ Workshop/Interview with Experts/ Webinars
IV Industrial Visit/ Field Trip
PJ Project Design/ Project Demonstration/Literature Survey
6. Text Books and Reference Books:
Sl. Book Name Author(s) Publisher Year, Edition
Textbook
Database management Ramakrishnan, and McGraw Hill 3rd Edition, 2014.
s 1.
systems Gehrke
Fundamentals of 7th Edition, 2017.

Database Systems.
Reference Pearson.
Ramez Elmasri and
Books 2.
Shamkant B.
7. Gaps in the Syllabus - To Meet Industry/Profession Requirements:
SL. Description Proposed Actions Relevance with Relevance with

NO POs PSOs
1.
Mongo DB Lab Sessions PO4, PO5. PSO2
Page 12 of 15
Machine Learning)
8. Topics Beyond Syllabus /Advanced Topics / Design:
Sl. No. Topics Beyond the Syllabus Relevance with Relevance with Relevance with PSOs
COs POs
1 Familiarization of CO3,CO4,CO5 PO4,PO5. PSO2

ORACLE
9. Assignment Topics relevance with POs and PSOs:
SL Assignment Topics Relevance Relevance

NO with POs with PSOs
1. MODULE-1 PO4,PO5. PSO2
2. MODULE-2, MODULE-3 PO4, PO5. PSO2
3. MODULE-4, MODULE-5 PO4, PO5. PSO2
Page 13 of 15
Machine Learning)
10. Web Resources:
Unit No Topic Web-link
1 to 5 DATABASE Introduction of DBMS (Database Management System) - Set 1 -

MANAGEMENT GeeksforGeeks
SYSTEM
11. Continuous Internal Evaluation (CIE) Portions and Date:
Continuous Internal Evaluation (CIE) Modules Exam Dates

Continuous Internal Evaluation (CIE) - I Module -1 27-5-2024
Continuous Internal Evaluation (CIE) - II Module-2 and Module-3 26-6-2024
Continuous Internal Evaluation (CIE) - III Module-4 and Module-5 25-7-2024
Semester End Examination All Modules (100%) 7-8-2024
12. Weightage for Direct and Indirect assessment tools
Assessment Tools Percentage of Weightage

Thrice
(Average of all
Direct Assessment Tools Internal
the three tests will
assessment tests - CIE
be considered)
Max Marks - 15
Direct Assessment Tools Assignment component Assignment methods twice
Max Marks - 10
Standard Once at the End
Direct Assessment Tools examination of course,
covering full Max Marks – 100M
syllabus Scaled to – 50M
Page 14 of 15
Machine Learning)
Students feedback Once during the

Indirect Assessment Tools about the Delivery Course/Semester
of the course
Verified by Approved by HoD

Prepared by Department IQAC Coordinator
Page 15 of 15

DBMS 4TH Sem Course File

Uploaded by

Copyright:

Available Formats

DBMS 4TH Sem Course File

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

DBMS 4TH Sem Course File

Uploaded by

Copyright:

Available Formats

Sri Devaraj Urs Educational Trust (R.), Tamaka, Kolar.

R. L. JALAPPA INSTITUTE OF TECHNOLOGY

COURSE INFORMATION SHEET

NAME OF THE COURSE DATABASE MANAGEMENT SYSTEM

SUBJECT CODE BCS403

NAME OF THE COURSE FACULTY SHRUTHI N

DESIGNATION ASSISTANT PROFESSOR

ACADEMIC YEAR 2023 - 24

SEMESTER / SECTION 4TH SEMESTER A

INSTITUTE VISION INSTITUTE MISSION

“To be a premier Institution by imparting quality M1: To Provide an outstanding Teaching,

M2: Develop Leaders with high level of

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING (ARTIFICIAL INTELLIGENCE

PROGRAMME EDUCATIONAL OBJECTIVES (PEO)

PROGRAMME SPECIFIC OUTCOMES (PSO)

PROGRAMME OUTCOMES (PO)

WEIGHTAGE OF MARKS (2022 SCHEME)

Continuous Internal Evaluation (CIE) I, II, III : 15% 15

Semester End Examination (SEE) : 50% 50

COURSE INFORMATION SHEET

COURSE NAME / CODE DATABASE MANAGEMENT SYSTEM (BCS403)

COURSE CATEGORY CORE SUBJECT

CO1: Understand structure of data and various types of Data Models

CO2: Study how to populate the data.

CO3: Know about manipulation of data within the database.

CO5: Acquire awareness about Integrity and optimization of data.

3. COURSE OUTCOMES (CO):

CO1: Implement and manipulate the computational data.

CO2: Identify and apply optimization method on computational data.

CO3: Able to demonstrate the transaction and transaction processing.

CO3: Able to demonstrate architectural view of data.

CO4: Able to develop an application, store, update and manipulate data.

CO5: Able to judge the complexity of develop a database project.

4. MAPPING OF COS WITH POS & PSOS:

Cos POs PSOs

3- Strong Correlation 2- Medium Correlation 1 – Low Correlation

5. Course Delivery and Teaching Methodology used.

1 22-4-2024 4-5-2024 MODULE-1 CO1

5 17-6-2024 29-6-2024 MODULE-3 CO3 ClassRoom

Transaction support in SQL.

Abbreviation Teaching Methodology

T Tutorial/ Case-Study/ Scenario

6. Text Books and Reference Books:

Sl. Book Name Author(s) Publisher Year, Edition

Fundamentals of 7th Edition, 2017.

7. Gaps in the Syllabus - To Meet Industry/Profession Requirements:

SL. Description Proposed Actions Relevance with Relevance with

Mongo DB Lab Sessions PO4, PO5. PSO2

8. Topics Beyond Syllabus /Advanced Topics / Design:

1 Familiarization of CO3,CO4,CO5 PO4,PO5. PSO2

9. Assignment Topics relevance with POs and PSOs:

SL Assignment Topics Relevance Relevance

1. MODULE-1 PO4,PO5. PSO2

2. MODULE-2, MODULE-3 PO4, PO5. PSO2

3. MODULE-4, MODULE-5 PO4, PO5. PSO2

10. Web Resources:

Unit No Topic Web-link

1 to 5 DATABASE Introduction of DBMS (Database Management System) - Set 1 -

11. Continuous Internal Evaluation (CIE) Portions and Date: