Assignment 3. Download, unzip, and attach the sample da

Added on - Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
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.
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access