Question: question 1.Write a statement to Create a database (make sure your database doesn't contain special characters) 2.Write a statement to Drop that Database you created

1.Write a statement to Create a database (make sure your database doesn't contain special characters) 2.Write a statement to Drop that Database you created in Question 1 3. Writea statement to set the database you created to be the one that will be active for your session 4.Write a statement to Create a table that will have columns that represent all of the basic datatypes that are available in the databse (make sure your table and column names are describe the content of the table) () example CREATE TABLE book_info ( id VARCHAR(32) not null, filePath long varchar null, price float null, title null, author long varchar null, ); 5.Write 5 statements to add data to the table you created in question 4 6.Write 2 statements to Create two tables that have a way to force uniqueness from row to row ( make sure your table and column names are describe the content of the table) 7.Write 5 statements to add to the first table 4. Write a statement to Create a table that will have columns that represent all of the basic datatypes that are available in the databse (make sure your table and column names are describe the content of the table) () example 5.Write 5 statements to add data to the table you created in question 4 6.Write 2 statements to Create two tables that have a way to force uniqueness from row to row ( make sure your table and column names are describe the content of the table) 7.Write 5 statements to add to the first table you created in question 6 Write 5 statements to add to the second table you created in question 6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
