Database

What is Database?

The database is an organized collection of related information. We have stressed “ORGANISED”, because only organized information is a database. Any unorganized information is just like a pile or dump, and it cannot be called a database. Organized information or a database serves as an information base you can use it for:-

1.Retrieving desired information.

2.Taking Meaningful Decision

3.Reorganized Information.

4.Processing Information.

Type of Database: From the technical point of view, there are three type of database are as follows: –

Hierarchical Database: The hierarchical database organized data into a tree structure of files, where each node of the tree contains one type of data. For example, you might organize a banks data in a hierarchical format.

Network Database: The network database structure is an extension of Hierarchical or Tree structure. Instead of only one child node, however network structure can have multiple parent nodes for a child node.

Relational Database: The relational structure is to relate data records using a standard tabular format. It is used to normally two dimensional tables to describe all relationship between data. For example relational tables could be established to link a college course with the instructor of the course and with location of the classes.

Difference between DBMS and RDBMS:

Elements of a Database: There are two elements of a database “FIELDS” and “RECORDS”. For example, if there is a database name “STUDENT”, same as below:-

Here every column heading (Ex. ROLL, NAME…) is a field, and every row (Ex. S001, S002…) is a record and every cell (Ex. M SEN, 57.00…) is the field value of a record. So we can say “S005” is the field value of roll of the record number five.

One Reply to “Database”

  1. I am commenting to make you be aware of of the wonderful encounter my cousin’s child developed browsing your web site. She came to find too many pieces, which included what it is like to have an ideal helping style to let many more just fully understand specified tricky matters. You truly exceeded our own expected results. Thank you for rendering those invaluable, trustworthy, educational not to mention easy thoughts on your topic to Evelyn.

Leave a Reply

Your email address will not be published. Required fields are marked *