INSERT INTO Supplier VALUES ("1", "Exotic Liquid", "Charlotte Cooper", "49
Gilbert St.", "Londona", "EC1 4SD", "UK", "(171) 555-2222"), ("2", "New
Orleans Cajun Delights", "Shelley Burke", "P.O. Box 78934", "New Orleans",
"70117", "USA", "(100) 555-4822"), (“3”, “Grandma Kelly's Homestead”,
“Regina Murphy”, “707 Oxford Rd.”, “Ann Arbor”, ”48104”, “USA”, “(313)
555-5735”), (“4”, “Tokyo Traders”, “Yoshi Nagase”, “9-8 Sekimai Musashino-
shi”, “Tokyo”, “100”, “Japan”, “(03) 3555-5011”), (“5”, “Cooperativa de
Quesos 'Las Cabras'”, “Antonio del Valle Saavedra”, “Calle del Rosal 4”,
“Oviedo”, “33007”, “Spain”, “(98) 598 76 54”), (“6”, “Mayumi's”, “Mayumi
Ohno”, “92 Setsuko Chuo-ku”, “Osaka”, “545”, “Japan”, “(06) 431-7877”),
(“7”, “Pavlova, Ltd.”, “Ian Devling”, “74 Rose St. Moonie Ponds”,
“Melbourne”, “3058”, “Australia”, “(03) 444-2343”), (“8”, “Specialty Biscuits,
Ltd.”, “Peter Wilson”, “29 King's Way”, “Manchester”, “M14 GSD”, “UK”,
“(161) 555-4448”), (“9”, “PB Knäckebröd AB”, “Lars Peterson”,
“Kaloadagatan 13”, “Göteborg”, “S-345 67”, “Sweden”, “031-987 65 43”),
(“10”, “Refrescos Americanas LTDA”, ”Carlos Diaz”, “Av. das Americanas
12.890”, “São Paulo”, “5442”, “Brazil”, “(11) 555 4640”);
INSERT INTO Category VALUES (1, "Beverages", "Soft drinks, coffees, teas,
beers, and ales"), (2, "Condiments", "Sweet and savory sauces, relishes,
spreads, and seasonings"), (3, "Confections", "Desserts, candies, and sweet
breads"), (4, "Dairy Products", "Cheeses"), (5, "Grains/Cereals", "Breads,
crackers, pasta, and cereal"), (6, "Meat/Poultry", "Prepared meats"), (7,
"Produce", "Dried fruit and bean curd"), (8, "Seafood", "Seaweed and fish");
INSERT INTO Employee VALUES (“1”, "Davolio", "Nancy", "1968-12-08",
"[Link]", "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'."), (“2”, "Fuller", "Andrew", "1952-02-19",
"[Link]", "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."), (“3”, "Leverling", "Janet", "1963-08-30",
"[Link]", "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."), (“4”, "Peacock", "Margaret", "1958-09-19", "[Link]",
"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."), (“5”,
"Buchanan", "Steven", "1955-03-04", "[Link]", "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."), (“6”, "Suyama", "Michael", "1963-07-
02", "[Link]", "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."), (“7”, "King", "Robert", "1960-05-29",
"[Link]", "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."), (“8”,
"Callahan", "Laura", "1958-01-09", "[Link]", "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."), (“9”, "Dodsworth",
"Anne", "1969-07-02", "[Link]", "Anne has a BA degree in English from
St. Lawrence College. She is fluent in French and German."));
INSERT INTO OrderDetail VALUES ("1", "10248", "11", "12"), ("2", "10248",
"42", "10"), ("3", "10248", "72", "5"), ("4", "10249", "14", "9"), ("5", "10249",
"51", "40"), ("6", "10250", "41", "10"), ("7", "10250", "51", "35"), ("8",
"10250", "65", "15"), ("9", "10251", "22", "6"), ("10", "10251", "57", "15"));
INSERT INTO Product VALUES ("1", "Chais", "1", "1", "10 boxes x 20 bags",
"18.00"), ("2", "Chang", "1", "1", "24 - 12 oz bottles", "19.00"), ("3", "Aniseed
Syrup", "1", "2", "12 - 550 ml bottles", "10.00"), ("4", "Chef Anton's Cajun
Seasoning", "2", "2", "48 - 6 oz jars", "22.00"), ("5", "Chef Anton's Gumbo
Mix", "2", "2", "36 boxes", "21.35"), ("6", "Grandma's Boysenberry Spread",
"3", "2", "12 - 8 oz jars", "25.00"), ("7", "Uncle Bob's Organic Dried Pears",
"3", "7", "12 - 1 lb pkgs.", "30.00"), ("8", "Northwoods Cranberry Sauce", "3",
"2", "12 - 12 oz jars", "40.00"), ("9", "Mishi Kobe Niku", "4", "6", "18 - 500 g
pkgs.", "97.00"), ("10", "Ikura", "4", "8", "12 - 200 ml jars", "31.00"));
INSERT INTO Order1 VALUES ("10248", "90", "5", "1996-07-04", "3"),
("10249", "81", "6", "1996-07-05", "1"), ("10250", "34", "4", "1996-07-08",
"2"), ("10251", "84", "3", "1996-07-08", "1"), ("10252", "76", "4", "1996-07-
09", "2"), ("10253", "34", "3", "1996-07-10", "2"), ("10254", "14", "5", "1996-
07-11", "2"), ("10255", "68", "9", "1996-07-12", "3"), ("10256", "88", "3",
"1996-07-15", "2"), ("10257", "35", "4", "1996-07-16", "3"));