- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
What is a database(dbms)?
Database is a collection of interrelated data that helps in efficient retrieval of information, insertion and deletion of data from a database which organizes the data in the form of views, tables, schemas etc.
A database is any organized collection of data.
Some of the examples that we came across in our daily life are as follows −
Airline reservation system
Files in your computer hard drive
Library card catalog etc.
For example, a University database organizes the data about students, admin, faculty, marks, events, schedules etc. that helps in efficient retrieval, insertion and deletion of data.
The size of the database is not fixed and it can be varying based on user request, it can be generated and maintained manually or by computer. So, finally a database is a collection of related data.
Given below is an example of collection of data in tabular format:
|Year of studying|
|Date of birth|
The above data is a collection of data that is related to student profile. To store data in a database we can represent it in the form of tabular form.
Consider the student profile table given below −
|Register No||Year||Semester||Date of birth||Address|
The data in this table can be modified, updated, deleted, inserted etc
Properties of database
The properties of database are as follows −
Databases represent some aspects of the real world.
A database is logically coherent collections of data with some inherit meaning.
A database is designed, built and populated with data for a specific purpose.
Social Media as database
Let us also consider our social media.
It needs to store, manipulate, and present data which is related to members, friends, member activities, messages, advertisements, and more. To do all these things a database is required for fast retrieving, inserting, deleting, and organizing the data.
Database components are given below −
- Related Articles
- What is a multimedia database (DBMS)?
- What is the basic purpose of a Database Management system(DBMS)?
- What is the procedure to access database users in DBMS?
- Database Management System (DBMS)
- Database Buffer in DBMS
- What are the different phases of database development Life cycle (DBMS)?
- Draw an ER diagram for a University database application(DBMS)?
- What is a Data Model in DBMS?
- What is a composite attribute in DBMS?
- What is a query language in DBMS?
- What is a materialized view in DBMS?
- What is a distributed database?
- What is a multimedia database?
- Explain the role of the Database Administrator in DBMS?
- What is Multivalued Dependency (DBMS)?