The MOORE Database


Sales Representative File

Rep-id  LName     FName     Region  Hire Date   Phone
114     abele     lori      sw      10/15/86    602-624-9384  
159     higgins   heatheryn se      12/16/91    404-524-8472  
230     sullivan  pat       se      2/21/88     305-734-2987  
386     speed     kristen   mw      6/14/90     708-823-8221   
349     demaree   donn      nw      7/10/93     206-634-1955  

Customer File

Cust-No  CName                    City        Rep-id
2934    ballard computers        seattle     349
3007    computer city            miami       230
4987    laser system             atlanta     159
8987    varner user systems      naperville  386
9185    cgi computers            spokane     349
9876    computing solutions      tucson      114


Order File

Cust-No Date       Item-No  Qty
3007    8/12/97    7639     11         
4987    8/12/97    6720     15         
8987    8/13/97    2378     14         
9185    8/10/97    1628     10         
9876    8/14/97    6720     20         


Inventory File

Item-No  Description              Qoh
1628     hand scanner             191        
2378     modem                    453        
3457     hard drive               294        
5647     printer pack             676        
6720     3.5 inch disk holder     982        
6599     cd-rom drive             817        
7639     sound card               0          
8870     mouse                    296        
9037     monitor                  152