Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production SQL> select * from actors; NAME -------------------------------------------------------------------------------- WEBSITE -------------------------------------------------------------------------------- Patrick Stewart http://www.startrek.com/library/bios.asp?ID=69063 Jonathan Frakes http://www.startrek.com/library/bios.asp?ID=69066 Brent Spiner http://www.startrek.com/library/bios.asp?ID=69070 NAME -------------------------------------------------------------------------------- WEBSITE -------------------------------------------------------------------------------- LeVar Burton http://www.startrek.com/library/bios.asp?ID=69064 Gates McFadden http://www.startrek.com/library/bios.asp?ID=69068 Marina Sirtis http://www.startrek.com/library/bios.asp?ID=69069 NAME -------------------------------------------------------------------------------- WEBSITE -------------------------------------------------------------------------------- Michael Dorn http://www.startrek.com/library/bios.asp?ID=69065 Wil Wheaton http://meltingpot.fortunecity.com/belgium/49/wil.htm Whoopi Goldberg http://www.startrek.com/library/bios.asp?ID=69067 NAME -------------------------------------------------------------------------------- WEBSITE -------------------------------------------------------------------------------- Denise Crosby http://www.david-m-nienow.com/crosby/ 10 rows selected. SQL> select * from characters; NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Jean-Luc Picard Captain Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- William T. Riker First Officer Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Data Lt. Commander Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Geordi LaForge Chief Engineer Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Beverly Crusher Doctor Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Deanna Troi Counselor Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Guinan Bartender Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Wesley Crusher Ensign Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Tasha Yar Security Star Trek: The Next Generation Gene Roddenberry NAME -------------------------------------------------------------------------------- TITLEORROLE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Worf Security Star Trek: The Next Generation Gene Roddenberry 10 rows selected. SQL> select title from episodes; TITLE -------------------------------------------------------------------------------- Encounter at Farpoint, Part 1 The Child Evolution The Best of Both Worlds, Part 2 Redemption, Part 2 Time's Arrow, Part 2 Descent, Part 2 All Good Things... 8 rows selected. SQL> select * from series; TITLE -------------------------------------------------------------------------------- CREATOR -------------------------------------------------------------------------------- WEBSITE -------------------------------------------------------------------------------- STARTDATE ENDDATE --------- --------- Star Trek: The Next Generation Gene Roddenberry http://www.startrek.com 28-SEP-87 23-MAY-94 TITLE -------------------------------------------------------------------------------- CREATOR -------------------------------------------------------------------------------- WEBSITE -------------------------------------------------------------------------------- STARTDATE ENDDATE --------- --------- The Simpsons Matt Groening http://www.thesimpsons.com 17-DEC-89 22-APR-00 SQL> select * from studios; NAME -------------------------------------------------------------------------------- ADDRESS -------------------------------------------------------------------------------- WEBSITE -------------------------------------------------------------------------------- Fox P.O. Box 900, Beverly Hills, CA 90213-0900 http://www.fox.com Paramount 5555 Melrose Avenue, Los Angeles, CA 90038 http://www.paramount.com NAME -------------------------------------------------------------------------------- ADDRESS -------------------------------------------------------------------------------- WEBSITE -------------------------------------------------------------------------------- Disney 500 S. Buena Vista St., Burbank, CA 91521 http://www.disney.com SQL> select characterName, episodeTitle from featuring 2 ; CHARACTERNAME -------------------------------------------------------------------------------- EPISODETITLE -------------------------------------------------------------------------------- Jean-Luc Picard Encounter at Farpoint, Part 1 Deanna Troi The Child Beverly Crusher The Child CHARACTERNAME -------------------------------------------------------------------------------- EPISODETITLE -------------------------------------------------------------------------------- Guinan The Child Wesley Crusher Evolution Jean-Luc Picard The Best of Both Worlds CHARACTERNAME -------------------------------------------------------------------------------- EPISODETITLE -------------------------------------------------------------------------------- William T. Riker The Best of Both Worlds Jean-Luc Picard Redemption, Part 2 Worf Redemption, Part 2 CHARACTERNAME -------------------------------------------------------------------------------- EPISODETITLE -------------------------------------------------------------------------------- Data Time's Arrow, Part 2 Guinan Time's Arrow, Part 2 Data Descent CHARACTERNAME -------------------------------------------------------------------------------- EPISODETITLE -------------------------------------------------------------------------------- Jean-Luc Picard All Good Things... 13 rows selected. SQL> select * from produces; STUDIONAME -------------------------------------------------------------------------------- STUDIOWEBSITE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Paramount http://www.paramount.com Star Trek: The Next Generation Gene Roddenberry STUDIONAME -------------------------------------------------------------------------------- STUDIOWEBSITE -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Fox http://www.fox.com The Simpsons Matt Groening SQL> select * from starring; ACTORNAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Patrick Stewart Star Trek: The Next Generation Gene Roddenberry Jonathan Frakes Star Trek: The Next Generation Gene Roddenberry ACTORNAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Brent Spiner Star Trek: The Next Generation Gene Roddenberry LeVar Burton Star Trek: The Next Generation ACTORNAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Gene Roddenberry Gates McFadden Star Trek: The Next Generation Gene Roddenberry Marina Sirtis ACTORNAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Star Trek: The Next Generation Gene Roddenberry Michael Dorn Star Trek: The Next Generation Gene Roddenberry ACTORNAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- Wil Wheaton Star Trek: The Next Generation Gene Roddenberry Denise Crosby Star Trek: The Next Generation Gene Roddenberry ACTORNAME -------------------------------------------------------------------------------- SERIESTITLE -------------------------------------------------------------------------------- SERIESCREATOR -------------------------------------------------------------------------------- 9 rows selected. SQL> select actorName, characterName from plays; ACTORNAME -------------------------------------------------------------------------------- CHARACTERNAME -------------------------------------------------------------------------------- Patrick Stewart Jean-Luc Picard Jonathan Frakes William T. Riker Gates McFadden Beverly Crusher ACTORNAME -------------------------------------------------------------------------------- CHARACTERNAME -------------------------------------------------------------------------------- Marina Sirtis Deanna Troi Michael Dorn Worf Wil Wheaton Wesley Crusher ACTORNAME -------------------------------------------------------------------------------- CHARACTERNAME -------------------------------------------------------------------------------- Whoopi Goldberg Guinan Denise Crosby Tasha Yar 8 rows selected. SQL> quit Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production 9:58pm elaine13:~/cs145/ctlfiles>