The Data Layer

The Transact database has two types of tables: those that store product and pricing information (as shown in Figure 17-3) and those that store order and shipment information (as shown in Figure 17-4).

Product tables

Figure 17-3. Product tables

Order tables

Figure 17-4. Order tables

A standard order consists of one or more computers, each of which is entered separately in the OrderStations table. Each computer is composed of several parts (a CPU, a hard drive, a motherboard, and so on), each of which is represented by a separate record in the OrderItems table. A record ...

Get Microsoft® .NET Distributed Applications: Integrating XML Web Services and .NET Remoting now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.