Write a set of commands that drops the Widgets database if it exists, and then creates a new Widgets database.

Write a set of commands that drops the Widgets database if it exists, and then creates a new Widgets database. SOLUTION: EX-02: Write a set of commands that would create a table named Clients in the Widgets database. The Clients table needs to have the following structure. Column Name Data Type Constraint ClientID INT PRIMARY KEY LastName VARCHAR (50) NOT NULL FirstName VARCHAR (50) MiddleInitial CHAR(1) StreetAddress VARCHAR (100) Email VARCHAR (100) Phone VARCHAR (20) ActiveAsof DATE NOT NULL SOLUTION: EX-03: Write a set of commands that would create a table named Stock in the Widgets database. The Stock table needs to have the following structure. Column Name Data Type Constraint ItemID INT PRIMARY KEY StockDescription VARCHAR (250) NOT NULL Cost MONEY NOT NULL Price MONEY NOT NULL Quantity INT NOT NULL Available BIT NOT NULL SOTJTION