Question: Let the following database schema be given. Person(idnumber, name, dob, mother, father) primary key idnumber foreign key father references Person(idnumber) foreign key mother references

Let the following database schema be given. Person(idnumber, name, dob, mother, father)

Let the following database schema be given. Person(idnumber, name, dob, mother, father) primary key idnumber foreign key father references Person(idnumber) foreign key mother references Person(idnumber) Consider the following query: For the person with idnumber 42 produce a list of all their ancestors. Note that ancestors include grandparents, great-grandparents and so on. (a) Outline how you would solve this task programmatically, ad- dressing which particular SQL shortcoming you have to over- come. [5 marks] (b) What other kind of database might be more appropriate for the query and why? above [2 marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Here is an outline on how to solve the problem programmatically 1 Recursive approach This approach involves writing a recursive function that starts w... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Analyze the outdoor lifestyle data given in Internet and Computer Exercises 2 of Chapter 15. Do the three groups based on location of residence differ on the importance attached to enjoying nature,...

For r problems a to b, let T: R2 R2 be defined by Where a. Determine the image under the map of the square having vertices (0, 0), (1, 0), (l , 1) , and (0, 1) . Calculate and compare the areas of...

For each of the five independent situations below, prepare a single journal entry that summarizes the recording and payment of income taxes in order to determine the amount of cash paid for income...

5. provide an example of moral intensity moral sensitivity and situational influences 6:47 PM

What is the purpose of normalisation ? What problems does normali- sation gets rid of? When is it used? Consider the relational schema R with key ( a, b, c ) and no alternative keys. Below all its...

1.Write one SQL statement to set up table MoSpo HallOfFame according to the following Relational Schema: MoSpo HallOfFame(hoFdriverId, hoFYear, hoFSeries, hoFImage, hoFWins, hoFBestRaceName,...

4. Explain ONE of the problems that can occur in a database table when transactions are carried out concurrently. 5. Explain TWO techniques a database programmer can use to avoid running into the...

it is the question of MYSQL database, please give some explains to let know how it is solved. thanks 6. Let the following database schema be given. Person(idnumber, name, dob, mother, father) primary...

The most recent financial statements for Locke, Inc., are shown here: INCOME STATEMENT Sales Costs $59,000 48,700 BALANCE SHEET Debt Assets $126,900 Equity $ 40,800 86,100 Taxable income Taxes (24%)...

6. Let the following database schema be given. Person(idnumber, name, dob, mother, father) primary key idnumber foreign key father references Person(idnumber) foreign key mother references...

Refer to Cliffs Fresh Stacks Pancake Restaurant in E6-53B. Use Excel 2007 to run a regression analysis, then do the following calculations. Requirements 1. Determine Cliffs monthly operating cost...

Describe the McKinsey framework through the Sergio Marchionne motor of change case study in brief?

The cost of equity, also known as the price of money or funds, is a critical concept in financial management. It refers to the return a company must provide to its shareholders to compensate for the...

Fred Weasley, owner of the Flying Ford Taxi Co., was facing a pricing challenge. He was wondering how to set the radio fee for his service. The radio fee is required in exchange for Flying Ford...

Kale Company's year-end is December 31. The company rent out unused space in its office building making the tenant sign a three month lease and payment is due in advance on the first day of each...

You are a manager of a Wally's Training Gym and you encourage your trainers to enroll new members. Input is the trainer's last name and the number of new enrollees. Output is the number of trainers...

Create the follow program using Raptor or Python (if you do with both python and raptor correctly, you will get 30 bonus points for this assignment). Use the concepts, techniques and good programming...

All workers' compensation agencies have Experience Rating programs. Explain the main purpose and goals of an Experience Rating Program, as well as the qualifications for participation. Discuss any...

Describe the best practices for effective communication in team meetings and explain why meeting etiquette is crucial for productivity

Given the schema SCHEDULE (Prof, Office, Major, {Book}, Course, Quarter) along with: F: fd1: Prof {Office, Major} and D: mvd: Prof --->> Book a. Identify the primary key of SCHEDULE such that...

Why can total participation of an entity type in a relationship type also be referred to as existence dependency of that entity type in that relationship type?

Given the set of functional dependencies F {fd1, fd2, fd3, fd4, fd5, fd6, fd7, fd8, fd9, f10, f11} where: a. Construct the universal relation schema that includes (i.e., preserves) the set of...

Decades of overfishing have dramatically reduced the world supply of cod (a type of whitefish). Farm-raised halibut is considered a close substitute for ocean-fished cod. a. On the graph in Figure...

Suppose government offers a subsidy to laptop sellers. Say whether each group of people gains or loses from this policy. a. Laptop buyers. b. Laptop sellers. c. Desktop computer sellers (assuming...

Evie has a gift pass for unlimited rollercoaster rides on her birthday. Given the information about Evies utility in Table 7P-1, explain why she chooses to ride only three times.