Please answer questions 1. Database creation

From the information above answer number 1.

In this assignment, you will create an Online Bookstore Database using the given SQL statements, populate the database with testing data, and run SQL statements on the database for given database changes and quer version of the database from Assignment 2. The logical model of the database is shown below: ies. The Online Bookstore Database is a simplified and modified " CustomerAccount AccountiD Email FirstName LastName CardiD CardNumber CardType ExpirationYear Account D(tk) OrderNum OrderDate CardID Tk) Book BooklD BookTitle NumorPages Language ISBN10Num UnitPrice BookSalesiD Quantity UnitSalesPrice BookID Tk) The design of those relations (tables) are the same as that in Assignment 2 Solution except for removed relations and attributes. You may want to reference Assignment 2 Solution for the design of those tables. In this assignment, you will create an Online Bookstore Database using the given SQL statements, populate the database with testing data, and run SQL statements on the database for given database changes and quer version of the database from Assignment 2. The logical model of the database is shown below: ies. The Online Bookstore Database is a simplified and modified " CustomerAccount AccountiD Email FirstName LastName CardiD CardNumber CardType ExpirationYear Account D(tk) OrderNum OrderDate CardID Tk) Book BooklD BookTitle NumorPages Language ISBN10Num UnitPrice BookSalesiD Quantity UnitSalesPrice BookID Tk) The design of those relations (tables) are the same as that in Assignment 2 Solution except for removed relations and attributes. You may want to reference Assignment 2 Solution for the design of those tables