当前位置: 首页 > 网络学院 > 客户端脚本教程 > APPML > 案例研究:数据库
The AppML Case study uses the Northwind database.
AppML案例研究使用了North 数据库。
The Northwind company has a traditional database model with data about customers, suppliers, products, orders, and employees.
Northwind 公司包含了一个关于客户数据、供应方数据、产品数据和雇员数据的传统数据库模型。
The information is stored in a database with 8 tables:
这份信息存储在数据库的8张表中:
Sample output from the database tables is displayed below. To save space we don't display all tables. We have also reduced the number of columns and rows.
数据库表单输出样本如下表。为了节省空间,我们并不现实所有的表。我们还去掉了相应的行和列。
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韆 | Mataderos 2312 | M閤ico D.F. | Mexico |
Around the Horn | 120 Hanover Sq. | London | UK |
Berglunds snabbk鰌 | Berguvsv鋑en 8 | Lule?/td> | Sweden |
Blauer See Delikatessen | Forsterstr. 57 | Mannheim | Germany |
Blondel p鑢e et fils | 24, place Kl閎er | Strasbourg | France |
B髄ido Comidas preparadas | C/ Araquil, 67 | Madrid | Spain |
Bon app' | 12, rue des Bouchers | Marseille | France |
Bottom-Dollar Markets | 23 Tsawassen Blvd. | Tsawassen | Canada |
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鋍kebr鰀 AB | Kaloadagatan 13 | G鰐eborg | Sweden |
Refrescos Americanas LTDA | Av. das Americanas 12.890 | S鉶 Paulo | Brazil |
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 |
CustomerID 客户ID | OrderDate 订购日期 | ShipAddress 装船地址 | ShipCity 装船城市 | ShipCountry 装船国家 |
---|---|---|---|---|
VINET | 7/4/1996 | 59 rue de l | Reims | France |
TOMSP | 7/5/1996 | Luisenstr. 48 | M黱ster | 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鏾, 67 | Rio de Janeiro | Brazil |
CHOPS | 7/11/1996 | Hauptstr. 31 | Bern | Switzerland |
RICSU | 7/12/1996 | Starenweg 5 | Gen鑦e | 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骲al | Venezuela |
ERNSH | 7/17/1996 | Kirchgasse 6 | Graz | Austria |
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 |