Tutorials
C Language
CPP
Data Structure
JAVA
PHP
DBMS
JavaScript
Questions
Python Questions
JavaScript Questions
Java Questions
PHP Questions
SQL Questions
About Us
Contact Us
Login / Sign up
Login
Sign-up
DBMS
Home
DBMS
DBMS
"Database Management System"
Introduction to
DBMS
Introduction to DBMS
Definitions related to dbms
DA and DBA
Functions and responsibilities of DBAs
Advantage and Disadvantages of File-oriented system
Advantage and Disadvantages of DBMS
Database System
Architecture
DBMS Architecture
Three-level ANSI SPARC Database Architecture
Data Independence
Mappings
Structure Components and Functions of DBMS
Data Models
Introduction to
SQL
Data types
Database language
Operators
Advanced
SQL
Transactional Control
DCL Commands
Synonym
Types of locks
Sequences
Index
Views
PL / SQL
and Triggers
Basics of PL/SQL
Datatypes and Advantages of PL/SQL
Control Structures
Exceptions
Cursors
Procedures and Functions
Packages
Triggers
Functional Dependency
and Decomposition
Basics of Functional Dependency
Functional Dependency Diagram and Examples
Full functional dependency(FFD)
Redundant functional dependencies
Closures of a set of functional dependencies
Decomposition
Dependency-Preserving Decomposition
Normalization
Basics of Normalization
Normal Forms
Transaction
Processing
Introduction to transaction concepts
Concurrency control
Methods for Concurrency control
