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

Added on - 16 Sep 2019

  • Dissertation

    type

  • 2

    pages

  • 208

    words

  • 25

    views

  • 0

    downloads

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
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document