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.

8 Replies 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.

  2. I must get across my appreciation for your generosity giving support to individuals that need assistance with this one issue. Your special dedication to passing the message all through has been incredibly beneficial and have without exception enabled guys just like me to attain their endeavors. The insightful help can mean this much a person like me and still more to my colleagues. Thank you; from all of us.

  3. I wish to express some appreciation to you for rescuing me from this particular matter. As a result of scouting through the the web and meeting opinions which are not powerful, I believed my life was done. Being alive without the approaches to the problems you have solved through your good blog post is a critical case, and the kind which could have badly affected my career if I hadn’t discovered your website. Your own personal know-how and kindness in dealing with every aspect was crucial. I am not sure what I would’ve done if I had not encountered such a thing like this. It’s possible to at this point look forward to my future. Thanks a lot very much for your expert and sensible help. I will not think twice to suggest your web site to anyone who ought to have guidance about this situation.

  4. I would like to express thanks to this writer just for bailing me out of this circumstance. After exploring throughout the internet and meeting things which were not helpful, I assumed my life was well over. Existing without the approaches to the issues you’ve sorted out by way of your main website is a serious case, as well as those that could have badly damaged my entire career if I had not noticed your blog post. Your main knowledge and kindness in taking care of the whole lot was invaluable. I’m not sure what I would’ve done if I had not come upon such a stuff like this. I can at this moment look forward to my future. Thank you very much for this skilled and results-oriented guide. I will not be reluctant to propose the website to any person who should receive tips about this subject.

  5. Thanks a lot for giving everyone a very spectacular possiblity to read critical reviews from this site. It’s usually so superb and also packed with a great time for me personally and my office colleagues to visit your website particularly 3 times in one week to read the new secrets you have got. Not to mention, I’m just certainly amazed for the remarkable strategies you serve. Selected two points in this article are truly the most beneficial I’ve ever had.

  6. I simply wished to thank you very much again. I’m not certain the things I could possibly have accomplished in the absence of the entire creative concepts documented by you on my area of interest. It has been a horrifying case in my position, however , witnessing your specialized fashion you managed the issue forced me to cry over gladness. I’m just happier for this help and as well , expect you really know what a powerful job you’re getting into teaching the rest via your webpage. I know that you haven’t come across all of us.

  7. I want to point out my respect for your generosity supporting people that really want help with this one niche. Your personal commitment to passing the message all through became extraordinarily useful and have frequently permitted most people much like me to arrive at their dreams. Your new insightful recommendations implies a lot to me and somewhat more to my mates. Best wishes; from each one of us.

Leave a Reply

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