Question $1)$ Create a SQL Server Script to create the below database schema in SQL Server.

Create a new database called L$\_$LUNCHES for this.

Hint: For Columns that have a composite key $($like l$\_$foods$),$ the create table statement will be similar to

the following:CREATE TABLE L$\_$FOODS

$($SUPPLIER$\_$ID VARCHAR$(3)$ REFERENCES L$\_$SUPPLIERS$($ SUPPLIER$\_$ID$),$

PRODUCT$\_$CODE VARCHAR$(2)$NOT NULL,

MENU$\_$ITEM INT NOT NULL,

DESCRIPTION VARCHAR$(20)$ NOT NULL,

PRICE

NUMERIC$(4,2)$ NOT NULL,

PRICE$\_$INCREASE NUMERIC$(4,2),$

PRIMARY KEY$($ SUPPLIER$\_$ID$,$ PRODUCT$\_$CODE$))$;

Submit the script you used to create the database above. It should be able to be run repeatedly. In

addition, submit the tree in SSMS that shows your database created, with all the tables showing.