Scribd
Upload
5 views1 page

SQL Practice: Tour Group Management

This document provides examples of SQL statements to practice creating a TOUR_GROUP table with fields for tour details, inserting a sample record, and updating a record's date and time fields, with a unique index added on the TOUR field to resolve an error.

Uploaded by

dreamtoget
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
5 views1 page

SQL Practice: Tour Group Management

This document provides examples of SQL statements to practice creating a TOUR_GROUP table with fields for tour details, inserting a sample record, and updating a record's date and time fields, with a unique index added on the TOUR field to resolve an error.

Uploaded by

dreamtoget
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Practice SQL CREATE TABLE: CREATE TABLE TOUR_GROUP (TOUR VARCHAR(20) NOT NULL, GUIDE VARCHAR(10), LANGUAGE VARCHAR(10),

TOUR_DATE DATE, START_TIME TIME, END_TIME TIME, GROUP_SIZE SMALLINT, AVAILABILITY SMALLINT ) PRIMARY KEY (TOUR)) IN [Link]; INSERT QUERY: INSERT INTO TOUR_GROUP (TOUR,GUIDE,LANGUAGE,TOUR_DATE,START_TIME,END_TIME,GROUP_SIZ E, AVAILABILITY) VALUES ('CONVENT GARDEN','PAULO','SPANISH',CURRENT DATE, CURRENT TIME,CURRENT TIME,20,4); UPDATE QUERY: UPDATE TOUR_GROUP SET TOUR_DATE = '2003-08-24',START_TIME = '09.45.15', END_TIME = '11.45.15' WHERE TOUR = 'CONVENT GARDEN'; To resolve index error: CREATE UNIQUE INDEX TOUR ON TOUR_GROUP (TOUR);

You might also like