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

登陆 | 还没注册？