Progress
Language Tutorial
for Windows


Introduction to the sports Database Schema

Now that you have accessed the Data Dictionary and connected your copy of the sports database, take a moment to review the descriptions of the sports database tables found in Table 4–2. Understanding the purpose of tables gives you a general idea about the function of the database.

Table 4–2: Tables in the sports Database 
Table
Contents
Customer
Customer information, such as customer name, address, phone number, and credit limit.
Invoice
Accounting information, such as order number, invoice number, and billing total.
Item
Inventory information, such as item name, catalog description, and price.
Local-Default
Information for working with international customers, such as country name, currency, and postal format.
Order
Order form information, such as order date, shipping date, and postal carrier.
Order-Line
Information relevant to a request for one item in a particular order, such as item number, quantity, price, and associated order number.
Ref-Call
Customer call information, such as call number and reason for call.
Salesrep
Sales representative information, such as name, region, and monthly quota.
State
State information, such as state name, abbreviation, and region.

As you can conclude from these descriptions, this database holds the information necessary for All Around Sports to take orders, process orders, bill for orders, and keep inventory information up to date.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095