In this exercise you have to perform DDL operations by using Create, Alter and Drop Statements

1. Write a query to create database with name ShoppingDB.
2. Write a query to create a Customer table in ShoppingDB database with below mentioned structure details.

2. Write a query to create an Orders table in ShoppingDB database with below mentioned structure details.

3. Write a query to add a new column as Phone with datatype varchar(10).
4. Write a query to modify CustomerName column datatype to varchar(20) and make it as not null.
5. Write a query to remove DOB column from Customer table.
6. Write a query to remove Customer table from ShoppingDB database.