Business situation
As you complete each task below, answer the questions that follow. Write all answers to the questions on this document.
For each item below, you will design a relational model that implements the design given.
Place a copy of the DDL for the relational database and SQL for each query in the file named LabPart9.sql
1. Review the Primate Species Classifications diagram andthe relational schema shown below it.
Determine if the implementation of the Primate Species Classifications diagram as a relational database contained a table that contained hierarchical data.
If not, design a relational table that contains hierarchical data.
a. In the space below, show the schema of the table that contains hierarchical data.
b. Write 2 queries and describe the purpose of the query.
2. Review the Plant Classification chart. Design relational database that contains a table with hierarchical data.
a. In the space below, show the schema of the table that contains hierarchical data.
b. Write 2 queries and describe the purpose of the query.
3. Review the Ancestral Chart diagram and implement it as a relational modelthat contains a table with hierarchical data.
a. In the space below, show the schema of the table that contains hierarchical data.
b. Write 2 queries and describe the purpose of the query.
4. List at least three resources in APA style that you used to complete the tasks in this assignment.
5. List three things that you learned from this assignment.
Attachment:- Lab Questions.rar