This diagram contains the same Customers, Orders, Order Lines, and Products schemes that we have discussed before. Here the attributes customer first name and customer last name in the Customer relation are highlighted to show that they are "input" to the query, in other words part of the WHERE clause. The product name attribute in the Products table is highlighted to show that is the "output" of the query, in other words part of the SELECT attribute list.

Return to main page