Create a view

in /by

Create a view

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.

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper