Need help
carolinebedford
data.zipinstallation.csv
INSTALLTYPE,INSTALLDESCRIPTION,RATE i1,carpet installation,40 i2,tile installation,50 i3,pergo installation,60
instline.csv
ORDERNUMBER,INSTTYPE,HOURS o1,i1,20 o1,i2,30 o1,i3,10 o2,i1,10 o2,i2,20 o6,i1,20 o6,i2,10 o7,i3,10 o8,i2,20
orders.csv
ORDERNUMBER,ORDDATE,SALESPERSON,CUSTOMERID o1,8/12/2007,e5,c1 o2,12/14/2007,e5,c2 o3,11/4/2007,e5,c3 o4,8/15/2007,e5,c4 o5,11/22/2007,e10,c5 o6,7/1/2007,e10,c6 o7 ,12/12/2007,e6 ,c6 o8 ,11/30/2007,e9 ,c2
prodline.csv
ORDERNUMBER,PRODCODE,QUANTITY o1,p1,1000 o1,p2,500 o2,p3,200 o3,p1,600 o3,p3,100 o4,p2,1000 o5,p2,800
product.csv
PRODUCTCODE,PRODDESCRIPTION,PRICE,STOCKLEVEL p1,carpet,40,10000 p2,tile,20,100000 p3,pergo,50,50000
branch.csv
BRANCHNUMBER,BRANCHNAME,BRANCHSTREET,BRANCHCITY,BRANCHSTATE,BRANCHZIP,REVENUETARGET,BRANCHMANAGER b1,branch1,9700 NW 41 St,Miami,FL,33178,800000,e1 b2,branch2,8700 SW 24 St,Miami,FL,33170,600000,e2 b3,branch3,E 200 47 St,New York,NY,11010,1000000,e3 b4,branch4,300 Park Avenue,New York,NY,10010,1200000,e4
customer.csv
CUSTOMERID,CUSTNAME,CUSTSTREET,CUSTCITY,CUSTSTATE,CUSTZIP,CUSTPHONE c1,cust1,-,Miami,FL,33164,- c2,cust2,-,Miami,FL,33120,- c3,cust3,-,Miami,FL,33110,- c4,cust4,-,Miami,FL,33178,- c5,cust5,-,New York,NY,11021,- c6,cust6,-,New York,NY,11001,-
employee.csv
EMPLOYEEID,EMPLNAME,EMPFNAME,EMPTITLE,EMPSTARTDATE,EMPBRANCH,EMPSALARY,EMPSUPERVISOR e1,Adam,Alan,CEO,1/11/2002,b1,600000, e2,Bryson,Brad,branch_manager,2/1/2003,b2,400000,e1 e3,Clay,Cedric,branch_manager,6/21/2001,b3,450000,e1 e4,Day,Daisy,branch_manager,8/17/2003,b4,480000,e1 e5,Engle,Eva,salesperson,1/1/2004,b2,120000,e2 e6,Falcon,Fred,salesperson,1/1/2002,b2,80000,e2 e7,Gandhi,Gagan,salesperson,1/1/2003,b3,90000,e3 e8,Hee,Hwang,salesperson,6/1/2004,b3,95000,e3 e9,Ingram,Irene,salesperson,9/24/2002,b4,110000,e4 e10,Jerome,John,salesperson,8/25/2002,b4,75000,e4
