Tag Archive for: called

write the scripts in a file called ITCO630_P3.SQL to create the following views.

You will probably need project Management to open file,,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.,,1.Create a view named v_worker showing the student number, assignment number, and start date where the role is “worker.”,2.Create a view called v_no_points with all the columns of the assignment table except the points column.,3.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.