Assignment Task SQL

Table Data

Normalized tables

Task List Your grade will be based on how well you do on the following tasks (in addition to the general grading rubric!) 1. 2. 3. 4. 5. 6. 7. 8. Create the database and tables. Create the constraints of each tables. This can be done during the table creation if you wish. Create the base views for each table. Create one reporting view that combines the data for all the tables. Create the transactional stored procedures for each table. Set the appropriate permission on the tables, views, and stored procedures for the public role. Create test code that executes each of the stored procedures and shows the data in the tables. Use your Insert Stored Procedures to add the data from the spreadsheet into the tables