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.)
| Programs | Broadcasts | Genres | Networks | Actors | Roles |
|---|---|---|---|---|---|
| ProgramID PK | ProgramID CPK/FK | GenreID PK | NetworkID PK | ActorID PK | ProgramID CPK/FK |
| ProgName | NetworkID CPK/FK | GenreName | NetwOfficial Name | ActorFirst Name | ActorID CPK/FK |
| GenreID FK | BrdYearStart | GenreDescr | NetwPopular Name | ActorLast Name | RoleFirst Name |
| ProgLocation | BrdYearEnd | NetwFounder | ActorGender | RoleLast Name | |
| ProgSynopsis | NetwNotes ... |
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.
