The best AppML Case Introduction Tutorial In 2024, In this tutorial you can learn What we will create,Demo Database,Customers,Suppliers,Products,
This case study demonstrates how to build a complete <AppML> Internet applications, with information listed for a number of tables in the database, edit and search functions.
We will use the existing database, called Demo.
For each table in the database, we will:
For the case study, we used a subset of MS Office preinstalled Northwind database.
This database is known, either use PHP or classic ASP or is ASP.NET, are easy to test.
Demo database contains several tables with data, as follows:
Customer | Address | City | Country |
---|---|---|---|
Around the Horn | 120 Hanover Sq. | London | UK |
Berglunds snabbkjp | Berguvsvagen 8 | Lulea | Sweden |
Blauer See Delikatessen | Forsterstr. 57 | Mannheim | Germany |
Blondel pere et fils | 24, place Kleber | Strasbourg | France |
Bolido 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 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 |
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 - 500 g pkgs. | 97 | 29 |
Ikura | 12 - 200 ml jars | 31 | 31 |