Assignment 3. Download, unzip, and attach the sample da
Added on - 16 Sep 2019
Assignment 3Download, unzip, and attach the sample database ITCO630_A from the link below. The sampledatabase represents an educational institution with students and different schools. Each studentgoes to just one school. The students have various roles in different assignments and may workon more than one assignment at a time.Download thedatabasefor this assignment.The following are the tables and data in the ITCO630_A database:Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create thefollowing views. Remember to include a USES clause at the top of the script file to use theITCO630_A database. Also include code that checks if the view already exists. If it does, itshould be dropped and recreated.