DBMS (Database Management System)

What is DBMS?

A database is an organized collection of data or information. It is managed and manipulated by software, and the process of managing a database is known as DBMS (Database Management System).

What is an Entity?

An entity is something that has its own identity.
Example: A database name like "Student" has its own identity. Attributes like `student_name` and `student_roll_no` are parts of the "Student" entity.

What is an Attribute?

An attribute is a property of an entity.
Example: `student_name` and `student_roll_no` are attributes of the "Student" entity.

Definitions

• Information: Processed data is known as information.
• Files: A collection of information is called a file.
• Database: The arrangement of files is called a database. A database is an organized collection of tables, where rows are called records, and columns are called fields.
• Folder: A folder is a container used to store files.

Table

A table is a collection of data stored in rows and columns. Rows are called records, and columns are called fields.

Types of Databases

• Flat File Database: A flat file database contains only one table.
• Relational Database: A relational database contains two or more tables linked by relationships.

Features of Data in a Database

1. It must be well-organized.
2. It is related to the name of the folder.
3. It can be accessed in a logically ordered manner without difficulty.
4. It is stored only once to avoid redundancy.