Create Views for ITD640_A database
Not what you're looking for?
Please help with the following problem.
Using the sample database, write the scripts in a file to create the following views. Include a USES clause at the top of the script file to use the following database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.
1. Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker."
2. Create a view called v_no_points with all the columns of the assignment table except the points column.
3. 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.
See attached file for full problem description.
Purchase this Solution
Solution Summary
This posting helps with a computer science problem. The solution involves writing scripts in a file with a given database.
Solution Preview
USE [ITD640_A]
GO
/* 1. */
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_worker]'))
DROP VIEW [dbo].[v_worker]
GO
CREATE VIEW [dbo].[v_worker]
AS
SELECT ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
C# variables and classes
This quiz contains questions about C# classes and variables.
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.
Basic Networking Questions
This quiz consists of some basic networking questions.