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

  1. 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:
    1. total number of books published in 2010
    2. All books published by Penguin Books USA in 1990
    3. All books authored by Jordan Peterson
  2. Write descriptions for two modifications for data already in the database. Some examples:
    1. Update Symen Sinek's first name to "Simon"
    2. Change the address for the publisher HarperCollins
  3. Write descriptions for two deletions for data already in the database. Some examples:
    1. Delete the book Start With Why
    2. Remove all books authored by Joanna Gaines prior to 2015

 Write descriptions for three data querying requirements that could be answered

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!