ASSIGN_01

HIERARCHICAL Vs. RELATIONAL


A hierarchy is an arrangement of items (objects, names, values, categories, etc.) in which the items are represented as being "above," "below," or "at the same level as" one another and with only one "neighbor" above and below each level. These classifications are made with regard to rank, importance, seniority, power status or authority. A hierarchy of power is called a power structure. Abstractly, a hierarchy is simply an ordered set or an acyclic graph.A hierarchy can link entities either directly or indirectly, and either vertically or horizontally. The only direct links in a hierarchy, insofar as they are hierarchical, are to one's immediate superior or to one of one's subordinates, although a system that is largely hierarchical can also incorporate other organizational patterns. Indirect hierarchical links can extend "vertically" upwards or downwards via multiple links in the same direction, following a path. All parts of the hierarchy which are not linked vertically to one another nevertheless can be "horizontally" linked through a path by traveling up the hierarchy to find a common direct or indirect superior, and then down again.



A relational database matches data by using common characteristics found within the data set. The resulting groups of data are organized and are much easier for people to understand.For example, a data set containing all the real-estate transactions in a town can be grouped by the year the transaction occurred; or it can be grouped by the sale price of the transaction; or it can be grouped by the buyer's last name; and so on.Relational databases are currently the predominant choice in storing financial records, manufacturing and logistical information, personnel data and much more.Strictly, a relational database is a collection of relations (frequently called tables). Other items are frequently considered part of the database, as they help to organize and structure the data, in addition to forcing the database to conform to a set of requirements.