Answer Happy

Name Phone Number Sven Schiro (415) 555-8290 Michael Leblanc (213) 555-4390 Marcus Selby (601) 555-8645 Lowell Lutz (214) 555-2722 Ken Soule (303) 555-6695 David Burgett (206) 555-7580 Bruce Fowler (213) 555-7270 Amanda Gentry (301) 555-3172 Destination Name Monterey Fiji Great Barrier Reef Florida Santa Barbara Fiji Florida Santa Barbara Number of People 12 4 10 4 6 4 Cost Per Night Life Person 2000 Wild 5000 Sleepy 20000 Pleasant 6000 Pleasant 6000 Wild 5000 Sleepy 3000 Pleasant 6000 Wild 3

DROP TABLE IF EXISTS 'DIVECUST; CREATE TABLE 'DIVECUST ( Customer_No' int(11) NOT NULL, Name varchar(255) default NULL, Street' varchar(255) default NULL, City varchar(255) default NULL, State_Prov varchar(255) default NULL, "Zip_Postal Code varchar(255) default NULL, Country varchar(255) default NULL, Phone varchar(255) default NULL, *First_Contact datetime default NULL, PRIMARY KEY (Customer_No), UNIQUE KEY "Customer_No ( Customer_No), KEY "Zip_Postal Code (Zip_Postal Code) ) ENGINE=MYISAM DEFAULT CHARSET=latinl; Dumping data for table 'DIVECUST

DROP TABLE IF EXISTS 'DIVEORDS"; CREATE TABLE 'DIVEORDS ( Order_No' int(11) NOT NULL, Customer_No int(11) default NULL, Sale_Date datetime default NULL, Ship_Via' varchar(255) default NULL, Ship_Cost' double default NULL, *PaymentMethodº varchar (255) default NULL, *CcNumber varchar(255) default NULL, CcExpDate datetime default NULL, No_Of_People smallint(6) default NULL, Depart_Date datetime default NULL, Return_Date datetime default NULL, Destination varchar(255) default NULL, VacationCost double default NULL, PRIMARY KEY (Order_No), KEY 'Customer_No' (Customer_No), KEY 'DESTDIVEORDS (Destination), KEY 'DIVECUSTDIVEORDS (Customer_No), KEY 'DIVEORDSShip_Via' (Ship_Via), KEY SHIPVIADIVEORDS (Ship_Via) ) ENGINE=My ISAM DEFAULT CHARSET=latini;