Databases Reference
In-Depth Information
b. There is a need to retrieve AFFILIATION table
records directly based on batting averages.
c. The three-attribute primary key of the WORK
EXPERIENCE table has been found to be cum-
bersome to use in queries and awkward to index.
d. There is a frequent very high-priority need to quickly
retrieve player name and age data together with the
teams (identified by team number) they have played
on, the number of years they played on the teams,
and the batting averages they compiled.
e. Assume that we add the following Stadium table
to the Super Baseball League relational database.
Each team has one home stadium, which is what
is represented in this table. Assume that a stadium
can serve as the home stadium for only one team.
Stadium name is unique across the league.
STADIUM Table
Stadium
Year
Team
−−−−−
Name
Built
Size
Number
−−−−−−−
There is a frequent high-priority need to quickly
retrieve detailed team and stadium data together.
Search WWH ::
Custom Search