Using SQL 2005, Download, unzip, and attach the sample database ITD640_A
from the link below. The sample database represents an educational
institution with students and different schools. Each student goes to
just one school. The students have various roles in different
assignments and may work on more than one assignment at a time.
The following are the tables and data in the ITD640_A database:
Using the sample database, write the scripts in a file called
ITD640_P3.SQL to create the following views. Include a USES clause at
the top of the script file to use the ITD640_A database. Also include
code that checks if the view already exists. If it does, it should be
dropped and recreated.
Create a view named v_worker showing the student number, assignment
number, and start date where the role is "worker."
Create a view called v_no_points with all the columns of the assignment
table except the points column.
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.
Computer Science Homework Solutions
#129954
SQL 2005 Scripts
SQL 2005
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 ITD640_A 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.
Create several views based on the different requirements in ITD640_A database, drop a view first if it exists.
What is this?
By OTA - Overall OTA Rating
Yanfang Li, PhD - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$19.95)
Included in Download
- Plain text response
- Attached file(s):
- SQL.sql
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Upgrading to SQL Server 2005 - What are the advantages as far as features like improvement, new features, and ease of use to upgrading to SQL Server 2005 from older versions? Also where can I find references on that information?
- Creating Scripts and Views - 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_P ...
- How to add a Table in MS SQL server 2005 and also how to add foreign Key constraints, check constraints and also how to create views - Need to know how to create a table with specified columns in SQL Server 2005. How can we add Foreign Key constraints ? How can we add Check constraints on particular columns ? How can we cre ...
- What are the security features in SQL Server that do not exist in Access? - Help with this questions. What are the security features in SQL Server that do not exist in Access?
- Sql Server 2005 Express - I am having trouble creating A View in SQL Server 2005 using the following table. I have selected subscriber_id and magazine_id, but I cannot create the correct code to complete the view. See at ...
