NOTE Please read all the questions before creating your table in question 1 as your table and data need to be good enough quality to satisfy the conditions for questoon 3 to 6

CREATE DATABASE ASSIGNMENT2;

USE ASSIGNMENT2;

/*

Question 1

Write 2 statements to Create two tables that have a way to force uniqueness from row to row and are related by one of their columns ( make sure you have a least 1 date column ) ( 15 marks )

*/

/*

Question 2

/////// NOTE rember the order of which table you insert into first is important

Write 10 statements to add to the source table you created in question 1 ( 10 marks )

Write 10 statements to add to the dependant table you created in question 1 ( 10 marks )

*/

/*

Question 3

Write a SELECT statement that uses the LIKE statement and a character to find some of the records in one of your tables you created in Question 1 ( Use either the % or the _ for the rest of your wildcard) ( 10 marks )

*/

/*

Question 4

Write a SELECT statement that uses the BETWEEN statement to find some of the records in one of your tables using the date column you created in Question 1 ( 10 marks )

*/

/*

Question 5

Write a SELECT statement that uses another BETWEEN statement and sorts the data by 2 of the columns one in Ascending and one in Descending order on the tables you created in Question 1 ( 10 marks )

*/

/*

Question 6

Write a SELECT statement that selects a list of values (using the IN operator) from one of your tables, then use that same query and use the NOT operator to get the opposite data on the tables you created in Question 1 ( 10 marks )

*/