Introduction To Database Management System

Introduction To Database Management System

WHAT IS DATA?

Data is a collection of raw, unorganized facts and details like text, figures, symbols, descriptions of things, etc.

Data can be recorded and doesn't have any meaning unless processed.

TYPES OF DATA :

a. Quantitative:

Numerical form

Example: weight, volume, cost of an item, etc.

b. Qualitative:

Descriptive, but not numerical.

Example: Name, gender, color of person, etc.

WHAT IS INFORMATION?

Information is processed, organized, and structured data. It provides the context of the data and enables decision-making. Processed data that make sense to us.

Information is extracted from the data, by analyzing and interpreting pieces of data.

Example: you have data of all the people living in your locality, its Data when you analyze and interpret the data and come to some conclusion that:

i . There are 100 senior citizens.

ii. The sex ratio is 1:1.

iii. Newborn babies are 100.

These are information.

DATA VS INFORMATION:

  1. Data is the collection of facts while information put those facts into context.

  2. while data is raw and unorganized, information is organized.

  3. Data points are individual and sometimes unrelated. Information maps out that data to provide a big-picture view of how it all fits together.

  4. Data, on its own, is meaningless. when it's analyzed and interpreted, it becomes meaningful information.

  5. Data does not depend on information; however, information depends on data.

  6. Data typically comes in the form of graphs, numbers, figures, or statistics. Information is typically presented through words, language, thought, and ideas.

  7. Data isn't sufficient for decision- making but you can make a decision based on information.

WHAT IS A DATABASE?

The database is an electronic system where data is stored in a way that it can be easily accessed, managed, and updated.

To make real use of Data, we need a Database management system (DBMS).

WHAT IS DBMS?

A database-management system(DBMS) is a collection of interrelated data and a set of programs to access those data. The collection of data usually referred to as the database, contains information relevant to an enterprise. The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient.

A DBMS is the database itself, along with all the software and functionality. It is used to perform different operations like addition, access, updating, and deletion of the data.

Guide to Database Management Systems | Smartsheet

DBMS Vs FILE SYSTEMS

a. File-processing system has major disadvantages.

  1. Data Redundancy and inconsistency.

  2. Difficult in accessing data.

  3. Data isolation.

  4. integrity problem.

  5. Atomicity problem.

  6. concurrent- access anomalies.

  7. security problems.

b. Above 7 are also the advantages of DBMS.