Database Reference
In-Depth Information
Here are the steps to open the dbo.Authors table:
1.
locate the dbo.Authors 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-13
).
In the authors table it is pretty clear that the author's first and last name are Must Have attributes. However,
the author's phone number and address data are less so. Keeping things simple, you might want to leave out
these unnecessary columns. They do not take up much space; however, when you are trying to keep things
as clean and uncluttered as possible, removing things that are unnecessary is the easiest way to accomplish
this goal. Therefore, let's keep the author's name columns as Must Have and the other columns as only nice
to Have. (It may be that in another version of the data warehouse this priority list will change.)
3.
Close the query window by clicking the
x
on this window's tab.
Reviewing the Data in the TitleAuthor Table
The table that connects the titles and authors together in a many-to-many relationship is the dbo.TitleAuthor
table. let's look at this table next (Figure
3-14
).
Figure 3-14.
The titleauthor table
