Programming Assignment
For this assignment, to earn full credit you must complete the following within MS SQL Server 2014:
(Completion of creating the Sample Database and couple ADDITIONAL steps)
1) Create a new database (such as COM340Database1)
2) Create a webUser account and grant it access.
3) Create a Product table.
4) Create a Stored Procedure for Inserting into the Product table and name it [dbo].[addProduct]
5) Create a Stored Procedure for Selecting from the Product table and name it [dbo].[getAllProducts]
6) Create a Stored Procedure for Updating a record in the Product table and name it [dbo].[updateProduct]
7) Create a Stored Procedure for Deleting a record by ID from the Product table and name it [dbo].[deleteProduct]
8) Grant webUser execute access to ALL stored procedures.
9 – 14) Repeat the above steps 3 through 8 for a new table that matches your project.
Remember to use: https://drive.google.com/file/d/0B-JJXBFXR5NIY041ZzIyZzNucUU/view