Table: Salesmans  SalesmanID Title Address City Country Home phone Email Photo Home page File LastName FirstName BirthDate HireDate Region PostalCode Notes 1 Sales Representative 507 - 20th Ave. E.Apt. 2A Seattle USA (206) 555-9857 Nancy.Davolio@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED Davolio Nancy 12/8/1968 4/22/1998 WA 98122 Education includes a BA in psychology from Colorado State University. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International. 3 Vice President, Sales 908 W. Capital Way Tacoma USA (206) 555-9482 Andrew.Fuller@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED Fuller Andrew 8/29/2006 8/14/1992 WA 98401 Andrew received his BTS commercial and a Ph.D. in international marketing from the University of Dallas. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association. 4 Sales Representative 722 Moss Bay Blvd. Kirkland USA (206) 555-3412 Janet.Leverling@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED Leverling Janet 8/30/1963 4/1/1992 WA 98033 Janet has a BS degree in chemistry from Boston College). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate and was promoted to sales representative. 5 Sales Representative 4110 Old Redmond Rd. Redmond USA (206) 555-8122 Margaret.Peacock@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED Peacock Margaret 9/19/1958 5/3/1993 WA 98052 Margaret holds a BA in English literature from Concordia College and an MA from the American Institute of Culinary Arts. She was temporarily assigned to the London office before returning to her permanent post in Seattle. 7 Sales Manager 14 Garrett Hill London UK (71) 555-4848 Steven.Buchanan@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED Buchanan Steven 9/7/1967 10/17/1993   SW1 8JR Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree. Upon joining the company as a sales representative, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London, where he was promoted to sales manager. Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French. 8 Sales Representative Coventry HouseMiner Rd. London UK (71) 555-7773 Suyama.Michael@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED Suyama Michael 7/2/1963 10/17/1993   EC2 7JR Michael is a graduate of Sussex University (MA, economics) and the University of California at Los Angeles (MBA, marketing). He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional." He is fluent in Japanese and can read and write French, Portuguese, and Spanish. 9 Sales Representative Edgeham HollowWinchester Way London UK (71) 555-5598 Robert.King@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED King Robert 5/29/1960 1/2/1994   RG1 9SP Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan and then joining the company. After completing a course entitled "Selling in Europe," he was transferred to the London office. 10 Inside Sales Coordinator 4726 - 11th Ave. N.E. Seattle USA (206) 555-1189 Callahan.Laura@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED Callahan Laura 1/9/1958 3/5/1994 WA 98105 Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French. 11 Sales Representative 7 Houndstooth Rd. London UK (71) 555-4444 Dodsworth.Anne@test.com www.yahoo.com LONG BINARY DATA - CANNOT BE DISPLAYED Dodsworth Anne 7/2/1969 11/15/1994   WG2 7LT Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.