Write DML statements for each query.  Do not use a query generator or graphical tool to write these; Write them and test them in MySQL DBMS.

 

1. Three data querying requirements that could be answered from the data stored in a database represented by ER diagram:

• show all the critically endangered species
• show everything not critically endangered  
• show all the species in Africa

1. Write descriptions for two modifications for data already in the database. examples
   • Adjust the average lifespan of the Chimpanzee from 35 to 36.5
   • convert the height from feet to meters / mass from lbs to kg
2. Write descriptions for two deletions for data already in the database. examples
   • Delete Human from the database
   • delete any Great Ape from the database that does not have an average lifespan of 40 yrs

 

 

Great Apes Gorillas Chimpanzees Bonobo Orangutans Humans Habitat Africa, tropical forest, montane Africa, tropical forest, savannas Africa, Congo Indonesia, Malayasia Earth - Various average lifespan. yrs 37.5 35 40 40 72.6 height ft mass lbs 5.25 4.5 3.8 3.925 5.4 250 103 84.25 126.5 150 conservation status critically endangered endangered endangered endangered least concern