HOME

AppML
AppML HOME

Web Applications
Web Services
Web Solution

AppML Intro
AppML How To
AppML Elements
AppML Services
AppML Document
AppML Database
AppML Reports
AppML Filters
AppML Lists
AppML Forms
AppML XML
AppML Partners

Case Study
Case Intro
Case Database
Case How To
Case HTML Reports
Case Corporate
Case HTML Forms
Case Application


Please visit our sponsors !

Case Study Database

previous next

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.


previous next

Jump to: Top of Page or HOME or Printer Friendly 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


Validate How we converted to XHTML Validate

IISCart
ASP Ecommerce & Shopping Cart


Your own Web Site?

Read W3Schools
Hosting Tutorial



$15 Domain Name
Registration
Save $20 / year!



Advertise
at W3Schools

Only 0.5 CPM



SELECTED LINKS

University Online
Master Degree
Bachelor Degree


Web Software

The Future of
Web Development


Jobs and Careers

Web Security
Web Statistics
Web Standards


PARTNERS

W3Schools
TopXML
VisualBuilder
XMLPitstop
DevelopersDex
DevGuru
Programmers Heaven
The Code Project
Tek Tips Forum
ZVON.ORG
TopXML Search