Part 1: Using SQL to Modify a Database (35 points total) Consider the following schema for...

Transcribed Image Text:

Part 1: Using SQL to Modify a Database (35 points total) Consider the following schema for a book database. bookDB: COLUMN BookID CategoryID Title Price Pages CIS9340 Exam 2 Book DATA TYPE INT INT VARCHAR(25) DECIMAL(6,2) INT ReleaseYear INT Category COLUMN CategoryID CategoryName VARCHAR(25) DATA TYPE INT COLUMN BookAuthorID Book D INT INT INT AuthorOrder INT AuthorID BookID CategoryID BookAuthor COLUMN Author D Here is some information that will help you: The schema (database) name is bookDB. The Book table contains books. Each row is a unique book. 1011 LastName FirstName DATA TYPE The Category table contains book categories such as business, novel, science fiction, education, etc. Each row is a unique category. Author The Author table contains authors. Each row is a ulque author. Each book can have multiple authors; and each autor can write multiple books. Each book only belongs to one category; and there are many books in each category. DATA TYPE INT Write the SQL statement (just one for each question) that performs the following tasks. (5 points) All the tables have already been created, except for the BookAuthor table. Create the BookAuthor table. VARCHAR(25) VARCHAR(25) b) (5 points) Add a new entry to the Book table that captures the following information for a new author: Instructor: Shuting Wang) Page 1 of 5 Part 1: Using SQL to Modify a Database (35 points total) Consider the following schema for a book database. bookDB: COLUMN BookID CategoryID Title Price Pages CIS9340 Exam 2 Book DATA TYPE INT INT VARCHAR(25) DECIMAL(6,2) INT ReleaseYear INT Category COLUMN CategoryID CategoryName VARCHAR(25) DATA TYPE INT COLUMN BookAuthorID Book D INT INT INT AuthorOrder INT AuthorID BookID CategoryID BookAuthor COLUMN Author D Here is some information that will help you: The schema (database) name is bookDB. The Book table contains books. Each row is a unique book. 1011 LastName FirstName DATA TYPE The Category table contains book categories such as business, novel, science fiction, education, etc. Each row is a unique category. Author The Author table contains authors. Each row is a ulque author. Each book can have multiple authors; and each autor can write multiple books. Each book only belongs to one category; and there are many books in each category. DATA TYPE INT Write the SQL statement (just one for each question) that performs the following tasks. (5 points) All the tables have already been created, except for the BookAuthor table. Create the BookAuthor table. VARCHAR(25) VARCHAR(25) b) (5 points) Add a new entry to the Book table that captures the following information for a new author: Instructor: Shuting Wang) Page 1 of 5