Write a script that implements the following design in a database named mywebdb:

users table colums are : userid(the is the primary key), emailaddress, firstname, lastname

downloards table colums are: downloardid(the is the primary key), userid, downloarddate, filename, productid

product table colums are: productid(the is the primary key), productname

create a new database called mywebdb using the default settings.(if the database already exists, delete it and then recreate it.)

write code to create the users, download and products table.

write code to define the userid column in the users table, the productsid column in the products table, and the downloadid column in the downloads table as primary keys and identity columns.

in the downloads table, write code to define the userid and productid columns are the foreign keys.

write code to setup table relationships based on above diagram

write code to define the columns so none of them allow null values

write code to create a unique index on the emailaddress and productname columns and a regular index on the downloaddate column.

include any indexes that you think are necessary.