Purchase Solution

create views using SQL scripts

Not what you're looking for?

Ask Custom Question

Using the ITD410_P1 database attached, I need to write scripts in a file called ITD410_P3.SQL 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.

Then, I have to:

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.

I have read SQL Server 2005 Unleashed along with several other online books and MSDN. However, I can not understand how to do this. I am looking for clarification or detailed instruction as to how to complete this. Please see attached zip file.

Attachments
Purchase this Solution
Solution Summary

The solution shows how to create views using SQL scripts with ITD410-P1 database.

Solution Preview

please see the attached sql script.

Note:

After you ...

Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

C# variables and classes

This quiz contains questions about C# classes and variables.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

View More Free Quizzes
Related BrainMass Solutions

  • SQL Database Views

    database is attached The following are the tables and data in the ITD640_B database: Using the sample database, write the scripts in a file called ITD640_P3.SQL to create the following views.

  • Complete New SQL Database

    - Include all of the scripts in a single file called ITD_GPA.SQL - Create at least three related tables in the database. - Create at least two stored procedures and a script to use each of them. - Create at least one view (using a script).

  • Writing Code in SQL

    Using the sample database, write the scripts in a file called ITD640_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITD640_A database.

  • Database System Requirements.

    Create at least one view (using a script). Create at least one trigger. Create at least five useful queries. At least one of these queries should use a subquery and at least one of the queries should use an aggregate function.

  • SQL Scripts for Data Manipulation

    I believe what you are looking for are SQL scripts that would do the building of table, inserting of data and querying of data. These scripts are simple text files and are usually saved with the extension .sql.

  • SQL Database system for Invoicing

    Create at least three related tables in the database. Create at least two stored procedures and a script to use each of them. Create at least one view (using a script). Create at least one trigger. Create at least five useful queries.

  • SQL script to sort numbers across columns

    Good luck and thank you for using Brainmass.com! The sql script will create a table with 4 columns and a user defined function that can take in these 4 values and produce a string where numbers are sorted in ascending order.

  • Creating Tables Using SQL Server

    The expert creates tables using SQL server.

  • Using limit and limitstart to create pages of data

    Using this information a script developer can create a smooth and seamless paging system for viewing records in a database.

View More Related Solutions