Write DML statements for each query. Do not use a query generator or graphical tool to write
Fantastic news! We've Found the answer you've been seeking!
Question:
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
- 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
- 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
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date: