Write the scripts, Using the sample database, write the

Write the scripts

Assignment Help Database Management System

Reference no: EM131355847

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.

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.

Attachment:- Assignment.rar

Reference no: EM131355847

Questions Cloud

Using and understanding mathematics : Filling a Swimming pool from Using and Understanding mathematics - discussion post

Area of a right triangle : The area of a right triangle is 40m squared. One leg is 29.5 meters longer than the other. Find the lengths of the legs. The legs are meters in length.

Kilogram and venezuelan coffee : A store mixes Kenyan coffee worth $10per kilogram and Venezuelan coffee worth $ 13per kilogram. The mixture is to sell for $11per kilogram. Find how much of each should be used to make a 444-kilogram mixture.

How many adults and how many children went to the zoo : The Jurassic Zoo charges $5 for each adult admission and $2 for each child. The total bill for the 135 people from a school trip was $372. How many adults and how many children went to the zoo?

Write the scripts : 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

Demonstrate in your presentation value each principle has : You have been asked to give a presentation to a group of new managers in a health care setting. You need to demonstrate in your presentation the value each principle has in the real word.

Define decision making and the steps required : Decision making is said to be one of the essential parts of management. There should be clearly defined steps when it comes to decision making. Define decision making and the steps required to make a decision to an organization.

What you learned fits with your perspective about wellness : When you find a supporting resource, provide a reference, summarize the findings, and discuss how what you learned fits with your perspective about wellness (or has changed it).

How much will clem have saved in two years : Bank fees, currently $10 per month, are expected to increase by $1 per month henceforth. How much will Clem have saved in two years?

User Account

All Pages