O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table 3.26. The Final List of Tables and Fields for the Classic TV Database
ProgramsBroadcastsGenresNetworksActorsRoles
ProgramID PKProgramID CPK/FKGenreID PKNetworkID PKActorID PKProgramIDCPK/FK
GenreID FKNetworkID CPK/FKGenreOfficialNameFirst NameActorID CPK/FK
NameYear StartedDescriptionPopularNameLast NameFirst Name
LocationYear Ended FounderGenderLast Name ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required