Microsoft Access

profilecollege29
classictvchap4allrelationships.accdb
Home>Information Systems homework help>Microsoft Access
ActorID ActorLastName ActorFirstName ActorGender ActorBio
1 Griffith Andy Male
2 Knotts Don Male
3 Howard Ron Male Grew up to be an Oscar winning director
4 Nabors Jim Male
5 Winkler Henry Male
6 Bosley Tom Male
7 Newhart Bob Male
8 Pleshette Suzanne Female
9 Foxx Red Male Played junk dealer in movie Cotton Comes to Harlem
10 Wilson Lamont Male
11 Poston Tom Male
12 Ball Lucille Female
13 Arnaz Desi Male
15 Vance Vivian Female
16 Young Alan Male
17 Moore Mary Tyler Female
18 Harper Valerie Female
19 Van Dyke Dick Male
20 Montgomery Elizabeth Female
21 York Dick Male
22 Sargent Dick Male
23 Randall Tony Male
24 Klugman Jack Male
25 Morrow Rob Male
26 Turner Janine Female
27 Alda Alan Male
28 Stevenson McLean Male
29 Farrell Mike Male
30 Burghoff Gary Male
31 Morgan Henry Male
32 Swit Loretta Female
33 O'Neill Ed Male
34 Sagal Katey Female
35 Applegate Christina Female
36 Faustino David Male
37 Church Thomas Male
38 Messing Debra Male
ProgramID NetworkID BrdYearStart BrdYearEnd
1 1 10/1/60 9/1/68
2 3 1/1/74 7/1/84
3 1 9/1/72 8/1/78
4 1 10/1/82 9/1/90
5 2 1/1/72 9/1/77
6 1 10/1/51 10/1/57
7 1 10/1/62 9/1/68
9 2 1/1/86 5/1/93
9 3 5/2/93 6/30/95
10 1 1/1/61 9/1/66
11 1 9/1/70 9/1/77
12 1 9/1/74 12/1/78
13 1 10/1/61 9/1/66
14 3 9/1/64 7/1/72
15 3 9/1/70 7/1/75
16 1 10/1/59 6/19/64
17 1 7/1/90 7/1/95
18 1 9/1/72 2/1/83
19 4 4/1/87 5/1/97
20 2 1/1/68 1/1/73
21 4 9/1/95 1/1/97
GenreID GenreName GenreDescr
1 Rural Comedy Primarily rural setting and characters, such as The Andy Griffith Show or Petticoat Junction.
2 Social Comedy Comedy as social commentary. Example would be All in the Family, M*A*S*H*.
3 General Drama General category for drama; excludes police and hospital dramas.
4 Police Drama Primary setting, characters, and themes revolve around police work, such as Hill Street Blues.
5 Urban Comedy Primarily urban setting, themes, and characters, eg, The Bob Newhart Show, Friends
6 Hospital Drama Primary setting is hospital, such as ER.
7 General Comedy General category for comedy; includes shows like Leave It To beaver.
8 Miscellaneous All other programs that defy categorization
NetworkID NetwOfficialName NetwPopularName NetwFounder NetwNotes
1 Columbia Broadcasting System CBS William Paley CBS was one of the largest radio networks in the 1930s and, along with NBC, the earliest broadcaster of regularly scheduled programs in 1941.
2 National Broadcasting Company NBC David Sarnoff
3 American Broadcasting Company ABC Leonard Goldenson In the 1950s, ABC was the fourth network, after the now-defunct Dumont. By the Seventies it had managed to become a ratings leader.
4 FOX Television FOX Rupert Murdoch Barry Diller was instrumental in starting up Fox. Started in the mid-1980's, its initial programs were a late-night talk show with Joan Rivers and then Married with Children.
ProgramID ProgName GenreID ProgLocation ProgSynopsis ProgNotes
1 The Andy Griffith Show 1 Mayberry, NC Sheriff Andy Taylor, a widower, raises his young son in Mayberry, a small town in North Carolina Spin-offs were Gomer Pyle, USMC and Mayberry RFD
2 Happy Days 7 Milwaukee First show of producer Garry Marshall
3 The Bob Newhart Show 5 Chicago Psychiatrist Bob Hartley tends to his motley crew of patients and his lovely wife in Chicago
4 Newhart 1 Norwich, Vermont
5 Sanford & Son 7 Los Angeles Fred Sanford and his son Lamont struggle to make their junk business pay the bills in Los Angeles.
6 I Love Lucy 5 New York Wacky but lovable Lucy Ricardo is always cooking up trouble for her bandleader husband Ricky and their landlords Fred and Ethel, all of whom live together in a New York apartment
7 The Lucy Show 7 Danfield, CT; San Francisco, CA Lucy Show changed locale to San Francisco in 1965, where Lucy played a secretary to Mr. Mooney.
9 Matlock 4 Show ran on NBC through 1993 and then on ABC
10 Mister Ed 7 Ed the talking horse always has something important to say, but only to his kindly owner Wilbur
11 The Mary Tyler Moore Show 5 Minneapolis Single, turning 30, Mary Richards finds love and friendship in Minneapolis, where she works for her gruff but warm station manager Lou
12 Rhoda 5 New York Rhoda is happily married, then alone again, as is, eventually her mother
13 The Dick Van Dyke Show 5 New Rochelle, NY Rob Petrie, head comedy writer of the Allan Brady Show, and his lovely wife Laura enjoy life in suburban New York.
14 Bewitched 7 Westport, CT There's toil and trouble, but lots of laughs, when Samantha the Witch marries ad exec Darrin (or Derwood, as her mother calls him). A 1977 spin-off called Tabitha failed quickly.
15 The Odd Couple 5 New York Neatnik photographer Felix Unger and sloppy sportswriter Oscar Madison try to avoid killing each other in their New York apartment
16 The Twilight Zone 8 The Twilight Zone (where else?) The signpost up ahead says lots of great acting and writing in these tales of the mysterious and supernatural.
17 Northern Exposure 3 Cicely, AK New York Jewish doctor Fleischmann (as his love/hate romantic interest Maggie calls him) is forced to serve a stint in Cicely, Alaska and becomes a person.
18 MASH 3 Korea Tales of the 4077 MASH unit as they try to save their patients and themselves during the Korean War
19 Married with Children 7 Chicago suburbs The Bundys: shoe salesman Al, Oprah-watching wife Peg, carefree daughter Kelly, and pathetic son Bud make trouble for themselves but mostly their neighbors
20 Rowan & Martin's Laugh-In 3 Comedy variety show with lots of laughs and more than a little social commentary
21 Ned & Stacey 5 New York Stacey pretends to be the wife of ad exec Ned to help him in business and gets to live in a fancy New York apartment
ProgramID ActorID RoleFirstName RoleLastName RoleYearStart RoleYearEnd RoleNotes RoleOccup
1 1 Andy Taylor Taylor 10/1/60 9/1/68 Sheriff
9 1 Benjamin Leighton Matlock 1/1/86 5/1/95 Defense Attorney
1 2 Barney Fife Fife 10/1/60 9/1/65 Sheriff's deputy
9 2 Les Calhoun Calhoun 1/1/89 1/1/91 Made several guest appearances Matlock's neighbor
1 3 Opie Taylor Opie 10/1/60 9/1/68 Grade school student
2 3 Richie Cunningham Cunningham 1/1/74 9/1/80 Student
1 4 Gomer Pyle Pyle 10/1/63 9/1/64 Marine private
2 5 Arthur Fonzarelli 1/1/74 7/1/84 Known as Fonzie or "the Fonz" Motorcyclist
2 6 Howard Cunningham Cunningham 1/1/74 7/1/84 Hardware store owner
3 7 Robert Hartley 1/1/72 8/1/78 Psychologist
4 7 Dick Loudon 10/1/82 9/1/90 Inn owner
3 8 Emily Hartley 1/1/72 8/1/78 Teacher
5 9 Fred Sanford 1/1/72 9/1/77 Foxx had stormy relationship with producers, whom he publicly criticized. Junk dealer
5 10 Lamont Sanford 1/1/72 9/1/77 Junk dealer's son
4 11 George Utley 10/1/82 9/1/90 Inn handyman
6 12 Lucy Ricardo 10/1/51 10/1/59 Housewife
7 12 Lucy Carmichael 10/1/62 9/1/68 Widow, mother of two
6 13 Ricky Ricardo 10/1/51 10/1/59 Band leader
7 15 Vivian Bagley 1/1/62 1/1/65 Divorcee
10 16 Wilbur Post 1/1/61 9/1/66 Architect; horse owner
11 17 Mary Richards 9/1/70 9/1/77 TV Executive Assistant
13 17 Laura Petrie 10/1/61 9/1/66 Housewife
11 18 Rhoda Morgenstern 9/1/70 1/1/74 Window decorator
12 18 Rhoda Morgenstern 9/1/74 12/1/78 Window decorator
13 19 Rob Petrie 10/1/61 9/1/66 Comedy writer
14 20 Samantha Stevens 9/1/64 7/1/72 Witch
14 21 Darrin Stevens 1/1/64 1/1/69 Advertising Executive
14 22 Darrin Stevens 1/1/69 1/1/72 Advertising Executive
15 23 Felix Unger 9/1/70 7/1/75 Photographer; apartment mate
15 24 Oscar Madison 9/1/70 7/1/75 Sportswriter; apartment mate
16 25 Joel Fleischman 7/1/90 7/1/95 Doctor
16 26 Maggie O'Connell 7/1/90 7/1/95 Airplane pilot
18 27 Capt. Benjamin Franklin Pierce 9/1/72 2/1/83 Known as "Hawkeye" Surgeon
18 28 Lt. Col. Henry Blake 1/1/72 1/1/75 Surgeon
18 29 Capt. B J Hunnicut 1/1/75 1/1/83 Surgeon
18 30 Cpl. Radar O'Reilly 1/1/72 1/1/79 Army Clerk
18 31 Col. Sherman Potter 1/1/75 1/1/83 Surgeon
18 32 Maj. Margaret Hoolihan 9/1/72 2/1/83 Known as "Hot Lips" Chief Nurse
19 33 Al Bundy 4/1/87 5/1/97 Shoe salesman
19 34 Peg Bundy 4/1/87 5/1/97 Housewife
19 35 Kelly Bundy 4/1/87 5/1/97 Student, waitress, model
19 36 Bud Bundy 4/1/87 5/1/97 Student, promoter
21 37 Stacey Colbert Dorsey 9/1/95 1/1/97 Journalist; The bride
21 38 Ned Dorsey 9/1/95 1/1/97 Ad exec: The groom
SELECT Genres.GenreID, Genres.GenreName FROM Genres;
SELECT DISTINCTROW * FROM Programs;