Please visit our sponsors !
Case Study Database
The AppML Case study uses the Northwind database.
The Northwind Database
The Northwind company has a traditional database model with data about
customers, suppliers, products and orders. They also have information about their
employees in their database.
This information is stored in a database with 5 tables:
- Customers
- Suppliers
- Products
- Orders
- Employees
Sample output from the database tables is displayed below. To save
space, we have only displayed 10 rows from each table, and we have also removed
some of the
columns.
Northwind Customers
CompanyName |
Address |
City |
Country |
Alfreds Futterkiste |
Obere Str. 57 |
Berlin |
Germany |
Ana Trujillo Emparedados y heladoso |
Avda. de la Constituci 222 |
Mexico D.F. |
Mexico |
Antonio Moreno Taquería |
Mataderos 2312 |
México D.F. |
Mexico |
Around the Horn |
120 Hanover Sq. |
London |
UK |
Berglunds snabbköp |
Berguvsvägen 8 |
Luleå |
Sweden |
Blauer See Delikatessen |
Forsterstr. 57 |
Mannheim |
Germany |
Blondel père et fils |
24, place Kléber |
Strasbourg |
France |
Bólido Comidas preparadas |
C/ Araquil, 67 |
Madrid |
Spain |
Bon app' |
12, rue des Bouchers |
Marseille |
France |
Bottom-Dollar Markets |
23 Tsawassen Blvd. |
Tsawassen |
Canada |
Northwind Suppliers
CompanyName |
Address |
City |
Country |
Exotic Liquid |
49 Gilbert St. |
London |
UK |
New Orleans Cajun Delights |
P.O. Box 78934 |
New Orleans |
USA |
Grandma Kelly's Homestead |
707 Oxford Rd. |
Ann Arbor |
USA |
Tokyo Traders |
9-8 SekimaiMusashino-shi |
Tokyo |
Japan |
Cooperativa de Quesos 'Las Cabras' |
Calle del Rosal 4 |
Oviedo |
Spain |
Mayumi's |
92 Setsuko Chuo-ku |
Osaka |
Japan |
Pavlova, Ltd. |
74 Rose St. Moonie Ponds |
Melbourne |
Australia |
Specialty Biscuits, Ltd. |
29 King's Way |
Manchester |
UK |
PB Knäckebröd AB |
Kaloadagatan 13 |
Göteborg |
Sweden |
Refrescos Americanas LTDA |
Av. das Americanas 12.890 |
São Paulo |
Brazil |
Northwind Products
ProductName |
QuantityPerUnit |
UnitPrice |
UnitsInStock |
Chai |
10 boxes x 20 bags |
18 |
39 |
Chang |
24 - 12 oz bottles |
19 |
17 |
Aniseed Syrup |
12 - 550 ml bottles |
10 |
13 |
Chai |
10 boxes x 20 bags |
18 |
39 |
Chef Anton's Gumbo Mix |
36 boxes |
21 |
0 |
Grandma's Boysenberry Spread |
12 - 8 oz jars |
25 |
120 |
Uncle Bob's Organic Dried Pears |
12 - 1 lb pkgs. |
30 |
15 |
Northwoods Cranberry Sauce |
12 - 12 oz jars |
40 |
6 |
Mishi Kobe Niku |
18 - 500 g pkgs. |
97 |
29 |
Ikura |
12 - 200 ml jars |
31 |
31 |
Northwind Orders
CustomerID |
OrderDate |
ShipAddress |
ShipCity |
ShipCountry |
VINET |
7/4/1996 |
59 rue de l |
Reims |
France |
TOMSP |
7/5/1996 |
Luisenstr. 48 |
Münster |
Germany |
VICTE |
7/8/1996 |
2, rue du Commerce |
Lyon |
France |
SUPRD |
7/9/1996 |
Boulevard Tirou, 255 |
Charleroi |
Belgium |
HANAR |
7/10/1996 |
Rua do Paço, 67 |
Rio de Janeiro |
Brazil |
CHOPS |
7/11/1996 |
Hauptstr. 31 |
Bern |
Switzerland |
RICSU |
7/12/1996 |
Starenweg 5 |
Genève |
Switzerland |
WELLI |
7/15/1996 |
Rua do Mercado, 12 |
Resende |
Brazil |
HILAA |
7/16/1996 |
Carrera 22 con Ave. Carlos Soublette #8-35 |
San Cristóbal |
Venezuela |
ERNSH |
7/17/1996 |
Kirchgasse 6 |
Graz |
Austria |
Northwind Employees
LastName |
FirstName |
Title |
Davolio |
Nancy |
Sales Representative |
Fuller |
Andrew |
Vice President, Sales |
Leverling |
Janet |
Sales Representative |
Peacock |
Margaret |
Sales Representative |
Buchanan |
Steven |
Sales Manager |
Suyama |
Michael |
Sales Representative |
King |
Robert |
Sales Representative |
Callahan |
Laura |
Inside Sales Coordinator |
Dodsworth |
Anne |
Sales Representative |
Explore Microsoft's Northwind Traders Database
The Northwind Traders sample database, which ships with Microsoft Access,
provides lots of useful Microsoft Access database information.
The Tour of Northwind Traders on the World Wide Web is designed to give you
insight into how the features of the Northwind Traders database were
implemented. It is also designed to show you how the entire Northwind Traders
database works together as a database application. The tour provides:
- Solutions to common Microsoft Access questions as demonstrated in
Northwind Traders.
- An in-depth look at the Northwind Traders sample database.
- Illustrated examples and demonstrations of how to implement features of
the Northwind Traders database in your own database application.
Click
here to Explore Microsoft's Northwind Traders Database
Development Partners Wanted
Refsnes Data has just completed a large development project based on AppML. It has
been estimated by our developers that development time has been reduced by 75%
compared to ordinary web development.
For new projects and for development of next generation AppML web services,
Refsnes Data is seeking new development partners. Read more.
Jump to: Top of Page
or HOME or
Printer friendly page
Search W3Schools:
What Others Say About Us
Does the world know about us? Check out these places:
Dogpile
Alta Vista
MSN
Google
Excite
Lycos
Yahoo
Ask Jeeves
We Help You For Free. You Can Help Us!
W3Schools is for training only. We do not warrant its correctness or its fitness for use.
The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our
terms of use and
privacy policy.
Copyright 1999-2002 by Refsnes Data. All Rights Reserved
|