Stored Procedures and Triggers

For the group project, you will be creating a database system to solve a business problem of your choice. The database system must meet the criteria shown below. In addition to the database solution, each student will prepare a system summary.
Database System Requirements (Group Work): Create a database and name it ITC0630_GPx where “xi• is your group letter. Populate your database with appropriate test data. •Include all of the scripts in a single file called ITC0630_GPx.SQL where x is your group letter. Create at least 3 related tables in the database. Create at least 2 stored procedures and a script to use each of them. Create at least 1 view (using a script). Create at least 1 trigger. Create at least 5 useful queries. At least one of these queries should use a subquery and at least 1 of the queries should use an aggregate function.