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

Added on - 16 Sep 2019

  • 2

    Pages

  • 208

    Words

  • 121

    Views

  • 0

    Downloads

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’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document