Discuss te below:
Using the database attached, write scripts in a file to create the following views. I must have a uses clause at the top of the script file to use the ITD410_P1 database. Also include code that checks if the view already exists. If it does, I am supposed to drop it and recreate it.
Create a view named v_Subscribers showing the subscriber ID, magazine ID, and start date where the date is more recent than August 1, 2005.
Create a view called v_no_cost with all columns of the magazine table, but not the cost column.
Create a view called v_Count that shows the number of subscribers for each magazine. The view should have columns for magazine id and count.
Attachment:- ITD410_P1_Log.zip