DBMS (DataBase Management System)

March 15, 2021

Learn DBMS

DBMS again is very important subject of computer science courses and is well asked in various placement exams both in the online tests as MCQ’s and also in Interviews for various companies. Most Data Science companies have DBMS as requirement for you to learn.

Introduction

What is Data
What is Database
What is Database Management System
File Systems vs DBMS (Why we shifted to DBMS)
Tuple
Record

Architecture and Models

DBMS Architecture
- 2 Level
- 3 Level
Need For DBMS
Data Abstraction and Data Independence
DBMS Database Models
Data Models
- Hierarchical Model
- Network Model
- Entity-relationship Model
- Relational Model
- Object-Oriented Relation DBMS

ER Models

ER Data Model Basics concepts. (Attributes, relationships, Entities)
Entity-Relationship Model Advanced
- Attribute
- Key Attribute
- Composite Attribute
- Multivalued Attribute
- Derived Attribute
Cardinality
- Cardinality Ratio
- One to One
- One to Many
- Many to One
- Many to Many
Relationships
- Types of Relationship
- Unary Relationship
- Binary Relationship
- n – ary Relationship
- Recursive Relationship
- Ternary Relationship
Relationship – Cardinality
Participation Constraint
Weak Entity and Strong Entity
Generalization Specialization and Aggregation
- Generalization
- Specialization
- Aggregation

Relational Database Model

Codd’s Rule
RDBMS
Relational Data Model
Keys in the Relational Model
Keys in DBMS
- Primary Key in DBMS | Oracle | SQL
- Foreign Key in DBMS | Oracle | SQL
- Candidate Key in DBMS | Oracle | SQL
- Super Key in DBMS | Oracle | SQL
- Alternate Key in DBMS | Oracle | SQL
- Composite Key in DBMS | Oracle | SQL
- Non-Prime Attribute
SQL Constraints
- Default in DBMS | Oracle | SQL
- Not Null in DBMS | Oracle | SQL
- Unique in DBMS | Oracle | SQL
- Check-in DBMS | Oracle | SQL
- Key Constraints in DBMS | Oracle | SQL
- Domain constraints in DBMS | Oracle | SQL
- Mapping constraints
ER to Relational Model Conversion

Relational Calculus

To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.

Relational Algebra

This topic is of prime importance in DBMS since it is a little tricky to grasp. These questions are often found in the semester exams and technical rounds of various companies.

Functional Dependencies

To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.

Functional Dependencies
Attribute Closure
Equivalence of Functional Dependencies
Canonical Cover

Normalisation

Introduction Normalisation
Normal Forms
- 1NF Form
- 2NF Form
- 3NF Form
- Boyce-Codd Normal Form
- 4NF
- 5NF
Joins in DBMS | SQL
- Inner Joins in DBMS | SQL
- Outer Join in DBMS | SQL
- Left Join in DBMS | SQL
- Right Join in DBMS | SQL
Dependency Preserving Decomposition
Lossless Join Decomposition
Lossless Join and Dependency Preserving Decomposition

Transaction Control and B Trees

Transactions and Concurrency Control :
- Deadlock in DBMS
- ACID Properties in DBMS | Oracle | SQL
- Concurrency Control Protocols – Lock-Based Protocol
- Conflict Serializability
- View Serializability
- Recoverability of Schedules
Indexing, B and B+ trees :

DBMS -HASHING

SQL

To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.

Predicate in DBMS | Oracle | Pl/SQL
SQL -Operators in DBMS | Oracle | Pl/SQL
SQL- Expressions in DBMS | Oracle | Pl/SQL
CREATE Table in DBMS | Oracle | Pl/SQL
ALTER table in DBMS | Oracle | Pl/SQL
DROP/TRUNCATE/RENAME table in DBMS | Oracle | Pl/SQL
Tuple/Record in DBMS | Oracle | Pl/SQL

Queries

To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.

SELECT in DBMS | Oracle | SQL
INSERT in DBMS | Oracle | SQL
WHERE in DBMS | Oracle | SQL
AND & OR in DBMS | Oracle | SQL
UPDATE in DBMS | Oracle | SQL
DELETE in DBMS | Oracle | SQL
LIKE in DBMS | Oracle | SQL
ORDER BY in DBMS | Oracle | SQL
GROUP BY in DBMS | Oracle | SQL
DISTINCT in DBMS | Oracle | SQL
ROW in DBMS | Oracle | SQL
TRUNCATE in DBMS | Oracle | SQL
RENAME in DBMS | Oracle | SQL
DROP in DBMS | Oracle | SQL

SQL Set Operations and Advanced SQL

To learn better you have to start somewhere so following are the basics of DBMS that will help you clear your concepts about what DBMS comprises of.

SQL SET OPERATIONS IN DBMS
- UNION-UNION ALL
- INTERSECT
- MINUS
ADVANCED SQL
- NULL in DBMS | Oracle | SQL
- USING VIEWS in DBMS | Oracle | SQL
- INJECTION in DBMS | Oracle | SQL
- HANDLING DUPLICATES in DBMS | Oracle | SQL

7 comments on “DBMS (DataBase Management System)”

Ramesh
It is an Really very good site seen so far ……Very helpful material thank you Prepinsta

3

Log in to Reply
Ritika
PrepInsta has helped me understand basics of cse big time that I could not understand by purchasing multiple courses. Thanks so much, Kudos to PrepInsta!

5

Log in to Reply

HelpPrepInsta
Thank you for your appreciation and also we want you to know that we are more than happy to help you and serve you better!!!

1

Log in to Reply

Surya
Easy to understand the concepts..
Thankyou prepinsta

1

Log in to Reply
purvi
Really very good site seen so far ……Very helpful material thank u Prepinsta

9

Log in to Reply
Jaideep
I need to say this,Prepinsta is the best site on internet if you are looking for technical content which is trustworthy and without any misleading and confusing stuff.

18

Log in to Reply