Purchase Solution

Important information about Please answer and elaborate on the following

Not what you're looking for?

Ask Custom Question

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?

Purchase this Solution
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 ...

Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

View More Free Quizzes
Related BrainMass Solutions

  • Public Perceptions of Punitive Penalties

    In addition, respond to the following questions: I have summarized key points of the study in point form. You can elaborate on these further and make them into full sentences for this answer.

  • Caribou Coffee and Fazer Group: 3 years,profitability ratios

    Having reviwed and analyzed the financial information, please elaborate on the following three questions. Which one of the two companies is the most profitable?

  • NOPAT and Net Income

    I understand without cash in the firm, it is tough to operate and develop new plans, products and expansion. Please elaborate and answer... Why is free cash flow (FCF) the most important measure of cash flow?

  • Management Questions: Intranet, Portals and Internet Ethics

    2-Discuss the strategic and technological fit required for an organization to implement a portal. 3-Elaborate on some of the ethical issues surrounding the Internet. What single issue do you consider the most important? Why? Thank you!

  • Industrial/organizational psychology historical development

    These chapter abstracts are meant to be aid in further reading about the topic and for you to be able to build a more elaborate answer based on the content provided in these chapters.

  • Explanation of core values and core values in action

    Citizenship The links below have information to help you elaborate on these and other examples of core values: http://www.co.marathon.wi.us/corevalues/note.asp?

  • Developing Effective Questionnaires

    Please answer the questions truthfully and to the best of your ability. All information provided here is confidential. 1. Have you experienced, observed or heard about any incidence lately? a. yes b. no c. not sure 2.

  • Trends in Marketing and Research Surveys

    I would also ask more questions on features, where people can provide a rating such as: - on a scale of 1 to 7, where 1 is dislike and 7 is like, how would you rate the following characteristics: - the scent of the product - the packaging - the

  • Writing a Business Letter to the Company or Organization

    Write a business letter to the company or organization that's offering the item, and ask four questions that are important to you. Be sure to include enough background information, so the reader can answer your questions satisfactorily.

  • Advantages and Disadvantages of Data Gathering Methods

    429495 Advantages and Disadvantages of Data Gathering Methods Please discuss the following: What are the advantages and disadvantages of the two principal methods of gathering data - the questionnaire method and the interview approach?

View More Related Solutions