Let's get back to developing the Classic TV database. Table 2.6 shows the current list of fields. The list has been modified from that in Table 2.2 to reflect our bad experience with multiple actor fields in the “one-table-fits-all” solution. Thus, instead of fields for Actor Name #1, Actor Name #2, and so on there is just one Actor Name field. The same is true for Actor Gender, Actor Biography, and Character Name/Occupation.
|Revised Field List|
|Field||Field Description||Sample Value|
|Program Name||Official title of show||Bewitched|
|Network Official Name||Official name of network||American Broadcasting Company|
|Network Popular Name||Abbreviation of official name||ABC|
|Network Founder||Leading organizer||Leonard Goldenson ...|