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.
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.
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.
- 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.
- FIRST GENERATION COMPUTER: ENIAC COMPUTER | EDSAC AND EDVAC COMPUTERS | VON NEUMANN
- HISTORY OF COMPUTING | WHO INVENTED THE MODERN COMPUTER?
- ENIAC COMPUTER – HISTORY, FEATURES, SPECIFICATIONS, SIZE, COMPARISON
- GENERATIONS OF COMPUTING | WHAT ARE COMPUTER GENERATIONS
- TYPES OF COMPUTER SYSTEM | ANALOG, DIGITAL, HYBRID
- ADVANTAGES OF COMPUTER | WHAT ARE ADVANTAGES OF COMPUTERS
- WHAT IS DATA? DATA: DEFINITION, EXAMPLE, ELECTRONIC DATA PROCESSING
- WHAT IS COMPUTER PROGRAM? DEFINITION, EXAMPLE
- OPERATING SYSTEM IN COMPUTER | DEFINITION, NEED, FUNCTIONS, WORKING
- TYPES OF PROGRAMS IN COMPUTER | TYPES OF PROGRAMS IN OPERATING SYSTEM
- TYPES OF OPERATING SYSTEM IN COMPUTERS | HISTORY OF OPERATING SYSTEM
- HISTORY OF UNIX OPERATING SYSTEM | FEATURES OF UNIX OPERATING SYSTEM
- WHAT IS A COMMAND LANGUAGE? USE OF COMMANDS IN COMMAND LANGUAGE
- MULTITASKING IN COMPUTER | DEFINITION, USE, EXAMPLE
- MICROPROGRAM IN COMPUTER | DEFINITION, FUNCTION, PROM, AND E-PROM
- WHAT IS A SOFTWARE | MEANING | DEFINITION | TYPES OF SOFTWARE
- GENERAL PURPOSE COMPUTER AND SPECIAL PURPOSE COMPUTER
- WHAT IS HARDWARE IN COMPUTER | DEFINITION | EXAMPLE | IMPORTANCE
- WHAT IS AN ALGORITHM | DEFINITION | MEANING | EXAMPLE | RULES OF ALGORITHM
- BASIC PRINCIPLE OF COMPUTER OPERATION | DIAGRAM
- WHAT IS MACHINE LANGUAGE IN COMPUTER | DEFINITION
- WHAT IS AN ASSEMBLY LANGUAGE | DEFINITION | DISADVANTAGES
- HUMAN AND COMPUTER COMPARISON
- WHAT IS HIGH-LEVEL LANGUAGE IN COMPUTER | DEFINITION | FUNCTION
- WHAT IS A FLOWCHART | HOW TO DRAW FLOWCHART | FLOWCHART SYMBOLS
- SPEED OF COMPUTER | EQUATION | METRICS | COMPUTER WORK IN THE SECOND MEASUREMENT
- WHAT IS INTEGRATED CIRCUIT | DEFINITION OF IC | USE | EXAMPLE
- WHAT IS ASCII | ASCII TABLE | PURPOSE OF ASCII
- BIT AND BYTE DIFFERENCE | SIZE COMPARISON
- WHAT ARE BINARY NUMBERS | EXPLAIN BINARY NUMBER SYSTEM
- HOW TO DECIMAL TO BINARY CONVERSION | DECIMAL NUMBER TO BINARY CONVERSION
- WHAT ARE LOGIC GATES | TYPES OF LOGIC GATES | DEFINITION | FUNCTION
- HOW TO CONVERT NUMBER INTO HEXADECIMAL NUMBER | CONVERT INT INTO HEX
- WHAT ARE COMPUTER MEMORY | TYPES OF COMPUTER MEMORY | RAM AND ROM
- KEY COMPONENTS OF A COMPUTER | MAIN COMPONENTS OF CPU
- WHAT IS ARITHMETIC AND LOGIC UNIT | COMPONENTS AND FUNCTION
- FUNCTION OF CONTROL UNIT OF A COMPUTER SYSTEM
- WHAT IS A MICROPROCESSOR | USE OF MICROPROCESSOR
- MICROCOMPUTER MINICOMPUTER AND MAINFRAME COMPUTER
- WHAT IS INTERFACE IN COMPUTER SYSTEM
- MAIN TYPES OF HIGH-LEVEL LANGUAGES
- WHAT IS GIGO (GARBAGE IN GARBAGE OUT) | EXPLAIN GIGO
- WHAT IS COBOL | EXPLAIN COBOL LANGUAGE | FEATURES OF COBOL
- HOW TO WRITE A PROGRAM | STEPS OF WRITING A COMPUTER PROGRAM
- WHAT IS FORTRAN | FEATURES OF FORTRAN | VERSIONS OF FORTRAN
- WHAT IS BASIC (BEGINNERS ALL-PURPOSE SYMBOLIC INSTRUCTION CODE) | FEATURES OF BASIC LANGUAGE
- INTERNAL WORKING OF COMPUTER
- WHAT IS PASCAL LANGUAGE | FEATURES OF PASCAL | TYPES OF PASCAL
- WHAT IS WORDSTAR IN COMPUTER | WORDSTAR COMPUTER PROGRAM
- GENERATIONS OF LANGUAGES IN COMPUTER SYSTEM
- WHAT IS LOTUS 1-2-3 | FEATURES AND PURPOSE OF LOTUS 1-2-3 | HISTORY
- WHAT IS ‘C’ LANGUAGE | IMPORTANCE | HISTORY | FEATURES
- USE OF A COMPILER | WHAT IS A COMPILER | WORKING OF COMPILER
- DIFFERENCE BETWEEN INTERPRETER AND A COMPILER
- WHAT IS A UTILITY PROGRAM | SORT AND MERGE PROGRAM
- THINGS TO DO BEFORE WRITING A PROGRAM ON A COMPUTER
- WHAT IS MENU IN COMPUTER LANGUAGE
- WHAT NEEDS TO BE DONE FOR DATA PROCESSING
- WHAT IS A FILE | DEFINE FILE IN COMPUTER SYSTEM