(a) Codd's 1970 paper introduced the Relational Model of data to address the difficulties of building...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(a) Codd's 1970 paper introduced the Relational Model of data to address the difficulties of building database applications using the technology that was available at the time. (i) What problems were encountered by database developers before Codd. introduced the Relational Model? [1 mark] (ii) Describe the basic elements of the Model, and explain what is meant by a relational schema. [4 marks] (iii) Explain how a formal schema can assist both the application database designer and a database application programmer. What if any are the disadvantages of adopting a mathematical description of database structure? [5 marks] (b) In 1976 Peter Chen introduced the Entity Relationship (E-R) Model to support a more natural description of real world data. (i) Describe the basic elements of the Model, and explain some of the choices available to the database designer. [4 marks] (ii) Explain what is meant by a foreign key in the relational model. How could you use foreign keys to represent a database described by an E-R model in relational form? To what extent are the two approaches to data modelling complementary? [6 marks] (a) Codd's 1970 paper introduced the Relational Model of data to address the difficulties of building database applications using the technology that was available at the time. (i) What problems were encountered by database developers before Codd. introduced the Relational Model? [1 mark] (ii) Describe the basic elements of the Model, and explain what is meant by a relational schema. [4 marks] (iii) Explain how a formal schema can assist both the application database designer and a database application programmer. What if any are the disadvantages of adopting a mathematical description of database structure? [5 marks] (b) In 1976 Peter Chen introduced the Entity Relationship (E-R) Model to support a more natural description of real world data. (i) Describe the basic elements of the Model, and explain some of the choices available to the database designer. [4 marks] (ii) Explain what is meant by a foreign key in the relational model. How could you use foreign keys to represent a database described by an E-R model in relational form? To what extent are the two approaches to data modelling complementary? [6 marks]
Expert Answer:
Answer rating: 100% (QA)
i Before Codds Relational Model database developers faced challenges with hierarchical and network m... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these programming questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Some managers and union officials also refer to the collective agreement as what? Multiple Choice The real boss The rule book The bible The guiding framework Strategic doctrine
-
The New Fund (from Problem 22) had an expense ratio of 1.1%, and its management fee was .7%. a. What were the total fees paid to the fund's investment managers during the year? b. What were the other...
-
State University has planned six special catered events for the Saturday of its homecoming football game. The events include an alumni brunch, a parents brunch, a booster club luncheon, a postgame...
-
Discuss the employment-at-will doctrine.
-
Patriot Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $74; white, $108; and blue, $99. The per unit variable costs to manufacture and sell these...
-
relations are true for every n1: a) i=1 1 n (21-1)(2i+1) 2n+1 b) 13-1 = (3n-1) Using mathematical induction, show that the following
-
Sema plc, a company in the heavy engineering industry, carried out an expansion programme in the 20X6 financial year, in order to meet a permanent increase in contracts. The company selected a...
-
Write a simple sub-query to produce the below output. Select the Shuttles mission (mission no) and duration (days) of the mission(s) that have flown for the most number of days. With the given data,...
-
What sort of pre-commitment strategies can people use when they are facing some of the self-control problems associated with addictive behaviour?
-
Find two Internet sites for soccer. One site should focus on U.S. soccer, whereas the other focus should be international. Comment on the relative positioning of soccer in the United States versus...
-
Which types of heuristics do you think are most important to everyday decision-making: availability, representativeness or anchoring/adjustment? Explain your answer and illustrate with examples.
-
Why have behavioural economists and economic psychologists thought it necessary to build new models of risk to replace expected utility theory? What are the problems with expected utility theory that...
-
Think of some sports products to which consumers demonstrate high degrees of brand loyalty. What are these products, and why do you think loyalty is so high? Give your suggestions for measuring brand...
-
The following information is available for Wonderway, Inc., for 2018: Factory rent Company advertising Wages paid to laborers Depreciation for president's vehicle Indirect production labor Utilities...
-
Give an example of transitory income. What effect does this income have on the marginal propensity to consume?
-
Variable and fixed costs in the wine industry, decision making A Votre Sant: Product Costing and Decision Analysis in the Wine Industry3 Background A Votre Sant (AVS) is a small, independent winery...
-
Briefly explain each of the four steps of the plandocheckact cycle.
-
How do the cost flows in a retail organization or service organization differ from those in a manufacturing organization?
-
Suppose a job enrichment effort in one plant of a manufacturing firm is judged to be very successful. You are the corporate change agent responsible for the project, and you wish to diffuse it to...
-
Describe an example of resistance to change that you have observed. Why did it occur?
-
What qualities would the ideal gatekeeper possess to facilitate the communication of technical information in the firm?
Study smarter with the SolutionInn App