• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Understanding Relationships > Final List of Fields and Relationships

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
Synopsis  NotesBiographyOccupation
Notes    Year Started
     Year Ended
     Notes
PK=Primary key; CPK=Composite primary key; FK=Foreign key



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint