This case study demonstrates how to build a complete < AppML > Internet application with the ability to enumerate, edit, and search for information against several tables in the database. We will use the existing database, named Demo. For each table in the database, we will: Create a prototype model Create a prototype HTML page Create an application model Create a HTML template Create a complete application For the case study, we used a subset of the Northwind database pre-installed with MS Office. This database is well known and is easy to test, whether using PHP or classic ASP or ASP.NET. The Demo database contains several tables with data, as follows: Customer Address City Country Around the Horn 120 Hanover Sq. London UK Berglunds snabbkj ø p Berguvsv ä gen 8 Lule å Sweden Blauer See Delikatessen Forsterstr. fifty-seven Mannheim Germany Blondel p è re et fils 24, place Kl é ber Strasbourg France B ó lido Comidas preparadas C/ Araquil, 67 Madrid Spain Bottom-Dollar Markets 23 Tsawassen Blvd. Tsawassen Canada Supplier 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 SekimaiMusashin o-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 Produc 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-500g pkgs. 97 29 Ikura 12-200 ml jars 31 31 4.6.1. What will we create? ¶
4.6.2. Demo database ¶
4.6.3. Customers ¶
4.6.4. Suppliers ¶
4.6.5. Products ¶