Question

A guide to SQL 9th edition
Colonial Adventure Tours chapter 3 page 90-92
Odd numbered exercises only

7. Review me on TUI UTILIVUDIJ types used to create the ITEM table in Figure 3-34. Suggest alternate data types for the DESCRIPTION, ON HAND. and STOREHOUSE fields and explain your recommendation Colonial Adventure Tours Use SQL to complete the following exercises 1. Create a table named ADVENTURE TRIP. The table has the same structure as the TRIP table shown in Figure 3-39 except the TRIP_NAME column should use the VARCHAR data type and the DISTANCE and MAX_GRP_SIZE columns should use the NUMBER data type. Execute the command to describe the layout and characteristics of the ADVENTURE_TRIP table. 2. Add the following row to the ADVENTURE TRIP table: trip ID: 45; trip name: Jay Peak; start location: Jay: state: VT: distance: 8; maximum group size: 8: type: Hiking and sea. son: Summer. Display the contents of the ADVENTURE TRIP table. 3. Delete the ADVENTURE_TRIP table. int file for the Colonial Adventure Tours database to create the six tables and 4. Run the script file for the Colonial Adventure the tables. Be sure to select the script file for the particular DBMS that you add records to the tables. Be sure to s are using (Oracle, SQL Server, or AC this text, ask your instructor for assistance.) 5. Conti Confirm that you have created the tables correct SOL Server, or Access). (Note: If you do not have the script files for created the tables correctly by describing each table and compar- added all data correctly by viewing the data in each table and 6. ing the results to Figure 3-39. Confirm that you have added all dat comparing the results to Figures 1-4 throu results to Figures 1-4 through 1-8 in Cha

figure 3-39(Guide, trip, customer, reservation and Trip_Guides)

figure 1-5 chapter 1:

Answer 1

32611 N L X 2BEERA pevial Cacate Toble PDVENTURE TRIP C TRIPLID DECIMPLC3,01 PRINARY Kex, 75 TRIPNAME ARCHARCe) TPRTIOCATION CHARCSO) STATE CHRC2 pistoNCE NUNBER C4,01 Nox-GRPSDZE "NUNBERG.0) TYPE CHAR(201 S6ASON CUARC20) DROP TRBLE PDreNTURETRIP

*****************************************************************************
PLEASE DO UPVOTE IF THE ANSWER IS HELPFUL , AS IT GIVES CONFIDENCE TO HELP MORE STUDENTS. There can be a chance that we can misunderstand each other.So before down voting please do reach out to me. Chegg allows me to answer specific no of questions including the sub parts , so please do post the rest of the questions as a separate query as per Chegg Guidelines. Thank you :)
*****************************************************************************