Database Reference
In-Depth Information
Figure 3-17.
The royalty schedule table
Here are the steps to open the roysched table:
1.
locate the dbo.RoySched table in the treeview list and right-click this table to
access the context menu.
2.
Choose Select Top 1000 Rows from the context menu. SQl Management Studio will
create a query window, execute the query, and show you the results (Figure
3-17
).
In this table you see data that represents the amount of royalties paid on a particular book based on the
range of sales. When a book sells from 0 to 5,000 copies the royalty paid is 10%. However, when book sales
reach between 5,001 and 50,000, the royalty percentage goes up to 12%. Because royalties are paid by the
publisher to the authors and not by the wholesaling company who we are building the BI solution for, this
information is irrelevant.
Reviewing the Data in the Employee Table
Another excluded table was the dbo.Employee table. At first glance, information about employees could prove
useful to providing sales information. In most cases, this would be a true assumption; however, in the pubs
database this is not the case. On closer inspection, we see that the employee table (Figure
3-18
) provides a
list of employees who only work at a particular publishing house, and the table is classified as not needed.
