Final List of Fields and Relationships
Table 3.26 shows the final list of tables and fields for the Classic TV database. The method I described for developing it took shortcuts and half-measures. In a real-world situation, you would want to take additional measures to ensure that you had collected all the fields you needed and that they were sufficient to accomplish your mission objectives.
|ProgramID PK||ProgramID CPK/FK||GenreID PK||NetworkID PK||ActorID PK||ProgramIDCPK/FK|
|GenreID FK||NetworkID CPK/FK||Genre||OfficialName||First Name||ActorID CPK/FK|
|Name||Year Started||Description||PopularName||Last Name||First Name|
|Location||Year Ended||Founder||Gender||Last Name ...|