Question: I just need the SQL statements for these problems. 1.)Make the distance for the Pontook Reservoir Tour trip equal to an unknown number. 2.)Add to

I just need the SQL statements for these problems.

1.)Make the distance for the Pontook Reservoir Tour trip equal to an unknown number.

2.)Add to the PADDLING table a new character column named DIFFICULTY_LEVEL that is three characters in length. Then set the default difficulty level value for all rows to the value MOD.

3.)Change the DIFFICULTY_LEVEL column in the PADDLING table to HRD for the Lake Champlain Tour trip.

4.)Change the DIFFICULTY_LEVEL column in the PADDLING table to reject nulls.

I just need the SQL statements for these problems. 1.)Make the distance

PADDLING Column Type Length Decimal Places Nulls Allowed? Description DECIMAL 3 TRIP ID Trip ID (primary key) 75 TRIP NAME CHAR Trip name 2 STATE CHAR Trip state DISTANCE DECIMAL 4 Trip distance MAX GRP SIZE DECIMAL 4 0 Maximum number of people on trip 20 Season in which trip takes place SEASON CHAR

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I just need the SQL statements for these problems. 1.)Make the distance for the Pontook Reservoir Tour trip equal to an unknown number. 2.)Add to the PADDLING table a new character column named...

Please helps! PLEASE DO QUESTION 1- 6. Thank you! The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises,...

Complete the Colonial Adventure Tours Exercises 1-4 u lo tourth specifik only have one supervisor u s his woman S is considering changing urth normal form Client Lue . La Raupervis , Buper cu supood...

Complete the Colonial Adventure Tours Exercises 1 10(in the first picture) and submit your responses (or screen shots). Please note that instead of Access, we will be using MySQL. Introduction to...

Need some help with SQL, these questions are really confusing. Colonial Adventure Tours Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-4 through 1-8...

Currently, each trip is identified with only season. For example, the Arethusa Falls trip is offered only in the Summer season. Colonial Adventure Tours is considering offering the same trip in more...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

tudy of an innovative method based on complementarity between ARIZ, lean management and discrete event simulation for solving warehousing problems Fatima Zahra Ben Moussa a, , Roland De Guiob ,...

What is the difference between MouseListener and MouseAdapter? [3 marks] (b) Via suitable HTML, the compiled version of the following Java code is presented to the appletviewer application: import...

I'm in serious need of help in my accounting class (acc205) . I'm falling behind and I need help with this weeks assignment. for week three for the may-june month . can someone please help me ....

Suppose that you have car wash business. If you wash daily x1 cars at the rate of ROD per car, x2 heavy vehicles (trucks, lorry etc.) at the rate of RO A per heavy vehicle and x3 motorcycles at the...

You are invested in two hedge funds. The probability that hedge fund Alpha generates positive returns in any given year is 60%. The probability that hedge fund Omega generates positive returns in any...

Razi thinks of a number. He multiplies his number by 0.1, and then divides the answer by 0.01. Razi then divides this answer by 0.1 and gets a final answer of 12 500. What number does Razi think of...

This week assignment is from file processing. Read a file Count number of lines Count number of words Count number of characters I have written a Java program that can read the words of the file but...