Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed

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

image text in transcribed

v structure of PADDLING table

image text in transcribed

image text in transcribed

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.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine Ricardo

2nd Edition

1449606008, 978-1449606008

More Books

Students also viewed these Databases questions

Question

Assess various approaches to understanding performance at work

Answered: 1 week ago

Question

LO2 Compare three types of individual incentives.

Answered: 1 week ago