WHAT IS DATABASE IN COMPUTER SYSTEM | DEFINE DATABASE

INTRODUCTION

WHAT IS DATABASE – A database is very consistently stored information! A large company has the information of thousands of customers in the World.

It contains a number of cards with information such as name, address, city, state, zip code, telephone number.

They are arranged according to the initials of the individuals and arranged in different cups. This consistent list is a great example of a database.

DATABASE MANAGEMENT

Suppose we want a specific name starting with other initials in this database, then we open the pocket with names starting with other initials and start looking at the links in it. This is called management of the database.

Although the information in the various particles is consistent, it does nothing by itself.

It has to be managed and it can be done very skillfully from the computer.

DATABASE STRUCTURE

The database you have available can be structured in a variety of ways, all of the names in the above example are alphabetical.

In addition, it can be applied as a city or zip code. This means that the database can be structured in a specific way. This is called ‘database structure’.

If you want to change one type of structure to another, you have to spend a lot of time. It’s just a computer.

The work will be done very quickly.

In fact, a database is a table. It consists of several lines and columns. Each column has a caption.

So it is easy to understand what is in that column. These columns are called fields in the language of the database.

The actual information, however, is written in a line. They are called records.

For example, see the exam results sheet! It will have headings of name, exam number, physics, chemistry, mathematics, English, Total, etc. And in each line, you will see the result of that student.

TYPES OF DATABASE

There is a fundamental difference between a man-made database and a computer database.

Just by looking at a line, one can easily understand the different types of information in that line.

It will not confuse the person’s name and zip code. But the computer does not understand the difference.

The person’s name, address, or telephone number are all the same. If proper instructions are not given, the computer will understand the telephone number as the person’s name.

OPERATIONS ON DATABASE

Creating a database requires creating small sections of available information. This means that it has to be divided into different fields.

That’s the decent thing to do, and it should end there. Fields can be designed to create a database of books in the library, such as book name, author’s name, price, publication date, subject.

Once the fields are created, all the available information can be filled into the computer by creating a table or sheet.

This database can then be permanently stored on a floppy.

Managing a database as it should be is an art. A different language is currently available for that. It is called ‘Database III Plus’.

It contains many instructions to give to the computer. The following types of actions are mainly required in database management.

OPERATIONS

  • Add new information. (Append)
  • The layout of information in sequence. (Sort) Find the information you want. (Search)
  • Printing of information. (Print)
  • Updating old information. (Edit)
  • Erase unwanted information. (Delete)

It goes without saying that the database and the database based on it, ‘Mr. Plus’ is a gift for handling huge amounts of information easily.

READ MORE