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.
Programs | Broadcasts | Genres | Networks | Actors | Roles |
---|---|---|---|---|---|
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 ... |
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.