DEPARTMENT OF COMPUTER SCIENCE &
ENGINEERING
DATABASE MANAGEMENT SYSTEMS - PCCST402
KTU 2024 SCHEME
VIJINA P
[Link] , CSE, CETKR
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
SEMESTER 4
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
TEXT BOOK
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Course Assessment Method -(CIE: 40 marks,
ESE: 60 marks)
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Course Outcomes (COs)
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
SYLLABUS – MODULE 1
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
File System Vs DBMS: Explore What is the
Difference between File System and DBMS
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
File System
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS : Database Management System
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Disadvantages of the Traditional File Systems
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Disadvantages of the Traditional File Systems
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS (e.g., MySQL, Oracle, SQL Server)
Advantages:
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Database System Concepts and Architecture
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Introduction
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Introduction
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Introduction
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Introduction
database properties
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Introduction
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Introduction
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Introduction
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Introduction
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Simplified database system environment
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Example - UNIVERSITY Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Example - UNIVERSITY Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Example - UNIVERSITY Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Data Models, Schemas, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Data Models, Schemas, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Categories of Data Models
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
High-level or conceptual data models
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Representational (or implementation) data
models
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Representational (or implementation) data
models
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Low-level or physical data models
how
data is stored on the computer storage media
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Schemas, Instances, and Database State
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Schemas, Instances, and Database State
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Schemas, Instances, and Database State
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Schemas, Instances, and Database State
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Schemas, Instances, and Database State
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Schemas, Instances, and Database State
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture and Data
Independence
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture-Internal Level
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture-Internal Level
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture-Conceptual Level
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture-Conceptual Level
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture-External or view
level
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture-External or view
level
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture Cont..
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Schema Architecture Cont..
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Data Independence
two types
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Logical data independence
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Physical data independence
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Difference
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Database Languages and Interfaces
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
• Data definition language (DDL)
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
Storage Definition Language (SDL)
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
view definition language
(VDL)
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
Data Manipulation
Language (DML)
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
two
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Languages
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
DBMS Interfaces
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Menu-based Interfaces for Web Clients or
Browsing
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Apps for Mobile Devices
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Forms-based Interfaces
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Graphical User Interfaces.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Natural Language Interfaces
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Keyword-based Database Search.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Speech Input and Output
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Interfaces for Parametric Users
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Interfaces for the DBA
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Centralized and Client/Server Architectures for
DBMSs
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Centralized DBMSs Architecture
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Centralized DBMSs Architecture
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Centralized DBMSs Architecture
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Centralized DBMSs Architecture
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Basic Client/Server Architectures
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Basic Client/Server Architectures
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Basic Client/Server Architectures
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Basic Client/Server Architectures
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Basic Client/Server Architectures
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Two-Tier Client/Server Architectures for DBMSs
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Two-Tier Client/Server Architectures for DBMSs
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Two-Tier Client/Server Architectures for DBMSs
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Two-Tier Client/Server Architectures for DBMSs
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Two-Tier Client/Server Architectures for DBMSs
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Tier Architectures for Web Applications
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Tier Architectures for Web Applications
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Tier Architectures for Web Applications
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Three-Tier Architectures for Web Applications
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
n-Tier Architectures for Web Applications
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
PART 2
Conceptual Data Modeling and Database
Design
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Data Modeling Using the Entity–
Relationship (ER) Model
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Data Modeling Using the Entity–
Relationship (ER) Model
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Data Modeling Using the Entity–
Relationship (ER) Model
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Using High-Level Conceptual Data Models
for Database Design-Overview of Database Design
Process
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Using High-Level Conceptual Data Models
for Database Design-Overview of Database Design
Process
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Using High-Level Conceptual Data Models
for Database Design-Overview of Database Design
Process
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Using High-Level Conceptual Data Models
for Database Design-Overview of Database Design
Process
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Using High-Level Conceptual Data Models
for Database Design-Overview of Database Design
Process
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Using High-Level Conceptual Data Models
for Database Design-Overview of Database Design
Process
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
A Sample Database Application
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
A Sample Database Application
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
A Sample Database Application
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
A Sample Database Application – ER Model
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Entity Types, Entity Sets,
Attributes, and Keys
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Entities and Attributes
entity
• An entity set
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Composite versus Simple (Atomic) Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Composite versus Simple (Atomic) Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Composite versus Simple (Atomic) Attributes
Simple attribute
Composite attribute
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Single-Valued versus Multivalued Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Single-Valued versus Multivalued Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Single-Valued versus Multivalued Attributes
Single-Valued attribute
Multi-valued
attribute
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Stored versus Derived Attributes.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Stored versus Derived Attributes.
Derived attribute
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Complex Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Complex Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
NULL Values
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
NULL Values
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Entity Types and Entity Sets.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Entity Types and Entity Sets.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Entity Types and Entity Sets
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Entity Types and Entity Sets-Example
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Entity Types and Entity Sets-Example
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Entity Types and Entity Sets.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Difference Between Entity and Entity Set
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Key Attributes of an Entity Type
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Key Attributes of an Entity Type
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Key Attributes of an Entity Type
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Key Attributes of an Entity Type
no key weak entity type.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Strong Entity Type
schema
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Strong Entity Type
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Value Sets (Domains) of Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Value Sets (Domains) of Attributes
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Notations in ER Diagram
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Notations in ER Diagram
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Initial Conceptual Design of the COMPANY
Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Initial Conceptual Design of the COMPANY
Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Initial Conceptual Design of the COMPANY
Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Initial Conceptual Design of the COMPANY
Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Initial Conceptual Design of the COMPANY
Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Relationship Sets, Roles,
and Structural Constraints
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Relationship Sets,
Roles, and Structural Constraints
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Relationship Sets,
Roles, and Structural Constraints
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Sets, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Sets, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Sets, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Sets, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Sets, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Sets, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Sets, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Types, Sets, and Instances
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Degree, Role Names, and
Recursive Relationships
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Degree
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationship Degree
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Unary Relationship Set
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Binary Relationship Set
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Ternary Relationship Set
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Relationships as Attributes.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Role Names
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Recursive Relationships
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Recursive Relationships
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Recursive Relationships
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Constraints on Binary Relationship Types
two cardinality
ratio and participation.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Cardinality Ratios for Binary Relationships.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
One-to-one relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
One-to-one relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
One-to-many relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
One-to-many relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
One-to-many relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
One-to-many relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Many-to-one relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Many-to-one relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Many-to-many relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Many-to-many relationship
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Practice Questions
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Practice Questions Answers
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Participation Constraints and Existence
Dependencies
total and partial.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Total Participation
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Total Participation
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Partial Participation
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Total Participation
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Attributes of Relationship Types
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Attributes of Relationship Types
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Weak Entity Types
weak entity types.
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Weak Entity Types
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Weak Entity Types
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Difference between Strong Entity and Weak
Entity
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
COMPANY Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Refining the ER Design for the COMPANY
Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Refining the ER Design for the COMPANY
Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
Refining the ER Design for the COMPANY
Database
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram for COMPANY Schema
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 1
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 1
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 1
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 1 - Answer
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 1 - Answer
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 2
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 2 - Answer
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 3
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 3 - Answer
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR
ER Diagram : Practice question 3 - Answer
12/8/2025 Prepared By VIJINA P - AP CSE,CETKR