how to Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: EMPLOYEE, STORE, REGION, and SUPPLIER Database.   Create a new user statement for the database.  The user name should be based on yourself containing your name.   Statements that grant privileges to the new user.  Statements granting privileges to at least 2 of the tables in the assigned database Statements that revoke privileges to the new user.  Statements revoking privileges to at least 2 of the tables in the assigned Database

SQL script which is the physical design for this database   ### Animals This table contains the following data about all animals in the zoo. - animal ID (primary key) - animal name - animal birthdate - species - habitat (foreign key) [1 habitat to many relationship]   ### Habitats This table contains data about the habitats in the zoo.  Each animal lives in a specific habitat.  The habitat table should include the following data - habitat name, foreign key) - habitat location   ### Database CREATE DATABASE zoo;     Write queries to create the tables. Be sure to include primary keys for each table and the required foreign keys and referential integrity actions.   Add appropriate indexes. This database requires at least 2 indexes in addition to those automatically created by MySQL.

Procedure: 1. Click New Query and type an SQL statement to create a database named myDB. Tools Window Help | New Query D Execute DNI 2. Click the Execute button or press F5 to see the new database in the Object Explorer. 3. Create queries to perform the next steps. Before writing the queries, type USE MYDB; in the first line to use the database you have created in Step 1. 4. Create the tables named Customers and Product. Setthe appropriate data types and determines which ones are supposed to be NOT NULL. Customers: CustomerID (Primary key), EirstName, LastName, Email, Gender, Birthdate Products: ProductID (Primary key), Description, Quantity, Price, VendorID 5. Create anothertable named Vendors with columns: VendorID (Primary key), Name, ContactNum, CityAddress. 6. Set VendorlD from the Vendortable as a foreign key in the Products table. 7. Save a copy of your queries since these will be used in the last laboratory session of the Pre-final period.

a) Manually (you do not need do any of this in code) create a graphical user interface such as the one depicted in Figure 1. Use the value provided in the CSV file on Canvas.   b) Minimum requirements are to always ask for 3 assignments – for this, you skip this step. For bonus credit, prompt the user to input the number of assignments to calculate statistics for.  In this case you would need to prompt the user via an input box for the total number of deliverables for which summary statistics will be calculated. You must verify that the user enters a value that can represent a valid integer number in the range [1, 6]. If the user enters a value that does not represent a number, the user enters a valid value but the value is outside of the allowed range, or the user enters a non-integer value, your program must display an error message box. Once the user acknowledges the error by pressing the “OK” button on the message box, your program must continue to display the input box asking for…