explain the process and logic Q3. The hierarchical data in tables store relations such as one column

explain the process and logic

Transcribed Image Text:

Q3. The hierarchical data in tables store relations such as one column refers to other column in same table. For example, an entire family tree can be stored in a person table. The table below can identify the eldest ancestor(s) in a family. These people do not have ancestor data in their records, which means they form the root of the family tree. Write a query to retrieve the first and last name of each person along with the first and last name of their mother and father. ID 1 2 6 Noo 7 8 First name John Anne Scarlet Jacob David Last name Watson Brown Miller Miller Miller birth 1945 1950 1985 1982 2015 Mother id NULL NULL 2 NULL 6 Father id NULL NULL 1 NULL 7 Q3. The hierarchical data in tables store relations such as one column refers to other column in same table. For example, an entire family tree can be stored in a person table. The table below can identify the eldest ancestor(s) in a family. These people do not have ancestor data in their records, which means they form the root of the family tree. Write a query to retrieve the first and last name of each person along with the first and last name of their mother and father. ID 1 2 6 Noo 7 8 First name John Anne Scarlet Jacob David Last name Watson Brown Miller Miller Miller birth 1945 1950 1985 1982 2015 Mother id NULL NULL 2 NULL 6 Father id NULL NULL 1 NULL 7