What is a Database?
A database is a structured collection of organized data that can be stored and managed in a computer system. The database is designed to efficiently store, retrieve, update, and manage large volumes of information in and out of the database.
Databases provide a systematic way to store data in a structured format, so that enables easy access, manipulation, and analysis of data.
In a database, data is organized into tables, which consist of rows and columns. Each row in a table represents a record or an entity, while columns represent attributes or properties of that entity. Databases are commonly used in various applications and industries to store and manage information, ranging from simple lists to complex structured data.
Advantages of electronic database
- Eliminating data duplications
- Minimizing data redundancy
- Ability to store large amounts of information in small storage
- Sharing information
- Having quick access to information
- Information Security
- Easy maintenance
What is a A Database Management System (DBMS)?
A Database Management System (DBMS) is a software application or system that enables users to create, manage, manipulate, and control access to databases. It provides an interface for users and applications to interact with the database, allowing them to store, retrieve, update, and delete data in an organized and efficient manner.
Types of Database Management Systems (DBMS)
- Relational DBMS (RDBMS) – MySQL, Microsoft SQL Server, Oracle Database.
