DBMS Midterms

- Is a software system that is designed to manage and organize data in a structured manner.

• - It allows users to create, modify, and query a database, as well as manage the security and access controls for that database.

• Database Management System

• Data Structure and Algorithms

• Data Languages

• Data Manipulation Language

is a collection of interrelated data which helps in the efficient retrieval, insertion, and deletion of data from the database and organizes the data in the form of tables, views, schemas, reports, etc.

• Database

• Data Management

• Data Structure

• Data

Deals with database schemas and descriptions, of how the data should reside in the database.

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Control Language (DCL)

• Transactional Control Language (TCL)

Deals with data manipulation and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE, etc., and it is used to store, modify, retrieve, delete and update data in a database.

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Control Language (DCL)

• Transactional Control Language (TCL)

Acts as an access specifier to the database. (Basically to grant and revoke permissions to users in the database)

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Control Language (DCL)

• Transactional Control Language (TCL)

Acts as a manager for all types of transactional data and all transactions.

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Control Language (DCL)

• Transactional Control Language (TCL)

Helps in the creation, modification, and removal of definitions that define the organization of data in the database.

• Data Definition

• Data Updation

• Data Retrieval

• User Administration

Helps in the insertion, modification, and deletion of the actual data in the database.

• Data Definition

• Data Updation

• Data Retrieval

• User Administration

Helps in the retrieval of data from the database which can be used by applications for various purposes.

• Data Definition

• Data Updation

• Data Retrieval

• User Administration

Helps in registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering information corrupted by unexpected failure.

• Data Definition

• Data Updation

• Data Retrieval

• User Administration