If you would like the sql file please let me know and post your email. I'll send you the file since Chegg doesn't like links in their posts. Thanks again for the help!

3. a. Write a script that adds an index to the MyGuitarShop database for the zip code field in the Addresses table. (5 points) b. Write a script that creates a new database called WebDB with the following design: (25 points) Users UserID Email Address First Name LastName Downloads 8 DownloadID Users Download Date FileName ProductID Products ProductID Product Name Define UserID, DownloadID, and ProductID as identity columns. Define EmailAddress in the Users table as unique. Allow null values for EmailAddress in Users table and DownloadDate in Downloads table. Other columns in all three tables should not have any null value. Set a default value Computer for the ProductName in Products table. Include the foreign key constraints with cascade delete in this database. Users UserID PK EmailAddress varchar(255) FirstName varchar(50) LastName varchar(70) Downloads DownloadID PK UserID FK DownloadDate smalldatetime FileName varchar(50) ProductID FK Products ProductID PK ProductName varchar(50) c. Now, add a new column, ProductPrice to the Products table. Use money datatype, allow null values and add a check constraint that allow only values more than $500 for this column. (5 points) d. Add a check constraint for FileName column in the Downloads table so that values in this column should start with 'p' only. (5 points)