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

Chapter 4. Establishing Relationships > Viewing and Creating Relationships

Viewing and Creating Relationships

In Chapter 2, “Database Design,” you developed tables and fields for the Classic TV database. In Chapter 3, you identified the existing relationships between tables and developed the final field list shown in Table 4.1. (If you haven't read these two chapters, I strongly encourage you to do so before proceeding.)

Table 4.1. Classic TV Database Final Field List
ProgramsBroadcastsGenresNetworksActorsRoles
ProgramID PKProgramID CPK/FKGenreID PKNetworkID PKActorID PKProgramID CPK/FK
ProgNameNetworkID CPK/FKGenreNameNetwOfficial NameActorFirst NameActorID CPK/FK
GenreID FKBrdYearStartGenreDescrNetwPopular NameActorLast NameRoleFirst Name
ProgLocationBrdYearEnd NetwFounderActorGenderRoleLast Name
ProgSynopsis  NetwNotesActorBioRoleYear Start
ProgNotesRoleYearEnd
RoleNotes
RoleOccup
Note: Actual field names contain no spaces (e.g. RoleYear Start is RoleYearStart).



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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