Problem

  • Write SQL statement to create an authors table. See image.
  • Write SQL statement to add primary key to the authors table ( you select the primary key)
  • Write SQL Statements to insert the following data into the authors table: See image.

Problem

  • Write SQL statement to create an publisher table See image.
  • Write SQL statement to add primary key to the publisher table ( you select the primary key)
  • Write SQL Statements to insert the following data into the publisher table See image.

Problem

  • Write SQL statement to create an Book table See image.
  • Write SQL statement to add primary key to the Book table ( you select the primary key)
  • Write SQL statement to add Foreign key to the Book table
  • Write SQL Statements to insert the following data into the Book table See image.
  • Write SQL statement to search for publishers that are located only in the USA and New York City
  • Write SQL statement to update the following records: Change the price from the book " He is Gone" from 7.99 to 12.99
  • Write SQL statement to double the price of all mystery books.
Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.