How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Carla Your Own Question

Carla
Carla, Engineer
Category: Homework
Satisfied Customers: 560
Experience:  Bachelor's degree in Data Processing Technology. Over 12+ years experience in IT, Databases and Systems Administration.
19007361
Type Your Homework Question Here...
Carla is online now
A new question is answered every 9 seconds

Download, unzip, and attach the sample database ITCO630_A from

This answer was rated:

Download, unzip, and attach the sample database ITCO630_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.

Download the database for this assignment.

The following are the tables and data in the ITCO630_A database:



Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITCO630_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.
Hello


Thanks for requesting me again.

Can you please upload the ITCO630_A database to wikisend.com and paste the download link here?


Thank you

Customer: replied 3 years ago.

http://wikisend.com/download/324546/3.zip

Thanks. I will post the answer soon.
You can download the script file from here:

https://www.dropbox.com/sh/gicdavx8numhu03/KluKun3WbQ


Please feel free to contact me again if you need help with database and SQL assignments.


Thank you
Customer: replied 3 years ago.

Can u post it wikisend

Sure. Here it is:

http://wikisend.com/download/251962/ITCO630_P3.SQL
Customer: replied 3 years ago.


the link is not working i get an error

THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
Carla and other Homework Specialists are ready to help you