Discuss the below:
Use the SQL Server 2005 Express
Create a database and name it ITD_GPA. Populate your database with appropriate test data.
- Include all of the scripts in a single file called ITD_GPA.SQL
- Create at least three related tables in the database.
- Create at least two stored procedures and a script to use each of them.
- Create at least one view (using a script).
- Create at least one trigger.
- Create at least five useful queries. At least one of these queries should use a subquery and at least one of the queries should use an aggregate function.
- All scripts should be well documented.
Attachment:- Data information.zip