Databas Essay

1140 WordsAug 3, 20115 Pages
Individual Project #1 James E. Rose Jr. American Continental University Unit 1 Individual Project I am going to discuss the traditional database designs and to describe each one for Mr. Culebra to choose which of these would best suit his growing business. Let us start with the hierarchical model which organizes data in a tree structure. As you know, there is a hierarchy of parent and child data segments. This structure implies that a record can have repeating information, generally in the child segments. Data in a series of records, which have a set of field values attached to it. It collects all the instances of a specific record together as a record type. These record types are the equivalent of tables in the relational model, and with the individual records being the equivalent of rows. To create links between these record types, the hierarchical model uses Parent Child Relationships. These are a 1:N mapping between record types. This is done by using trees, like set theory used in the relational model, "borrowed" from math’s. For example, an organization might store information about an employee, such as name, employee number, department, salary. The organization might also store information about an employee's children, such as name and date of birth. The employee and children data forms a hierarchy, where the employee data represents the parent segment and the children data represents the child segment. If an employee has three children, then there would be three child segments associated with one employee segment. In a hierarchical database the parent-child relationship is one to many. This restricts a child segment to having only one parent segment. Hierarchical DBMSs were popular from the late 1960s, with the introduction of IBM's Information Management System (IMS) DBMS, through the 1970s. Next, we have the

More about Databas Essay

Open Document