Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Northwind Database Query Tool Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following

Northwind Database Query Tool

Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program:

  1. Print order total (not including the freight cost) for a given order number

The program will ask the user for an order number, and then print out the total for all products in the order, taking into account quantities and discounts. (All computations should be done within the SQL query).

  1. Print all order details for a given order number

The program will ask the user for an order number, and then print the order date, freight charge, and all products and their quantity, unit price, and discount for the order.

  1. Print the names and cities of all customers in a given state

The program will ask the user for a state, and then print out the names and cities of all customers in this state in order by city.

  1. Print the names of all employees who have a birthday in a given year

The program will ask the user for a year, and then print out the first and last names (in alphabetical order by last name) of all employees who were born during that year.

I asked this question before and the response was to add info about the database. I have the actual database file, but I don't know how to upload a file to this format. I only need the code thats necessary to execute the queries. Here is some of the info from the database. I hope these screenshots help. I also have the finished visual of how the database should look. Let me know if this helps and if you need the visual. image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

AutoSave Off HI NorthWind Database Tables - Saved to this PC Search Faheem Abdur-Rasheed FA File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X Eva EE ALI Calibri (Body) - 11 A A A A BIUab x, x? ADA AaBbCcDc AaBbCcDc AaBbc Aabbccc AaB 1 Normal 1 No Spac. Heading 1 Heading 2 Title Find Sc Replace Select Paste Dictate Sensitivity Editor y Clipboard F Font Paragraph Styles Editing Voice Sensitivity Editor NorthWind Database Tables Category: + Category 1 Category Nam Description Picture . Click to Add. 8 Seafood Seaweed and fish Bitmap Image Product I. Product Name Supplier - Quantity Per Unit - Unit Pric - Units In Stoc. Units On Ord. Reorder Leve - Discontinue. Click to Add 10 lkura Tokyo Traders 12-200 ml jars $31.00 31 0 D 13 Konbu Mayumi's 2 kg box $6.00 24 0 5 18 Carnarvon Tigers Pavlova, Ltd. 16 kg pkg. $62.50 42 0 0 30 Nord-Ost Matjeshering Nord-Ost-Fisch Handelsgesellschaft mbH 10-200g glasses $25.89 10 0 15 + 36 Inlagd Sill Svensk Sjfda AB 24-250g jars $19.00 112 0 20 37 Gravad lax Svensk Sjfoda AB 12-500 g pkgs. $26.00 11 50 25 40 Boston Crab Meat New England Seafood Cannery 24.4 oz tins $18.40 123 0 30 41 Jack's New England Clam Chowder New England Seafood Cannery 12-12 oz cans $9.65 85 0 10 45 Rogede sild Lyngbysild 1kpkg. $9.50 5 70 15 0 46 Spegesild Lyngbysild 4.450 g glasses $12.00 95 0 0 + 58 Escargots de Bourgogne Escargots Nouveaux 24 pieces $13.25 62 0 20 73 Rd Kaviar Svensk Sjfoda AB $15.00 101 0 5 + (New) $0.00 0 0 0 4 + + 24-150 g jars Customer: Customer ALFKI + ANATR ANTON + AROUT BERGS E BLAUS BLOND BOUD BONAP + BOTTM + BSBEV + CACTU + CENTC + CHOPS Company Name - Contact Name Alfreds Futterkiste Maria Anders Ana Trujillo Emparedados y helados Ana Trujillo Antonio Moreno Taqueria Antonio Moreno Around the Horn Thomas Hardy Berglunds snabbkop Christina Berglund Blauer See Delikatessen Hanna Moos Blondel pre et fils Frdrique Citeaux Blido Comidas preparadas Martin Sommer Bon app' Laurence Lebihan Bottom-Dollar Markets Elizabeth Lincoln B's Beverages Victoria Ashworth Cactus Comidas para llevar Patricio Simpson Centro comercial Moctezuma Francisco Chang Chop suey Chinese Yang Wang Contact Title Sales Representative Owner Owner Sales Representative Order Administrator Sales Representative Marketing Manager Owner Owner Accounting Manager Sales Representative Sales Agent Marketing Manager Owner Address Obere Str. 57 Avda. de la Constitucin 2222 Mataderos 2312 120 Hanover Sq. Berguvsvgen 8 Forsterstr. 57 24, place Klber C/ Araquil, 67 12, rue des Bouchers 23 Tsawassen Blvd. Fauntleroy Circus Cerrito 333 Sierras de Granada 9993 Hauptstr. 29 City - Region Berlin Mxico DF Mxico D.F. London Lule Mannheim Strasbourg Madrid Marseille Tsawassen BC London Buenos Aires Mxico D.F. Bern Page 1 of 4 12 words Focus 13 + 100% Type here to search W 12:24 PM 3/12/2021 3 F 8 AutoSave Off HI NorthWind Database Tables - Saved to this PC O Search Faheem Abdur-Rasheed FA File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X == = = T Calibri (Body) - 11 A A A A BIUab x, x? ADA AaBbCcDc AaBbCcDc AaBbc Aabbccc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Replace Select Paste Dictate Sensitivity Editor y Clipboard F Font Editing Voice Sensitivity Editor Paragraph 73 Rod Kaviar (New) Svensk Sjfoda AB 24-150 g jars Styles $15.00 $0.00 101 0 0 0 0 0 5 0 Customer: Customer ALFKI + ANATR + ANTON + AROUT BERGS # BLAUS BLOND BOUD + BONAP + BOTTM + BSBEV + CACTU + CENTC CHOPS COMMI E CONSH - DRACD DUMON EASTC ERNSH + FAMIA + FISSA + FOLIG FOLKO FRANK Company Name Contact Name Alfreds Futterkiste Maria Anders Ana Trujillo Emparedados y helados Ana Trujillo Antonio Moreno Taqueria Antonio Moreno Around the Horn Thomas Hardy Berglunds snabbkop Christina Berglund Blauer See Delikatessen Hanna Moos Blondel pre et fils Frdrique Citeaux Blido Comidas preparadas Martin Sommer Bon app Laurence Lebihan Bottom-Dollar Markets Elizabeth Lincoln B's Beverages Victoria Ashworth Cactus Comidas para llevar Patricio Simpson Centro comercial Moctezuma Francisco Chang Chop suey Chinese Yang Wang Comrcio Mineiro Pedro Afonso Consolidated Holdings Elizabeth Brown Drachenblut Delikatessen Sven Ottlieb Du monde entier Janine Labrune Eastern Connection Ann Devon Ernst Handel Roland Mendel Familia Arquibaldo Aria Cruz FISSA Fabrica Inter. Salchichas S.A. Diego Roel Folies gourmandes Martine Rance Folk och f HB Maria Larsson Frankenverand Deter Frankan Contact Title Sales Representative Owner Owner Sales Representative Order Administrator Sales Representative Marketing Manager Owner Owner Accounting Manager Sales Representative Sales Agent Marketing Manager Owner Sales Associate Sales Representative Order Administrator Owner Sales Agent Sales Manager Marketing Assistant Accounting Manager Assistant Sales Agent Owner Marketing Manager Address Obere Str. 57 Avda. de la Constitucin 2222 Mataderos 2312 120 Hanover Sq. Berguvsvgen 8 Forsterstr. 57 24, place Klber C/ Araquil, 67 12, rue des Bouchers 23 Tsawassen Blvd. Fauntleroy Circus Cerrito 333 Sierras de Granada 9993 Hauptstr. 29 Av. dos Lusadas, 23 Berkeley Gardens Walserweg 21 67, rue des Cinquante Otages 35 King George Kirchgasse 6 Rua Oros, 92 C/ Moralzarzal, 86 184,chausse de Tournai Akergatan 24 Rerliner Dat 42 City - Region: Berlin Mxico DF Mxico DF London Lule Mannheim Strasbourg Madrid Marseille Tsawassen BC London Buenos Aires Mxico D.F. Bern So Paulo SP London Aachen Nantes London Graz So Paulo SP Madrid Lille Bracke Minchan Employee: Employeel. Last Nam - First Nam. Title Title - Birth Date Hire Date. Address . City. Region. Postal Cod. Count Home P Davolio Nancy Sales Representative MS 08-Dec-1968 01-May-1992 507-20th Ave. E. Seattle WA 98122 USA (206) 55: 2 Fuller Andrew Vice President, Sales Dr. 19-Feb-1952 14-Aug-1992 908 W. Capital Way Tacoma WA 98401 USA (206) 55: + 3 Leverling Janet Sales Representative Ms. 30-Aug-1963 01-Apr-1992 722 Moss Bay Blvd. Kirkland WA 98033 USA (206) 55: 4 Peacock Margaret Sales Representative Mrs. 19-Sep-1958 03-May-1993 4110 Old Redmond Rd. Redmond WA 98052 USA (206) 55 : 5 Buchanan Steven Sales Manager Mr. 04-Mar-1955 17-Oct-1993 14 Garrett Hill London SW1 8JR UK 171) 555 + Page 1 of 4 12 words D Focus 13 + 100% Type here to search W 12:24 PM 3/12/2021 F 8 AutoSave Off HI NorthWind Database Tables - Saved to this PC Search Faheem Abdur-Rasheed FA File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X 5 Eva EE ALI Calibri (Body) - 11 A A A A BI U Bb XX? Ar ADA AaBbCcDc AaBbCcDc AaBbc Aabbccc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Sc Replace A Select Paste Dictate Sensitivity Editor y Clipboard F Font Paragraph Styles Editing Voice Sensitivity Editor Employee: Employeel. Last Nam. First Nam Title Title - Birth Date . Hire Date. Address . City Region Postal Cod. Count. Home PL Davolio Nancy Sales Representative Mis 08-Dec-1968 01-May-1992 507 - 20th Ave. E. Seattle WA 98122 USA (206) 55: 2 Fuller Andrew Vice President, Sales Dr. 19-Feb-1952 14-Aug-1992 908 W. Capital Way Tacoma WA 98401 USA (206) 55: 3 Leverling Janet Sales Representative Ms. 30-Aug-1963 01-Apr-1992 722 Moss Bay Blvd. Kirkland WA 98033 USA (206) 55: 4 Peacock Margaret Sales Representative Mrs. 19-Sep-1958 03-May-1993 4110 Old Redmond Rd. Redmond WA 98052 USA (206) 55: 5 Buchanan Steven Sales Manager Mr. 04-Mar-1955 17-Oct-1993 14 Garrett Hill London SW1 8JR UK (71) 555- 6 Suyama Michael Sales Representative Mr. 02-Jul-1963 17-Oct-1993 Coventry House London EC2JR UK (71) 555 7 King Robert Sales Representative Mr. 29-May-1960 02-Jan-1994 Edgeham Hollow London RG1 9SP UK (71) 555 8 Callahan Laura Inside Sales Coordinato Ms. 09-Jan-1958 05-Mar-1994 4726 - 11th Ave.N.E. Seattle WA 98105 USA (206) 55: 9 Dodsworth Anne Sales Representative Ms. 02-Jul-1969 15-Nov-1994 7 Houndstooth Rd. London WG2 7LT UK 171) 555 + + + Order Details: Order- Product 110248 Queso Cabrales 10248 Singaporean Hokkien Fried Mee 10248 Mozzarella di Giovanni 10249 Tofu Unit Pric - Quanti - Discoui - Click to Add $14.00 12 0% $9.80 10 0% $34.80 5 0% $18.60 9 n% Page 1 of 4 12 words Focus 13 + 100% i Type here to search O W 12:25 PM 3/12/2021 3 F 8 X AutoSave Off HI NorthWind Database Tables - Saved to this PC Search Faheem Abdur-Rasheed FA File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X 1 Calibri (Body) - 11 A A A A Ao BI U X? ab X, X ADA AaBbCcDc AaBbCcDc AaBbc Aabbccc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Replace Select Paste Dictate Sensitivity Editor y Clipboard F Font Editing Voice Sensitivity Editor Styles 9 40 10 35 15 6 15 20 40 25 Paragraph 10249 Tofu 10249 Manjimup Dried Apples 10250 Jack's New England Clam Chowder 10250 Manjimup Dried Apples 10250 Louisiana Fiery Hot Pepper Sauce 10251 Gustaf's Knckebrd 10251 Ravioli Angelo 10251 Louisiana Fiery Hot Pepper Sauce 10252 Sir Rodney's Marmalade 10252 Geitost 10252 Camembert Pierrot 10253 Gorgonzola Telino 10253 Chartreuse verte 10253 Maxilaku 10254 Guaran Fantstica 10254 Pt chinois 10254 Longlife Tofu 10255 Chang 10255 Pavlova 10255 Inlagd Sill 10255 Raclette Courdavault 10256 Perth Pasties 40 $18.60 $42.40 $7.70 $42.40 $16.80 $16.80 $15.60 $16.80 $64.80 $2.00 $27.20 $10.00 $14.40 $16.00 $3.60 $19.20 $8.00 $15.20 $13.90 $15.20 $44.00 $26.20 0% 0% 0% 15% 15% 5% 5% 0% 5% 5% 0% 0% 0% 0% 15% 15% 0% 0% 0% 0% 0% 0% 20 42 40 15 21 21 20 35 25 30 15 Page 2 of 4 12 words Focus 13 + 100% Type here to search T > S W 12:25 PM 3/12/2021 3 F 8 (x) AutoSave Off HI NorthWind Database Tables - Saved to this PC Search Faheem Abdur-Rasheed FA File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X E ALT Calibri (Body) - 11 A A A A BI U ab X, X? A ADA AaBbCcDc AaBbCcDc AaBbc Aabbccc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Sc Replace Select Paste Dictate Sensitivity Editor y Clipboard F Font Paragraph Styles Editing Voice Sensitivity Editor Orders: Customer - Employee Ship Via Order 1. 10248 WILMK 10249 TRADH 10250 HANAR 10251 VICTE 10252 SUPRD 10253 HANAR 10254 CHOPS 10255 RICSU 10256 WELLI 10257 HILAA 10258 ERNSH 10259 CENTC 10250 OLDWO 10261 QUEDE 10262 RATTC 10263 ERNSH 10264 FOLKO 10265 BLOND 10266 WARTH 10267 FRANK 10258 GROSR 10259 WHITC 10270 WARTH 10271 SPLIR 10272 RATTO - Order Dat - Required Dat - Shipped Dat 5 04-Jul-1996 01-Aug-1996 16-Jul-1996 6 05-Jul-1996 16-Aug-1996 10-Jul-1996 4 08-Jul-1996 05-Au-1996 12-Jul-1996 3 08-Jul-1996 05-Aug-1996 15-Jul-1996 4 09-Jul-1996 05-Aug-1996 11-Jul-1996 310-Jul-1996 24-Jul-1996 16-Jul-1996 -- 5 11-Jul-1996 08-Aug-1996 23-Jul-1996 -- 9 12-Jul-1996 09-Aug-1996 15-Jul-1996 3 15-Jul-1996 12-Aug-1996 17-Jul-1996 4 16-Jul-1996 13-Aug-1996 22-Jul-1996 1 17-Jul-1996 14-Aug-1996 23-Jul-1996 4 18-Jul-1996 15-Aug-1996 25-Jul-1996 4 19-Jul-1996 16-Aug-1996 29-Jul-1996 4 19-Jul-1996 16-Aug-1996 30-Jul-1996 8 22-Jul-1996 19-Aug-1996 25-Jul-1996 9 23-Jul-1996 20-Aug-1996 31-Jul-1996 6 24-Jul-1996 21-Aug-1996 23-Aug-1996 2 25-Jul-1996 22-Aug-1996 12-Aug-1996 3 26-Jul-1996 06-Sep-1996 31-Jul-1996 4 29-Jul-1996 25-Aug-1996 06-Aug-1996 -- 8 30-Jul-1996 27-Aug-1996 02-Aug-1996 5 31-Jul-1996 14-Aug-1996 09-Aug-1996 101-Aug-1996 29-Aug-1996 02-Aug-1996 601-Aug-1996 29-Aug-1996 30-Aug-1996 6 02-Aug-1996 30-Aug-1996 05-Aug-1996 Freigt - Ship Name Sh 3 $32.38 Vins et alcools Chevalier 59 rue 1 $11.61 Toms Spezialitaten Luisens 2 $65.83 Hanari Cames Rua do 1 $41.34 Victuailles en stock 2, rued 2 $51.30 Suprmes dlices Boulev 2 $58.17 Hanari Carnes Rua do 2 $22.98 Chop suey Chinese Hauptst 3 $143.33 Richter Supermarkt Stareny 2 $13.97 Wellington Importadora Rua do 3 $81.91 HILARION-Abastos Carrera 1 $140.51 Ernst Handel Kirchga 3 $3.25 Centro comercial Moctezuma Sierras 1 $55.09 Ottilies Kaseladen Mehrhe 2 $3.05 Que Delicia Rua da 3 $48.29 Rattlesnake Canyon Grocery 2817 MI 3 $146.06 Ernst Handel Kirchga 3 $3.67 Folk och fa HB Akergat 1 $55.28 Blondel pre et fils 24, plac 3 $25.73 Wartian Herkku Torikati 1 $208.58 Frankenversand Berline 3 $66.29 GROSELLA-Restaurante 5! Ave. $4.56 White Clover Markets 1029-1 1 5136.54 Wartian Herkku Torikati 2 $4.54 Split Rail Beer & Ale P.O.BO 2 $98.03 Rattlesnake Canyon Grocery 2817 MI 1 Products: + + Product I. Product Name Supplier Chai Exotic Liquids 2 Chang Exotic Liquids 3 Aniseed Syrup Exotic Liquids 4 Chef Anton's Cajun Seasoning New Orleans Cajun Delights 5 Chef Anton's Gumbo Mix New Orleans Cajun Delights 6 Grandma's Boysenberry Spread Grandma Kelly's Homestead 7 Uncle Bob's Organic Dried Pears Grandma Kelly's Homestead 8 Northwoods Cranberry Sauce Grandma Kelly's Homestead . Category - Quantity Per Unit - Unit Pric Units in Stoc Units On Orde. Real Beverages 10 boxes x 20 bags $18.00 39 O 0 Beverages 24 - 12 oz bottles $19.00 17 40 Condiments 12- 550 ml bottles $10.00 13 70 Condiments 48.6 oz jars $22.00 53 0 Condiments 36 boxes $21.35 0 0 Condiments 12 - 8 oz jars $25.00 120 0 Produce 12-1 lb pkgs. $30.00 15 0 Condiments 12-12 oz jars $40.00 6 0 . + Page 3 of 4 12 words C Focus 13 + 100% Type here to search W 12:25 PM 3/12/2021 F 8 AutoSave Off HI NorthWind Database Tables - Saved to this PC Search Faheem Abdur-Rasheed FA File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X == = = T Calibri (Body) - 11 A A A A BIUab x, x? ab x, X? ADA AaBbCcDc AaBbCcDc AaBbc Aabbccc AaB 1 Normal 11 No Spac... Heading 1 Heading 2 Title Find Replace Select Paste Dictate Sensitivity Editor y Clipboard F Font Paragraph Styles Editing Voice Sensitivity Editor Products: + + + + + + + + + + Product I. Product Name Supplier Chai Exotic Liquids 2 Chang Exotic Liquids 3 Aniseed Syrup Exotic Liquids 4 Chef Anton's Cajun Seasoning New Orleans Cajun Delights 5 Chef Anton's Gumbo Mix New Orleans Cajun Delights 6 Grandma's Boysenberry Spread Grandma Kelly's Homestead 7 Uncle Bob's Organic Dried Pears Grandma Kelly's Homestead 8 Northwoods Cranberry Sauce Grandma Kelly's Homestead 9 Mishi Kobe Niku Tokyo Traders 10 kura Tokyo Traders 11 Queso Cabrales Cooperativa de Quesos las Cabras 12 Queso Manchego La Pastora Cooperativa de Quesos 'Las Cabras' 13 Konbu Mayumi's 14 Tofu Mayumi's 15 Genen Shouyu Mayumi's 16 Pavlova Pavlova, Ltd. 17 Alice Mutton Pavlova, Ltd 18 Carnarvon Tigers Pavlova, Ltd 19 Teatime Chocolate Biscuits Specialty Biscuits, Ltd. 20 Sir Rodney's Marmalade Specialty Biscuits, Ltd. 21 Sir Rodney's Scones Specialty Biscuits, Ltd. 22 Gustaf's Knckebrd PB Knckebrd AB 23 Tunnbrd PB Knckebrd AB 24 Guaran Fantstica Refrescos Americanas LTDA 25 NuNuCa Nu-Nougat-Creme Heli Swaren GmbH & Co. KG . Category. Quantity Per Unit. Unit Pric Units in Stoc. Units On Orde. Reol Beverages 10 boxes x 20 bags $18.00 39 0 Beverages 24-12 oz bottles $19.00 17 40 Condiments 12-550 ml bottles $10.00 13 70 Condiments 48.6 oz jars $22.00 53 0 Condiments 36 boxes $21.35 0 0 Condiments 12 - 8 oz jars $25.00 120 0 Produce 12-1 lb pkgs. $30.00 15 0 Condiments 12-12 oz jars $40.00 6 0 Meat/Poultry 18.500 g pkgs . $97.00 29 0 Seafood 12- 200 ml jars $31.00 31 0 Dairy Products 1kg pkg. $21.00 22 30 Dairy Products 10-500 g pkgs. $38.00 86 0 Seafood 2 kg box $6.00 24 0 Produce 40 - 100 g pkgs. $23.25 35 0 Condiments 24 - 250 ml bottles $15.50 39 0 Confections 32-500 g boxes $17.45 29 0 Meat/Poultry 20-1 kg tins $39.00 0 0 0 Seafood 16 kg pkg. $62.50 42 0 Confections 10 boxes x 12 pieces $9.20 25 0 30 gift boxes $81.00 40 0 Confections 24 pkgs.x 4 pieces $10.00 3 40 Grains/Cereals 24-500 g pkgs. $21.00 104 0 Grains/Cereals 12.250 g pkgs. $9.00 61 0 Beverages 12 - 355 ml cans $4.50 20 0 Confections 20-450 g glasses $14.00 76 0 0 + + + + + + Confections + + + + Shippers: Page 3 of 4 12 words C Focus 13 + 100% o Type here to search T > S W 12:25 PM 3/12/2021 3 F 8 (x) AutoSave Off HI NorthWind Database Tables - Saved to this PC Search Faheem Abdur-Rasheed FA File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X 21 T Calibri (Body) - 11 A A A A BI U Bb XX? Ar ADA AaBbCcDc AaBbCcDc AaBbc Aabbccc AaB 1 Normal 1 No Spac. Heading 1 Heading 2 Title Find Sc Replace Select Paste Dictate Sensitivity Editor y Clipboard F Font Paragraph Styles Editing Voice Sensitivity Editor Click to Add Shipper. - Company Nam - Phone 1. Speedy Express (503) 555-9831 2 United Package (503) 555-3199 3 Federal Shipping (503) 555-9931 (New) Suppliers: + + + + + + + + Supplier - Company Name Contact Name Contact Title Address City RegioPostal Cod Exotic Liquids Charlotte Cooper Purchasing Manager 49 Gilbert St. London ECI 45D 2 New Orleans Cajun Delights Shelley Burke Order Administrator P.O.Box 78934 New Orleans LA 70117 3 Grandma Kelly's Homestead Regina Murphy Sales Representative 707 Oxford Rd. Ann Arbor MI 48104 4 Tokyo Traders Yoshi Nagase Marketing Manager 9-8 Sekimai Tokyo 100 5 Cooperativa de Quesos 'Las Cabras Antonio del Valle Saavedra Export Administrator Calle del Rosal 4 Oviedo Asturias 33007 6 Mayumi's Mayumi Ohno Marketing Representative 92 Setsuko Osaka 545 7 Pavlova, Ltd. lan Devling Marketing Manager 74 Rosest Melbourne Victoria 3058 8 Specialty Biscuits, Ltd. Peter Wilson Sales Representative 29 King's Way Manchester MI4 G5D 9 PB Knckebrd AB Lars Peterson Sales Agent Kaloadagatan 13 Gteborg S-34567 10 Refrescos Americanas LTDA Carlos Diaz Marketing Manager Av. das Americanas 12.890 So Paulo 5442 11 Heli Suwaren GmbH & Co. KG Petra Winkler Sales Manager Tiergartenstrae 5 Berlin 10785 12 Plutzer Lebensmittelgromrkte AG Martin Bein International Marketing Mg Bogenallee 51 60439 13 Nord-Ost-Fisch Handelsgesellschaft mb Sven Petersen Coordinator Foreign Market Frahmredder 112a Cuxhaven 27478 14 Formaggi Fortini s.r.l. Elio Rossi Sales Representative Viale Dante, 75 Ravenna 48100 15 Norske Melerler Beate Vileid Marketing Manager Hatlevegen 5 Sandvika 1320 16 Bigfoot Breweries Cheryl Saylor Regional Account Rep. 3400 - 8th Avenue Bend OR 97101 17 Svensk Sjofoda AB Michael Bjrn Sales Representative Brovallavgen 231 Stockholm S-12345 18 Aux joyeux ecclsiastiques Guylne Nodier Sales Manager 203, Rue des Francs-Bourgeois Paris 75004 19 New England Seafood Cannery Robb Merchant Wholesale Account Agent Order Processing Dept. Boston MA 02134 20 Leka Trading Chandra Leka Owner 471 Serangoon Loop, Suite 402 Singapore 0512 21 Lyngbysild Niels Petersen Sales Manager Lyngbysild Lyngby 2800 22 Zaanse Snoepfabriek Dirk Luchte Accounting Manager Verkoop Zaandam 9999 ZZ 23 Karkki Oy Anne Heikkonen Product Manager Valtakatu 12 Lappeenranta 53120 24 G'day, Mate Wendy Mackenzie Sales Representative 170 Prince Edward Parade Sydney NSW 2042 25 Ma Maison Jean-Guy Lauzon Marketing Manager 2960 Rue St. Laurent Montral Qubec HIJ 103 Frankfurt + + + Page 4 of 4 12 words Focus 13 + 100% o Type here to search PI W 12:25 PM 3/12/2021 F 8

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database

Authors: Wes Trochlil

1st Edition

0880343079, 978-0880343077

More Books

Students also viewed these Databases questions

Question

Explain the function and purpose of the Job Level Table.

Answered: 1 week ago