Easy
Explanation
Home
About
Course
YouTube
Notices
NEC License Exam
Blog
News
Engineering Project
Home
About
Courses
Notice
NEC License Exam
Blog
News
DATABASE MANAGEMENT SYSTEM
INTRODUCTION
Introduction And Application
Concept And Evolution Of Database
Data Independence And Data Abstraction
Schema And Instance
Concept Of Dml, Ddl And Dcl
Database Architecture
Database User
Practice Question Dbms
DATA MODELS
Logical, Physical And Conceptual
E-R Model
Entities And Entities Sets
Relationship And Relationship Sets
Strong And Weak Entity Sets
Attributes And Keys
E-R Diagram
Alternate Data Model (Hierarchical, Network, Graph)
Er Diagram-Solved Question
Relational Model
Er Diagram To Table Conversion Rules
RELATIONAL LANGUAGE AND RELATIONAL MODEL
Introduction To Sql
Features Of Sql
Queries And Sub Queries
Set Operations
Relations (Joined And Derived)
Queries Under Ddl And Dml Commands
Embedded Sql
Views
Relational Algebra
Database Modification
Qbe And Domain Relational Calculus
Sql Queries Practice Questions
Relational Algebra Practice Question
DATABASE CONSTRAINTS AND NORMALIZATION
Integrity Constraints And Domain Constraints
Assertions And Triggering
Functional Dependencies
Multi-Valued And Joined Dependencies
Different Normal Forms (1st, 2nd, 3rd, Bcnf, Dknf)
Closure Properties In Dbms
Lossy And Lossless Join In Dbms
FILE STRUCTURE AND HASHING
Records Organizations
Disks And Storage
Remote Backup System
Raid
Hashing In Dbms
Indexing In Dbms
B+ Tree Index
QUERY PROCESSING AND OPTIMIZATION
Query Cost Estimation
Query Operations
Evaluation Of Expressions
Query Optimization
Query Decomposition
Performance Tuning
Query Optimization And Processing
TRANSACTION PROCESSING AND CONCURRENCY CONTROL-DBMS
7.1. Acid Properties
7.2. Concurrent Executions
7.3. Serializability Concept
7.4. Lock Based Protocols
7.5. Deadlock Handling And Prevention
CRASH RECOVERY
8.1. Failure Classification
8.2. Recovery And Atomicity
8.3. Log-Based Recovery
8.4. Shadow Paging
8.5. Advanced Recovery Techniques
ADVANCED DATABASE CONCEPT
9.1. Concept Of Object-Oriented And Distributed Database Model
9.2. Properties Of Parallel And Distributed Databases
9.3. Concept Of Data Warehouse Database
9.4. Concept Of Spatial Database
PRACTICAL-LAB WORK DBMS
Lab 1- Data Definition Language Query
Lab 2- Sql Queries For Schema
Lab 3: Basic Sql Commands
Lab 4: Intermediate Sql Command
Lab 5: Advanced Sql Commands
Project Work In Dbms
Referenced Document For Ddl,Dml And Dcl
PRACTICE QUESTION - ER DIAGRAM
Hotel Management System
Football Management System
Restautrant Management System
Bus Transportation Management
Hostel Management System
Bank Management System
University Management System
Library Management System
OLD QUESTION BANK-DBMS-IOE
Old Question-2065-2075-Dbms
Old Question 2076-Bhadra-Dbms
Old Question-2077 Chaitra -Dbms
Old Question- 2078-Chaitra-Dbms
Old Question- 2078-Paush-Dbms
Old Question- 2079-Ashwin-Dbms
PREV
NEXT
OLD QUESTION DBMS 2076-BHADRA -IOE
PREV
NEXT