Question: I am working on structured query language homework. I have already created the necessary tables for completing these questions, they are just based on concepts

I am working on structured query language homework. I have already created the necessary tables for completing these questions, they are just based on concepts I haven't quite mastered I am working on structured query language homework. I have already created

I will attach screenshots of the tables needed. Please help me with these queries b-j.

the necessary tables for completing these questions, they are just based on

v structure of PADDLING table

concepts I haven't quite mastered I will attach screenshots of the tables

needed. Please help me with these queries b-j. v structure of PADDLING

In response to the comment: Question f is inserting this column. It is one of the things help is needed with.. According to my instructions, the minimum group size is only relevant to the PADDLING table.

table In response to the comment: Question f is inserting this column.

b. Run a query for all paddling trips located in New Hampshire that increases the max group size by 2 unless it is already over 12. Insert a new trip into the database with a trip ID of 43, named Paddling Lake Granbury, in TX, with a max group size of 15, a distance of 6 and the season is Summer. Delete all paddling trips that are in CT. The max group size for the Lower Pond Tour in ME is under review due to changes in permits from the park department. Your boss wants you to update the table to show that this number is unknown at this time. Add a new column to the paddling table that indicates a minimum group's size and set the default value for all trips to 4 c. d. e. f. g. Change the table to disallow null values in the new field for group minimum size h. Change the minimum group size for all paddling trips in CT to 5 i. Decrease the customer's first name field to a length of 25 j. Delete the paddling table

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!