Database Management Systems (DBMS)

Introduction

• DBMS: Short for Database Management Systems.
• Previous Method: File system approach.
• This video covers the basic introduction to DBMS.

Topics Covered

1. Basic Definitions and Terminologies
2. Definition and Functionalities of DBMS
3. Properties of a Database
4. Simplified Database System Environment
5. Example: University Database

Basic Definitions

Data

• Raw or unprocessed facts that can be recorded.
• Examples: Numbers, names, text, images, audio, video.

Information

• Processed data with meaningful context.
• Example: "The age of Suresh is 25."

Database

• A collection of related data.
• Example: Online banking system data is related to that specific bank.

Metadata

• Database definition or description.
• Includes storage format, data types, constraints.

Database Management System (DBMS)

Definition

• System/software for managing databases.
• Collection of programs that enable creation and maintenance of a database.

Functionalities

• Define the Database: Specify data types, structures, and constraints.
• Construct the Database: Store data in a storage medium.
• Manipulate the Database: Querying, updating, generating reports.
• Share the Database: Access by multiple users/programs concurrently.
• Protection and Maintenance: Unauthorized access protection, recovery from failures.

Properties of a Database

1. Represents aspects of the real world (mini-world).
2. Logically coherent collection of data with inherent meaning.
3. Designed, built, and populated for a specific purpose.

Database System Environment

• Users/programmers write queries which are processed by DBMS.
• DBMS accesses stored data and metadata based on processed queries.

Example: University Database

• Tables: Student, Course, Grade Report.
• Defining the Database: Specify data types (e.g., string for names, integer for roll numbers), and constraints (e.g., student name cannot be null).
• Constructing the Database: Storing data builds the database.
• Manipulating the Database: Example queries include listing students by branch or grades by student.
• Sharing the Database: Efficient concurrent access by multiple users.

• Conclusion: Basic introduction to DBMS has been covered.