Create a view named v-subscribers


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

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Create a view named v-subscribers
Reference No:- TGS01939112

Now Priced at $25 (50% Discount)

Recommended (90%)

Rated (4.3/5)