AN INTRODUCTION TO MS ACCESS - Viral Tech updates

AN INTRODUCTION TO MS ACCESS

 In our daily life,we go through a lot of information . we have  a list of phone numbers of friends, addresses of people, the amount that we have to pay or get back from others, etc. All these sets of information must be managed properly, so that we may get the set of required information in time. A system used to arrange information in a tabular form and make updating in them is called Data Base management system.

  DATA  BASE  AND  ITS  ELEMENTS

A database is simply an organized collection of information or data. Databases arrange information in such a way that any specific piece of information can be easily located. 
Database is the need of  every organization be it a school,business house,welfare association or hospital. For example, A school maintain data about personal particulars of students, their academic records, co-curricular achievements, details of teachers and administrative staff. 
Besides,this data also needs updating from time to time. For this, it becomes necessary for the school staff to convert data in to database.

A database model can be one of the following type.
1.Hierarchical
2.Network
3.Relation
4.Object-Oriented
Hierarchical
 The hierarchical database model organized the database in a tree structure. This structure involves parent and child data segment. For example, An organization gives welfare allowance to the children of its employees. The records will be maintained as:
To create links between these record types, the hierarchical model uses parent child Relationships. 

No comments