HELP

Had to miss class last week and now I am lost and need to get this homework done.

The sql scripts are located at

http://www.course.com/catalog/downloads.cfm?isbn=0-619-00027-9

just need northwoo.sql

Questions:

Use SQL Plus to create a query that lists the bldg_code and room of every room that is either currently in use as a faculty office or in use as a classsroom during the summer 2002 term. (hint you will need to use a union)

Use sql plus to create a view named term_view that contains the callid, secnum, day, time, bldg_code and room for all courses offered during the summer 2002 term, Use summer 2002 as a search condition. Then write a query to view all of the fields in all of the view records.

Use SQL plus to write the commands to grant alter, delete, insert, update, and select privileges to public for your enrollment and course_section tables, and then write the commands to revoke all of these privileges. Received on Wed Nov 07 2001 - 22:58:44 CET