Description : The following are the tables and data in the ITCO630_A database:
School Table
| school_no | school_name | city |
| S1 | West University | San Francisco |
| S2 | Central University | Chicago |
| S3 | East University | San Francisco |
Student Table
| student_no | student_fname | student_lname | school_no |
| 25348 | John | Doe | S3 |
| 10102 | Jane | Smith | S3 |
| 18316 | Robert | Habner | S1 |
| 29346 | James | Elkehart | S3 |
| 90316 | Elise | Herbert | S2 |
| 25813 | List | Branson | S2 |
| 28559 | Sarah | Masters | S1 |
Assignment Table
| assignment_no | assignment_name | points |
| A1 | Group Project | 120 |
| A2 | Mid-term Exam | 100 |
| A3 | Final Exam | 200 |
Summary Table
| student_no | assignment_no | role | start_date |
| 10102 | A1 | Observer | 10/1/2005 |
| 10102 | A3 | Leader | 1/1/2006 |
| 25348 | A2 | Worker | 2/15/2005 |
| 18316 | A2 | NULL | 6/1/2005 |
| 29346 | A2 | NULL | 11/15/2004 |
| 25813 | A3 | Observer | 10/15/2005 |
| 90316 | A1 | Leader | 4/15/2005 |
| 28559 | A1 | NULL | 8/1/2005 |
| 28559 | A2 | Worker | 2/1/2006 |
| 90316 | A3 | Worker | 11/15/2004 |
| 29346 | A1 | Worker | 1/4/2004 |
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.