The view should have columns for magazine id and


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
Database Management System: The view should have columns for magazine id and
Reference No:- TGS01241696

Now Priced at $20 (50% Discount)

Recommended (94%)

Rated (4.6/5)