Page 58 - 2611_SmartGPT Pro V(5.0) C-8

In the past, databases were managed manually on paper. This was time-consuming and
error-prone. As the need for handling more complex data grew, businesses and organisations
shifted to Relational Database Management Systems (RDBMS) like MySQL, PostgreSQL and

Oracle. These systems offer several advantages over traditional manual methods.

DATA AND INFORMATION

Data includes raw facts, figures or symbols that are yet to be processed into meaningful information.
Data can exist in various forms, including numbers, text, images, audio, video or observations.

Information is processed and organised data that becomes meaningful and useful for
decision-making, trend analysis or learning.

Roll No. Computer
Roll No. Student Name 106 86 Roll No. Student Name Maths Science English Computer
101 Aarav Sharma 103 78 101 Aarav Sharma 85 90 88 85
101 85 102 Riya Patel 78 82 80 98
105 Arjun Reddy 105 81 103 Saanvi Iyer 92 88 91 78
104 Meera Deshmukh 70 75 72 79
Roll No. Science 102 98
102 Riya Patel 105 Arjun Reddy 88 84 86 81
101 90 104 79
106 Kavya Menon 80 85 79 86
105 84 104 Meera Deshmukh
102 82
103 Saanvi Iyer
106 85
103 88 106 Kavya Menon
104 75
Data Process Information

INTRODUCTION TO DATABASE

A database is defined as an organised collection of data that is stored and accessed
electronically. With the help of a database, data can be stored, modified and retrieved. It acts as

a container for information that can be efficiently managed.

NEED FOR A DATABASE

Data is important today, but without proper systems, it may become inconsistent or get duplicated.
A database keeps data organised and centralised making it accessible, secure and consistent.

The need for databases is as follows: Amit Sen Amit Sen
Richa Tondon Richa Tondon
Reduction of data redundancy: It refers to unnecessary Deepak Patel Deepak Patel
duplication of data. A centralised database helps avoid this by Nitish Reddy Nitish Reddy
Anil Gurang Anil Gurang
storing only one version of the data. Amit Sen
Richa Tondon
Data sharing: It allows multiple users to access and

work on the same data simultaneously, facilitating
real-time collaboration.

56 Computer Science (V5.0)-VIII