Database Management Systems (DBMS)

Introduction

• DBMS stands for Database Management Systems.
• Previously, file system approach was used.
• This video covers:
  • Basic definitions and terminologies in DBMS
  • Definition and functionalities of DBMS
  • Properties of a database
  • Simplified illustration of a database system environment
  • Example of a university database

Basic Definitions

Data

• Raw or unprocessed facts that can be recorded (e.g., numbers, text, images).

Information

• Processed data that is meaningful (e.g., "The age of Suresh is 25" is meaningful information derived from data).

Database

• A collection of related data.
• Example: Online banking system database contains data related to banking.

Metadata

• Definition of a database.
• Includes storage format, data types, and constraints.

Database Management System (DBMS)

Definition

• A system or software that manages a database.
• Allows users to create and maintain databases.

Functionalities

• Define the Database: Specify data types, structures, and constraints.
• Construct the Database: Store data on a storage medium.
• Manipulate the Database: Query, update, and generate reports.
• Share the Database: Allow multiple users to access concurrently.
• Protection: Protects against unauthorized access and failures.
• Maintenance: Ensures long-term maintenance of the database.

Properties of a Database

• Represents Real World: Reflects changes in the real world.
• Logically Coherent: Related data with inherent meaning.
• Purposeful Design: Built and populated for a specific purpose.

Database System Environment

• Users/programmers write queries.
• DBMS software processes queries.
• Accesses stored data and metadata.

Example: University Database

• Student Table: Information about students.
• Course Table: Information about courses.
• Grade Report Table: Grades of students for courses.

Understanding Functionalities with Example

• Defining: Specify data type, structures, and constraints (e.g., Student Name as a string).
• Constructing: Store data to construct the database.
• Manipulating: Query such as listing all CS branch students.
• Sharing: Database accessed by multiple users simultaneously.

Conclusion

• Overview of the basic introduction to DBMS.