Once you have added the necessary key attributes that support relationships, you have arrived at a set of relational tables: the attributes are now columns, and the key values are now key columns. From what has been done so far, you can see a set of relational tables emerging, as follows ( * indicates a key column):
Table 2-2 Columns and Keys for Four Tables
| Albums Table | Selections Table | Composers Table | Log Table |
|---|
| *AlbumCode | *AlbumCode | *ComposerName | *AlbumCode |
| AlbumTitle | *SelectionName | Birth | *SelectionName |
| Medium | ComposerName | Death | StartTime |
| AlbumCost | Timing | Birthplace | EndTime |
| RecordingCo | Performers | Comment | Announcer |
| DateRecorded | | | |
| MfgCode | | | |
| Comment | | | |
Note that the Selections and Log tables each have two key columns, whereas the other tables have only one apiece. Remember that a key must uniquely identify each entry in the table.
Printable version
