Explore BrainMass

Important information about Please answer and elaborate on the following

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

In your opinion what would make a company or organization migrate to a relational database architecture from a network or hierarchical architecture? What are some of the factors that should be considered when transferring data from one database architecture to another?

© BrainMass Inc. brainmass.com October 24, 2018, 6:24 pm ad1c9bdddf

Solution Preview

In a relational database, the logical design is independent of the physical design. Queries against a relational database management system are based on logical relationships and processing those queries does not require pre-defined access paths among the data (i.e., pointers). On the other hand, a hierarchical database is a series of flat-files linked in structured 'tree' relationships. This concept is fundamentally different from that used in relational model where data resides in a collection of tables without any hierarchy and that are physically independent of each other. Similarly, the network database model expands on the hierarchical model by providing multiple paths among segments (i.e., more than one parent/child relationship).

Although supporting multiple paths in the data structure eliminates some of the inflexibility of the hierarchical model, the network model is not very practical. The network model only supports simple network relationship that are implemented as 'chains' connecting individual records and with no restrictions on the number of relations, the database design can become overwhelmingly complex . The relational model provides the ...

See Also This Related BrainMass Solution

Regression : key information

1. List one unclear concept regarding regression and provide an example from your personal or work life where regression could be used to show a relationship between two variables.

2. Correlation does not equal causation. That is very important to understand when interpreting regression. Can anyone elaborate for me?(100+ words please)

(ii) One should never use a regression line to predict the dependent response variable when the independent value is outside of the data range of the original data set that was used to fit the line. Explain why.(100+ words Please)

View Full Posting Details