w3pop.com :: 网络学院 :: APPML :: 案例研究：数据库
案例研究：数据库 
The AppML Case study uses the Northwind database.
AppML案例研究使用了North 数据库。
The Northwind Database
Northwind 数据库
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张表中：
- Customers
客户
- Suppliers
供应商
- Products
产品
- Categories
目录
- Orders
订单
- Order Details
订单细则
- Shippers
托运人
- Employees
雇员
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.
数据库表单输出样本如下表。为了节省空间，我们并不现实所有的表。我们还去掉了相应的行和列。
Northwind Customers
Northwind 客户
| 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 |
Northwind Suppliers
Northwind 供应商
| 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 |
Northwind Products
Northwind 产品
| 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
Northwind 订单
| 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 |
Northwind Employees
Northwind 雇员
| 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 |
评论 (0)
All
