Example data, column types, table creation. **************************************************************** pets: Bowser Diane dog m 1979-08-31 1995-07-29 30 65 Chirpy Gwen bird f 1998-09-11 \N 2 41 pet name, owner name, species, sex, birthdate, deathdate, weight kg, cuteness varchar varchar varchar char(1) date date int int CREATE TABLE pet ( name VARCHAR(12), owner VARCHAR(12), species VARCHAR(12), sex CHAR(1), birth DATE, death DATE, weight INT(3), cuteness INT(2)); **************************************************************** products: 11QER/31 Power painter, 15 psi., 3-nozzle 2003-11-3 8 5 109.99 0.00 13-Q2/P2 7.25-in. pwr. saw blade 2003-12-13 32 15 14.99 0.05 code/id, description, in-stock date, quantity in stock, reorder quantity trigger, price, discount %, varchar varchar date int int decimal decimal CREATE TABLE product ( p_code VARCHAR(10), p_descript VARCHAR(35), p_indate DATE, p_onhand INT, p_min INT, p_price DECIMAL(8,2), p_discount DECIMAL(5,2)); **************************************************************** countries: 'NLD','Netherlands','Europe',41526.00,1581,15864000,78.3,371362.00,'Constitutional Monarchy','Beatrix','NL' 'ALB','Albania','Europe',28748.00,1912,3401200,71.6,3205.00,'Republic','Rexhep Mejdani','AL' 3-letter code, name, continent, area sq km.dd, year independance, population, lifeExpectancy, GNP, form of govt, head of state, 2-letter code char(3) varchar varchar float,2 int int float,1 float,2 varchar varchar cahr(2) CREATE TABLE Country ( Code char(3), Name varchar(52), Continent varchar(13), SurfaceArea float(10,2), IndepYear smallint(6), Population int(11), LifeExpectancy float(3,1), GNP float(10,2), GovernmentForm varchar(45), HeadOfState varchar(60), Code2 char(2));