Question: Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram. Your classmates
- Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram. Your classmates will provide answers based on the requirements. Answers to your three requests should contain at least one JOIN; an aggregation function ; a GROUP By clause; and a WHERE or HAVING clause. Some examples:
- total number of books published in 2010
- All books published by Penguin Books USA in 1990
- All books authored by Jordan Peterson
- Write descriptions for two modifications for data already in the database. Some examples:
- Update Symen Sinek's first name to "Simon"
- Change the address for the publisher HarperCollins
- Write descriptions for two deletions for data already in the database. Some examples:
- Delete the book Start With Why
- Remove all books authored by Joanna Gaines prior to 2015

Books PK Title Year_First Published Edition Book Author FK Publisher_ ID FK ISBN PK ISBN FK Author_ID Publisher PK Publisher_ID Author Publisher Address PK Author ID Author_FirstName Author_ LastName
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
