Details of this Paper

Database scripts

Description

solution


Question

Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITCO630_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.;Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker.;Create a view called v_no_points with all the columns of the assignment table except the points column.;Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.

 

Paper#70358 | Written in 18-Jul-2015

Price : $22
SiteLock