Basic Definitions in DBMS | Data, Information, Database, Metadata, Field, Record & File

-

 

Basic Definitions in DBMS

Before learning Database Management Systems (DBMS), it is important to understand some basic terms such as Data, Information, Database, Metadata, Field, Record, and File. These concepts form the foundation for understanding how databases store and manage information.

1. What is Data?

Data is a collection of raw facts and figures that may not have a meaningful interpretation by themselves.

Examples of data include:

  • 101
  • Ravi
  • 20
  • Computer Science

2. What is Information?

Information is processed and organized data that has a meaningful interpretation and is useful to the user.

For example, consider the following data:

  • Student Name: Ravi
  • Marks: 85

3. What is a Database?

A database is an organized collection of related data that can be stored, accessed, managed, and updated efficiently.

For example, a college database may contain:

  • Student details
  • Course details
  • Marks

4. What is Metadata?

Metadata means data about data.

It describes the structure, properties, and characteristics of the data stored in a database.

For example, a Student table may contain the fields:

  • Roll_No – Integer
  • Name – Character/String
  • Age – Integer
  • Roll_No – Primary Key

5. What is a Database Management System?

A Database Management System (DBMS) is software used to create, store, organize, retrieve, update, and manage data in a database.

Examples include MySQL, Oracle Database, PostgreSQL, and Microsoft SQL Server.

6. What is a Field?

A field is a single data item or attribute of an entity. In a database table, a field is generally represented by a column.

Example:

Roll_NoNameAge
101Ravi20

7. What is a Record?

A record is a collection of related fields that describes one particular entity or item. In a table, a record is generally represented by a row.

Example:

Roll_NoNameAge
101Ravi20

FOR PDF: click here

FOR VIDEO : CLICK HERE

8. What is a File?

A file is a collection of related records stored together.

Example:

Roll_NoNameAge
101Ravi20
102Sita21
103Kumar20       

Comments

Post a Comment

Popular posts from this blog

EXPLAIN THE PLATFORMS FOR BUILDING AI APPLICATIONS/ APPLICATIONS OF AI

-
Image
  EXPLAIN THE PLATFORMS FOR BUILDING AI APPLICATIONS     AI applications can be built using different platforms.     Two main types: •       Online (Cloud-based) •       Desktop (No-code/Low-code) FOR PDF : click here FOR YOUTUBE VIDEO AND EXPLAINATION : click here  © 2026 Degree IT Academy. Unauthorized copying or redistribution is prohibited. © 2026 Degree IT Academy.  This material is protected under copyright law. No part of this document may be copied, stored,  or transmitted in any form without written permission from the author.
Read more

Explain the hardware used in building AI applications.

-
  Explain the hardware used in building AI applications . Þ    Artificial intelligence (AI) computer hardware and design principles enable AI developers to run machine learning algorithms and huge datasets in data centers. Þ    Hardware implementation of AI involves the design and execution of different components that are vital to AI systems, including processors, memory, and Storage . Þ    AI algorithms require a tremendous amount of computing power for their proper functioning, and hardware plays a crucial role in providing this support.     FOR PDF: click here    FOR VIDEO AND YOUTUBE EXPLANATION: click here
Read more

Explain different processors used in AI applications.

-
  Artificial Intelligence, or AI, is a technology that allows computers and machines to think and work like humans. AI can learn from data, make decisions, recognize speech, and solve problems. Examples of AI include Google Assistant, Siri, self-driving cars, face recognition, and YouTube recommendations. AI is widely used in healthcare, education, banking, and agriculture. It helps save time, improve accuracy, and automate tasks. In simple words, Artificial Intelligence means making machines intelligent. 1. Explain different processors used in AI applications. Processors are the brain of AI systems. They perform calculations and run AI models. FOR PDF click here © 2026 Degree IT Academy. Unauthorized copying or redistribution is prohibited. © 2026 Degree IT Academy.  This material is protected under copyright law. No part of this document may be copied, stored,  or transmitted in any form without written permission from the author.
Read more