- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 −
- 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)
- What is a distributed database?
- What is a multimedia database?
- 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 Decomposition in DBMS?
- What is 4NF in DBMS?
- What is RAID in DBMS?
- What is Multivalued Dependency (DBMS)?
- What is a time-series database?