This commans goes into microsoft access 2013 please make sur

This commans goes into microsoft access 2013 please make sure commands working with no syntax error before making a submission, . I need the colonial adventure tours section answered.

Thanks

eách table and co 5. Confirm that you have created the t ables correctly by describing each table and compar ng the results to Figures 3-11, 3-30, 3-32, 3-34, and 3-36. 6. Confirm that youh le and onfirm that you have added all data correctly by viewing the data in each table comparing the results to Figure 2-1 in Chapter 2. eview the data for the ITEM table in Figure 2-1 in Chapter 2 and then review the data pes used to create the ITEM table in Figure 3-34. Suggest alternate data types for the 7. R AL KING types used to c DESCRIPTION, ON _HAND, and STOREHOUSE fields and explain your recomme r recommendations Colonial Adventure Tours Use SQL to complete the following exercises. e structure as the TRIP Create a table named ADVENTURE_TRIP. The table has the sam table shown in Figu 1. ble shown in Figure 3-39 except the TRIP_NAME column should use the VA 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. RCHAFR 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. ronto tho eix tahles and

Solution

1)CREATE TABLE ADVENTURE_TRIP
(
TRIP_ID NUMBER(3, 0) NOT NULL ,
TRIP_NAME VARCHAR2(75) ,
START_LOCATION VARCHAR2(50) ,
STATE VARCHAR2(2) ,
DISTANCE NUMBER(4, 0) ,
MAX_GRIP_SIZE NUMBER(4, 0) ,
TYPE VARCHAR2(20) ,
SEASON VARCHAR2(20) ,
CONSTRAINT ADVENTURE_TRIP_PK PRIMARY KEY ( TRIP_ID )
);
table ADVENTURE_TRIP created.

2)INSERT INTO ADVENTURE_TRIP (TRIP_ID, TRIP_NAME, START_LOCATION, STATE, DISTANCE, MAX_GRIP_SIZE, TYPE, SEASON) VALUES (45, \'JAY PEAK\', \'JAY\', \'VT\', 8, 8, \'HIKING AND SEA SON\', \'SUMMER\')

Commit Successful

3)TO DELETE THE TABLE

DROP TABLE ADVENTURE_TRIP;