Need Microsoft sql code:

Create a database named SALES (as shown in schema). Give names to all the constraints (except NULL constraints). The properties of the tables are defined as follows:

Questions [CLO-6]

Create complete database with all constraints as given [6X5 =30 Marks ]

Add data from the script In case of errors, check the defined structure again.. [5 Marks]

Create a procedure for entering a supplier record using given 5 attributes [3 Marks]

create a functions that returns list of products of a supplier . In this case user will enter supplier ID and function will return all products of that supplier [3 Marks]

create a user account of your last name and grant it select and update privileges on customers table [3 Marks]

create a unique clustered index on company name for customers table [3 Marks]

Create a VIEW which shows all order details of customers whose name starts with a [3 Marks]

COURSE: DATABASE

Create a database named SALES (as shown in schema). Give names to all the constraints (except NULL constraints). The properties of the tables are defined as follows: Questions [CLO-6] 1. Create complete database with all constraints as given [6 65=30Marks ] 2. Add data from the script in case of errors, check the defined structure again.. [5 Marks] 3. Create a procedure for entering a supplier record using given 5 attributes [3 Marks] 4. create a functions that returns list of products of a supplier, In this case user will enter supplier ID and function will return all products of that supplier [3 Marks] 5. create a user account of your last name and grant it select and update privileges on customers table [3 Marks] 6. create a unique clustered index on company name for customers table [3 Marks] 7. Create a VIEW which shows all order details of customers whose name starts with ' a ' [3 Marks]