The Sample Database:
The sample database contains five tables. Each table stores information about one
particular kind of entity:
• The CUSTOMERS table stores data about each customer, such as the company name,
credit limit, and the salesperson who calls on the customer.
• The SALESREPS table stores the employee number, name, age, year-to-date sales,
and other data about each salesperson.
• The OFFICES table stores data about each of the five sales offices, including the city
where the office is located, the sales region to which it belongs, and so on.
•The ORDERS table keeps track of every order placed by a customer, identifying the
salesperson who took the order, the product ordered, the quantity and amount of the
order, and so on. For simplicity, each order is for only one product.
• The PRODUCTS table stores data about each product available for sale, such as the
manufacturer, product number, description, and price.
