Sql#1 - Bergam COUNTRY Norway 1504 USA 1323 Denmark 1401 USA 1286 Italy 1401 3 Name Null Type ORDERNUMBER NUMBER(38 PRODUCTCODE VARCHAR2(15

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Kevin Hopkins MIS 235 – E 9/13/11 1. Name Null? Type CUSTOMERNUMBER NUMBER(38) CUSTOMERNAME VARCHAR2(50) PHONE VARCHAR2(50) ADDRESSLINE1 VARCHAR2(50) CITY VARCHAR2(50) COUNTRY VARCHAR2(50) SALESREPEMPLOYEENUMBER NUMBER 2. CUSTOME RNUMBER CUSTOMERNAME PHONE ADDRESSLINE1 CI 121 Baane Mini Imports 07-98 9555 Erling Skakkes gate 78 Stavern 131 Land of Toys Inc. 2125557818 897 Long Airport Avenue NYC 145 Danish Wholesale Imports 31 12 3555 Vinbæltet 34 Kobenh 181 Vitachrome Inc. 2125551500 2678 Kingston Rd. NYC 278 Rovelli Gifts 035-640555 Via Ludovico il Moro 22
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Bergam COUNTRY SALESREPEMPLOYEENUMBER Norway 1504 USA 1323 Denmark 1401 USA 1286 Italy 1401 3. Name Null? Type ORDERNUMBER NUMBER(38) PRODUCTCODE VARCHAR2(15) QUANTITYORDERED NUMBER(38) PRICEEACH FLOAT(126) ORDERLINENUMBER NUMBER(38) 4. ORDERNUMBER PRODUCTCODE QUANTITYORDERED PRICEEACH ORDERLINENUMBER 10100 S24_3969 49 35.29 1 10100 S18_2248 50 55.09 2 10100 S18_1749 30 136 3 10100 S18_4409 22 75.46 4 10101 S18_2795 26 167.06 1...
View Full Document

This note was uploaded on 01/09/2012 for the course ECO 201 taught by Professor Dunlevy during the Fall '08 term at Miami University.

Page1 / 2

Sql#1 - Bergam COUNTRY Norway 1504 USA 1323 Denmark 1401 USA 1286 Italy 1401 3 Name Null Type ORDERNUMBER NUMBER(38 PRODUCTCODE VARCHAR2(15

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online