-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 31, 2012 at 04:50 PM
-- Server version: 5.1.44
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `db_imm3227_1202_oburne`
--

-- --------------------------------------------------------

--
-- Table structure for table `actor`
--

CREATE TABLE IF NOT EXISTS `actor` (
  `actor_id` int(11) NOT NULL AUTO_INCREMENT,
  `actorFirstName` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `actorLastName` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `actorDescription` text COLLATE utf8_unicode_ci NOT NULL,
  `movie_id` int(11) NOT NULL,
  PRIMARY KEY (`actor_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=69 ;

--
-- Dumping data for table `actor`
--

INSERT INTO `actor` (`actor_id`, `actorFirstName`, `actorLastName`, `actorDescription`, `movie_id`) VALUES
(1, 'Matt', 'Damon', 'Matthew Paige Damon was born on October 8, 1970, in Boston Massachusetts to Kent Damon, a stockbroker, Realtor and tax preparer, and Nancy Carlsson-Paige, an early childhood education professor at Lesley University. Matt has an older brother named Kyle who is now a sculptor. The family lived in Newton until his parents divorced, when Damon and his brother moved with his mother to Cambridge. It was here that Damon met his close friend and collaborator Ben Affleck, who lived in the neighborhood. \r\n\r\nDamon attended Cambridge Ridge and Latin School and he performed in a number of theater productions during his time there. He attended Harvard University as an English major, but dropped out to pursue acting. He made small roles in Mystic Pizza (1988), School Ties (1992), and Geronimo: An American Legend (1993), before landing his breakthrough role as a drug-addicted soldier in Courage Under Fire (1996). The role required him to lose 40 pounds in a short period of time, which resulted in health problems. Fortunately, critics took note of his performance and he felt it was a worthwhile risk to show his level of dedication to his craft. \r\n\r\nThe following year, he garnered accolades for Good Will Hunting (1997), based on a screenplay he had originally written while at Harvard. Directed by Gus Van Sant, the film was nominated for nine Academy Awards, and he and Affleck won the Oscar for Best Original Screenplay.\r\n', 1),
(2, 'Ben', 'Affleck', 'Benjamin Geza Affleck was born on August 15, 1972 in Berkeley, California, USA but raised in Cambridge, Massachusetts, USA. He was born to parents Tim Affleck, a social worker, who is now divorced from Ben''s mother Chris Affleck (nee'' Boldt) a school teacher. Ben also has a younger brother, actor Casey Affleck, who was born in 1975. Ben wanted to be an actor ever since he could remember and his first acting experience was for a Burger King commercial, when he was on the PBS mini-series "The Voyage of the Mimi" (1984). It was also at that age when Ben met his lifelong friend and fellow actor, Matt Damon. They played little league together and took drama classes together. Ben''s teen years consisted of mainly TV movies and small television appearances including Hands of a Stranger (1987) (TV) and "The Second Voyage of the Mimi" (1988). He made his big introduction into feature films in 1993 when he was cast in Dazed and Confused (1993). After that, he did mostly independent films like Kevin Smith''s Mallrats (1995) and Chasing Amy (1997) which were great for Ben''s career, receiving renowned appreciation for his works at the Sundance film festival. But the success he was having in independent films didn''t last much longer and things got a little shaky for Ben. He was living in an apartment with his brother Casey and friend Matt, getting tired of being turned down for the big roles in films and being given the forgettable supporting ones. Since Matt was having the same trouble, they decided to write their own script, where they could call all the shots. So, after finishing the script for Good Will Hunting (1997), they gave it to their agent Patrick Whitesell, who showed it to a few Hollywood studios, finally being accepted by Castlerock. It was great news for the two but Castlerock wasn''t willing to give Ben and Matt the control over the project they were hoping for. It was friend Kevin Smith who took it to the head of Miramax who bought the script giving Ben and Matt the control they wanted and, in December of 1997, Good Will Hunting (1997) was released, making the two unknown actors famous. ', 1),
(3, 'Tim', 'Robbins', 'Born in West Covina, California, but raised in New York City, Tim Robbins is the son of former The Highwaymen singer Gil Robbins and actress Mary Robbins. Robbins studied drama at UCLA, where he graduated with honors in 1981. That same year, he formed the Actors'' Gang theater group, an experimental ensemble that expressed radical political observations through the European avant-garde form of theater. He started film work in TV movies in 1983, but hit the big time in 1988 with his portrayal of dim-witted fastball pitcher "Nuke" Laloosh in Bull Durham (1988). Tall with baby-faced looks, he has the ability to play naive and obtuse (Cadillac Man (1990) and The Hudsucker Proxy (1994)) or slick and shrewd (The Player (1992) and Bob Roberts (1992)', 2),
(4, 'Morgan', 'Freeman', 'With an authoritative voice and calm demeanor, this ever popular American actor has grown into one of the most respected figures in modern US cinema. Born in June 1937 in Memphis, Tennessee, the young Freeman attended Los Angeles Community College before serving several years in the US Air Force as a mechanic between 1955 and 1959. His first dramatic arts exposure was on the stage including appearing in an all-African American production of the exuberant musical Hello, Dolly!.', 2),
(5, 'Matthew ', 'Broderick', 'A slight comic actor chiefly known for his boyish charm, Matthew Broderick was born on March 21, 1962, in New York City to actor James Broderick and Patricia Broderick. Matthew initially took up acting at New York''s upper-crust Walden School after being sidelined from his athletic pursuits (football and soccer) by a knee injury. His father got him his stage debut at age 17 in a workshop production of the play "On Valentine''s Day". Matthew''s career then accelerated with parts in two Neil Simon projects: the play "Brighton Beach Memoirs" (1982-83) and the feature film Max Dugan Returns (1983). Broderick reprised the role of Eugene in "Biloxi Blues" (1988), the second installment of the Simon trilogy, for both the Broadway production and the film adaptation (Biloxi Blues (1988)). For the third and final installment of the trilogy, he was replaced by Jonathan Silverman. In 1983, the same year as Max Dugan Returns (1983), Broderick had his first big-screen success in the light comedy WarGames (1983). Since then he has had his fair share of hits and misses, with some of his better films including Project X (1987) also starring Helen Hunt, whom he subsequently dated; Addicted to Love (1997); and Inspector Gadget (1999).', 3),
(6, 'Alan', 'Ruck', 'Alan Ruck was born on July 1, 1956 in Cleveland, Ohio, and has made over 100 appearances in films and television, and on stage. He is best known for his role as best friend of Matthew Broderick and hopeless hypochondriac Cameron Frye, in John Hughes''s Ferris Bueller''s Day Off (1986). His other film roles include Young Guns II (1990) with Emilio Estevez and Lou Diamond Phillips, Star Trek: Generations (1994), Speed (1994) with Keanu Reeves and Twister (1996), the latter two films being directed by Jan de Bont. Ruck''s television appearances include "Tales from the Crypt" (1989) opposite Lou Diamond Philips, "Mad About You" (1992) with Helen Hunt (who he also appeared alongside in Twister) and "Spin City" (1996) with Charlie Sheen (who he also appeared alongside in Ferris Bueller''s Day Off). He also made an appearance in the HBO miniseries "From the Earth to the Moon" (1998) which reunited him with his Twister co-star Cary Elwes.', 3),
(7, 'Billy', 'Crystal', 'Billy Crystal was born on March 14, 1948 in Long Beach, Long Island, New York. He was the youngest of three sons born to Jack and Helen Crystal. His father was a well-known concert promoter who co-founded Commodore Records and his mother was a homemaker.', 4),
(8, 'Meg', 'Ryan', 'Blond-haired, blue-eyed with an effervescent personality, Meg Ryan graduated from Bethel high school, Bethel in June 1979. Moving to New York, she attended New York University where she majored in journalism. To earn extra money while working on her degree, Meg went into acting using her new name Meg Ryan. In 1981, she had her big screen debut with a brief appearance as Candice Bergen''s daughter in George Cukor''s last film Rich and Famous (1981). She tried out and was cast as Betsy in the day time television soap "As the World Turns" (1956). She was part of the cast from 1982 to 1984. Meg also had a part in the television series "One of the Boys" (1982), but this show was soon canceled. In 1984, she moved to tinsel town and landed a job in the western Television Series "Wildside" (1985). Meg''s small part in the blockbuster movie Top Gun (1986) led to her being cast in Steven Spielberg''s Innerspace (1987) where she co-starred with Dennis Quaid. She again co-starred with Quaid in the remake of D.O.A. (1988) and they married on Valentine''s Day in 1991. In 1989, Meg appeared in When Harry Met Sally... (1989) and the scene at the restaurant became famous. Meg was nominated for both the Golden Globe and the BAFTA', 4),
(9, 'Renée', 'Zellweger', 'Renée Kathleen Zellweger was born on April 25, 1969, in Katy, Texas, USA to parents Emil Erich Zellweger, a Swiss-born engineer who married Renée''s mother Kjellfrid Irene Andreassen, a Norwegian-born former nurse and midwife in 1963. Renée also has a brother named Drew Zellweger, a marketing executive born on February 15, 1967. Renée got interested in acting in high school while working on the drama club. She also took an acting class at the University of Texas (Austin), where she began looking towards acting as a career. After graduation, she wanted to continue acting, but Hollywood is a tough town to break into, so Renée decided to stay in Texas, and auditioned for roles around Houston, where she managed to grab roles in such films as Reality Bites (1994) and Empire Records (1995).', 5),
(10, 'Colin', 'Firth', 'Born into an academic family - his father is a history lecturer at Winchester University College (formerly King Alfred''s College) in Winchester and his mother is a comparative religions lecturer at the Open University - Colin Firth''s first acting experience came in infant''s school when he played "Jack Frost" in a Christmas pantomime. Three of his four grandparents were Methodist missionaries and he spent his early childhood in Nigeria, returning to England at age five where he entered a comprehensive school in Winchester. He spent two years at the Drama Centre in Chalk Farm where he was "discovered" while playing "Hamlet" during his final term. His first professional role was as "Bennet" in the West End production of "Another Country". From this performance, he was chosen to play the character of "Judd" in the movie of the play. He went on to play a variety of character parts in both film and television. For his portrayal of "Robert Lawrence" in the 1989 TV production Tumbledown (1988) (TV), he received the Royal Television Society Best Actor award and also a BAFTA nomination. He also received a BAFTA nomination for "Mr. Darcy" in the 1995 TV version of "Pride and Prejudice" (1995). In 2011, he won the Oscar for Best Actor for his commanding leading role, playing British King George VI in The King''s Speech (2010).', 5),
(11, 'Hugh', 'Grant', 'Hugh Grant, one of Britain''s best known faces who has been equally entertaining on-screen as well as in real life, and had enough sense of humor to survive a media frenzy, is best known for his roles in Notting Hill (1999), opposite Julia Roberts, and in Music and Lyrics (2007), opposite Drew Barrymore, among his other works.', 5),
(12, 'Reese', 'Witherspoon', 'Laura Jeanne Reese Witherspoon was born on March 22, 1976 at Southern Baptist Hospital (now Memorial Medical Center) in New Orleans, Louisiana. She was the second child born to Dr. John Witherspoon and Betty Reese. Her father was a military surgeon specializing in the ear, nose and throat. Her mother was a Registered Nurse who later became a Ph.D in pediatric nursing. Reese spent the first four years of her life in Wiesbaden, Germany where her father served as a lieutenant colonel in the US Army reserves. Shortly after, John moved the family back to the States, settling in Nashville, Tennessee.', 6),
(13, 'Joaquin ', 'Phoenix', 'Born in Puerto Rico to Children of God missionaries "John Bottom Amram" and "Arlyn Dunetz Jochebed" (a.k.a. Heart), Joaquin was the middle child in a brood of five. As a youngster, he took his cues from older siblings River Phoenix and Rain Phoenix, changing his name to Leaf to match their earthier monikers. When the children were encouraged to develop their creative instincts, he followed their lead into acting. Younger sisters Liberty Phoenix and Summer Phoenix rounded out the talented troupe. The family moved often, traveling through Central and South America (and adopting the surname "Phoenix" to celebrate their new beginnings) but, by the time Joaquin was 6, they had more or less settled in the Los Angeles area. Heart found work as a secretary at NBC, and John turned his talents to landscaping. They eventually found an agent who was willing to represent all five children, and the younger generation dove into TV work.', 6),
(14, 'Brad', 'Pitt', 'An actor and producer known as much for his versatility as he is for his handsome face, Golden Globe-winning actor Brad Pitt''s most widely-recognized role may be Tyler Durden in Fight Club (1999). But his portrayals of Billy Beane in Moneyball (2011), and Rusty Ryan in the remake of _Ocean''s Eleven (2001)_ and its sequels, also loom large in his filmography.', 7),
(15, 'Edward ', 'Norton', 'Edward Norton was born on August 18, 1969 to parents Edward, an attorney who works for the National Trust for Historic Preservation and Robin Norton, a former foundation executive and teacher who passed away of brain cancer on March 6, 1997. Edward also has two younger siblings named James and Molly. From the age of 5 onward, the Yale graduate (majoring in history) has always been interested in acting. At the age of 8, he would ask his drama teacher what his motivation in a scene was. He attended theater schools throughout his life, and eventually managed to find work on stage in New York as a member of the Signature players, who produced the works of playwright and director Edward Albee. Around the time when he was appearing in Albee''s Fragments, in Hollywood, they were looking for a young actor to star opposite Richard Gere in a new courtroom thriller, Primal Fear (1996). The role was offered to Leonardo DiCaprio but he turned it down.', 7),
(16, 'Elijah', 'Wood', 'Elijah Wood is an American actor best known for portraying Frodo Baggins in Peter Jackson''s blockbuster Lord of the Rings film trilogy. In addition to reprising the role for the upcoming prequels of The Hobbit, Wood also plays Ryan in the FX television comedy "Wilfred" (2011) and voices the role of Beck in the Disney XD animated television series "TRON: Uprising" (2012).\r\n', 8),
(17, 'Orlando', 'Bloom', 'Orlando Bloom was born in Canterbury, Kent, England on January 13, 1977. The man he briefly knew as his father, Harry Bloom, was a legendary political activist who fought for civil rights in South Africa. But Harry died of a stroke when Orlando was only four years old. After that, Orlando and his older sister, Samantha Bloom, were raised by their mother, Sonia, and family friend, Colin Stone. When Orlando was 13, Sonia revealed to him that Colin was actually his biological father.\r\n\r\nOrlando attended St. Edmunds School in Canterbury but struggled in many courses because of dyslexia. He did embrace the arts.', 8),
(18, 'Viggo ', 'Mortensen', 'Since his screen debut as a young Amish Farmer in Peter Weir''s Witness (1985), Viggo Mortensen''s career has been marked by a steady string of well-rounded performances. Critics have continually recognized his work in over thirty movies, including such diverse projects as Jane Campion''s The Portrait of a Lady (1996), Sean Penn''s The Indian Runner (1991), Brian De Palma''s Carlito''s Way (1993), Ridley Scott''s G.I. Jane (1997), Tony Scott''s Crimson Tide (1995), Andrew Davis''s A Perfect Murder (1998), Ray Loriga''s La pistola de mi hermano (1997), and Tony Goldwyn''s A Walk on the Moon (1999).\r\n\r\nBorn in New York to a Danish father and an American mother, Mortensen spent the early part of his childhood in Manhattan. His family traveled a great deal and he spent several years living in Venezuela, Argentina and Denmark. He began acting in New York, studying with Warren Robertson. He appeared in several plays and movies, and eventually moved to Los Angeles, where his performance in "Bent" at the Coast Playhouse earned him a Drama-logue Critic''s Award. Mortensen is also an accomplished poet, photographer and painter.', 8),
(19, 'Christian', 'Bale', 'Christian Charles Philip Bale was born in Pembrokeshire, Wales on January 30, 1974. Bale''s father, David, was a commercial pilot, and the family lived in different countries throughout Bale''s childhood, including England, Portugal, and the United States. Bale acknowledges the constant change was one of the influences on his career choice.\r\n\r\nHis first acting job was a cereal commercial in 1983; amazingly, the next year, he debuted on the West End stage opposite Rowan Atkinson in "The Nerd". A role in the 1986 NBC mini-series Anastasia: The Mystery of Anna (1986) (TV) caught Steven Spielberg''s eye, leading to Bale''s well-documented role in Empire of the Sun (1987). For the range of emotions he displayed as the star of the war epic, he earned a special award by the National Board of Review for Best Performance by a Juvenile Actor.', 11),
(20, 'Heath', 'Legder', 'He could not find any American roles but then Australian director Gregor Jordan auditioned him for the lead in Two Hands (1999), which he got. An in your face Aussie crime thriller, Two Hands (1999) was outstanding and helped him secure a role in 10 Things I Hate About You (1999). After that, it seemed Heath was being typecast as a teen hunk, which he did not like, so he accepted a role in a very serious war drama The Patriot (2000).\r\n\r\nWhat followed was a stark inconsistency of roles, Ledger accepting virtually every single character role, anything to avoid being typecast. Some met with praise, like his short role in Monster''s Ball (2001), but his version of Ned Kelly (2003) was an absolute flop, which led distributors hesitant to even release it outside Australia. Heath finally had deserved success with his role in Brokeback Mountain (2005), for which he was nominated for an Oscar and a BAFTA. Ledger was found dead on January 22, 2008 in his apartment in the Manhattan neighborhood of SoHo, with a bottle of prescription sleeping pills nearby. It was concluded weeks later that he died of an accidental overdose of prescription drugs that included painkillers, sleeping pills and anti-anxiety medication. After his death he received more than 30 posthumous awards for his portrayal as the psychopathic clown prince of crime in The Dark Knight (2008) (including the Oscar, SAG, BAFTA, and Golden Globe)', 12),
(21, 'Vivien', ' Leigh', 'Vivian Mary Hartley was born on November 5, 1913, in Darjeeling, India, a strange place for one of the world''s most celebrated actresses to be born. She was to live in this beautiful country for the next six years. Her parents wanted to go home to England but because of World War I they opted to stay in India. At the end of the war the Hartleys headed back to their home country, where Vivien''s mother wanted her daughter to have a convent education. She was one of the youngest in attendance, and it was not a happy experience for her. One of the few consolations was her friendship with a classmate who also became a successful actress, Maureen O''Sullivan While there her mother came for a visit and took her to a play on London''s legendary West Side. It was there that Vivien decided to become an actress.', 12),
(22, 'Clark', 'Gable ', 'William Clark Gable was born on February 1, 1901 in Cadiz, Ohio. Later that year his mother died, and his father sent him to live with his maternal aunt and uncle in Pennsylvania, where he stayed until he was two. His father then returned to take him back to Cadiz. When Clark was 16 he dropped out of school and worked at many odd jobs before joining a traveling theater company.\r\nOn December 13, 1924 he married Josephine Dillon, his acting coach and 15 years his senior. Around that time, they moved to Hollywood so that Clark could concentrate on his acting career. In April 1930, they divorced and a year later he married Maria Langham (a.k.a. Maria Franklin Gable), also about 17 years older than him. After working as an extra in various movies, he was offered a small part in the The Painted Desert (1931) in 1931.\r\nFrom this point, his acting career flourished, and in 1934 he won an Academy Award for his performance in Frank Capra''s classic It Happened One Night (1934). The next year saw a starring role in The Call of the Wild (1935) with Loretta Young, with whom he had an affair (resulting in the birth of a daughter, Judy Lewis). Divorced in 1939, he later that same year starred in Gone with the Wind (1939).', 12),
(23, 'Gene', 'Kelly', 'Metro-Goldwyn-Mayer was the largest and most powerful studio in Hollywood when Gene Kelly arrived in town in 1941. He came direct from the hit 1940 original Broadway production of "Pal Joey" and planned to return to the Broadway stage after making the one film required by his contract. His first picture for Metro-Goldwyn-Mayer was For Me and My Gal (1942) with Judy Garland. What kept Kelly in Hollywood were "the kindred creative spirits" he found behind the scenes at Metro-Goldwyn-Mayer. The talent pool was especially large during World War II, when Hollywood was a refuge for many musicians and others in the performing arts of Europe who were forced to flee the Nazis. After the war, a new generation was coming of age. Those who saw An American in Paris (1951) would try to make real life as romantic as the reel life they saw portrayed in that musical, and the first time they saw Paris, they were seeing again in memory the seventeen-minute ballet sequence set to the title song written by George Gershwin and choreographed by Kelly. The sequence cost a half million dollars (U.S.) to make in 1951 dollars. Another Kelly musical of the era, Singin'' in the Rain (1952), was one of the first 25 films selected by the Library of Congress for its National Film Registry', 13),
(24, 'Debbie', 'Reynolds', 'Debbie Reynolds'' film career began at MGM after she won a beauty contest at age 16 impersonating Betty Hutton. Most of her film work has been in MGM musicals, as perky, wholesome young women. She continues to use her dancing skills with stage work. Nearly all the money she makes is spent toward her goal of creating a Hollywood museum. Her collection numbers more than 3000 costumes and 46,000 square-feet worth of props and equipment.', 13),
(25, 'Fred', 'MacMurray ', 'Born to Maleta Martin and Frederick MacMurray (concert violinist). Fred sang and played in orchestras to earn tuition. He was educated at Carroll College, Wis. Fred played with a Chicago orchestra for more than a year. Then he joined an orchestra in Hollywood where he played, did some recording and played extra roles. He then joined a comedy stage band, California Collegians, and went to New York. There he joined "Three''s A Crowd" revue on Broadway and on the road. After this show closed, he returned to California and worked in vaudeville. He played the vaudeville circuits and night clubs until cast for major role in "Roberta". Signed by Paramount in 1935.', 14),
(26, 'Barbara', 'Stanwyck', 'n 1928 Barbara moved to Hollywood, where she was to start one of the most lucrative careers filmdom had ever seen. She was an extremely versatile actress who could adapt to any role. Barbara was equally at home in all genres, from melodramas, such as Forbidden (1932) and Stella Dallas (1937), to thrillers, such as Double Indemnity (1944), one of her best films, also starring Fred MacMurray (as you have never seen him before). She also excelled in comedies such as Remember the Night (1940) and The Lady Eve (1941). Another genre she excelled in was westerns, Union Pacific (1939) being one of her first and TV''s "The Big Valley" (1965) (her most memorable role) being her last. In 1983, she played in the ABC hit mini-series "The Thorn Birds" (1983), which did much to keep her in the eye of the public. She turned in an outstanding performance as Mary Carson.', 14),
(27, 'Johny', 'Depp', 'Depp got into acting after a visit to Los Angeles, California, with his former wife, Lori Anne Allison (Lori A. Depp), who introduced him to actor Nicolas Cage. He made his film debut in A Nightmare on Elm Street (1984). In 1987 he shot to stardom when he replaced Jeff Yagher in the role of undercover cop Tommy Hanson in the popular TV series "21 Jump Street" (1987).\r\nIn 1990, after numerous roles in teen-oriented films, his first of a handful of great collaborations with director Tim Burton came about when Depp played the title role in Edward Scissorhands (1990). Following the film''s success, Depp carved a niche for himself as a serious, somewhat dark, idiosyncratic performer, consistently selecting roles that surprised critics and audiences alike. He continued to gain critical acclaim and increasing popularity by appearing in many features before re-joining with Burton in the lead role of Ed Wood (1994). In 1997 he played an undercover FBI agent in the fact-based film Donnie Brasco (1997), opposite Al Pacino; in 1998 he appeared in Fear and Loathing in Las Vegas (1998), directed by Terry Gilliam; and then, in 1999, he appeared in the sci-fi/horror film The Astronaut''s Wife (1999). The same year he teamed up again with Burton in Sleepy Hollow (1999), brilliantly portraying Ichabod Crane.', 15),
(28, 'Kevin', 'Costner', 'n 1973, he enrolled at California State University at Fullerton, where he majored in business. During that period, Kevin decided to take acting lessons five nights a week. He graduated with a business degree in 1978 and married his college sweetheart, Cindy Costner. He initially took a marketing job in Orange County. Everything changed when he accidentally met Richard Burton on a flight from Mexico. Burton advised him to go completely after acting if that is what he wanted. He quit his job and moved to Hollywood soon after. He drove a truck, worked on a deep sea fishing boat, and gave bus tours to stars'' homes before finally making his own way into the films. After making one soft core sex film, he vowed to not work again if that was the only work he could do. He didn''t work for nearly six years, while he waited for a proper break. That break came with The Big Chill (1983), even though his scenes ended up on the cutting room floor -- he was remembered by director Lawrence Kasdan when he decided to make Silverado (1985).', 16),
(29, 'Sean', 'Connery', 'No Road Back (1957) was Sean''s first major movie role, and it followed by several Tv-movies such as Anna Christie (1957) (TV), Macbeth (1961) (TV) and Anna Karenina (1961) (TV) and guest appearances on TV-series, and also films such as Hell Drivers (1957), Another Time, Another Place (1958), Darby O''Gill and the Little People (1959), The Frightened City (1961). In 1962 he appeared in The Longest Day (1962) with a host of other stars,\r\nHis big breakthrough came in 1962 when he starred as secret agent James Bond in Dr. No ', 16),
(31, 'Leonardo', 'DiCaprio', 'Leonardo DiCaprio is an American-born actor whose portrayal of doomed suitor Jack Dawson in Titanic (1997) made him a generation''s definition of a heartthrob. Throughout his career, DiCaprio has demonstrated a high level of dramatic versatility, from his breakout film role as a mentally-challenged teenager in What''s Eating Gilbert Grape (1993), through his work with Martin Scorsese in Gangs of New York (2002) and The Departed (2006). More recently, DiCaprio earned critical notice for his starring roles in Christopher Nolan''s Inception (2010) and J. Edgar (2011), for which he received a Golden Globe nomination. ', 17),
(32, 'Jack', 'Nicholson ', 'Abandoned by his father in his childhood, he was raised believing his grandmother was his mother and his mother was his older sister. The truth was revealed to him years later when a Time magazine journalist uncovered the truth while preparing a story on the star. Jack had an on-and-off relationship with actress Anjelica Huston, which spanned 16 years before they split in 1989, after Rebecca Broussard was carrying his child.', 17),
(34, 'Billy', 'Murray', 'Bill is the fifth of nine children born to Edward and Lucille Murray. He and most of his siblings worked as caddies, which paid his tuition to Loyola Academy, a Jesuit school. He played sports and did some acting while in that school, but in his words, mostly "screwed off." He enrolled at Regis College in Denver to study pre-med but dropped out after being arrested for marijuana possession. He then joined the National Lampoon Radio Hour with fellow members Dan Aykroyd, Gilda Radner, and John Belushi. However, while those three became the original members of "Saturday Night Live" (1975), he joined "Saturday Night Live with Howard Cosell" (1975), which premiered that same year. After that show failed, he later got the opportunity to join "Saturday Night Live" ', 18),
(35, 'Andie', 'MacDowell', 'Received an honorary doctor of letters degree from Lander University in Greenwood, South Carolina, for her dedication to the Graham Children''s Health Center. ', 18),
(36, 'Joseph', 'Gordon-Levitt', 'After working for several years as a child actor, Joseph became better known for starring on the hit television series "3rd Rock from the Sun" (1996), for which he earned two Hollywood Reporter Young Star Awards. In addition, the show earned three Screen Actors Guild Award nominations for Outstanding Peformance by an Ensemble in a Comedy Series. Prior to his success on television, Joseph had already worked steadily in feature films, debuting in the Robert Redford film A River Runs Through It (1992).', 19),
(37, 'Keanu', 'Reeves', 'Reeves was lukewarm toward academics but took a keen interest in ice hockey (as team goalie, he earned the nickname "The Wall") and drama. He eventually dropped out of school to pursue an acting career.\r\n\r\nAfter a few stage gigs and a handful of made-for-TV movies, he scored a supporting role in the Rob Lowe hockey flick Youngblood (1986), which was filmed in Canada. Shortly after the production wrapped, Reeves packed his bags and headed for Hollywood. Reeves popped up on critics'' radar with his performance in the dark adolescent drama, River''s Edge (1986), and landed a supporting role in the Oscar-nominated Dangerous Liaisons (1988) with director Stephen Frears.\r\nHis first popular success was the role of totally rad dude "Ted Logan" in Bill & Ted''s Excellent Adventure (1989). The wacky time-travel movie became something of a cultural phenomenon, and audiences would forever confuse Reeves''s real-life persona with that of his doofy on-screen counterpart. He then joined the casts of Ron Howard''s comedy, Parenthood (1989), and Lawrence Kasdan''s I Love You to Death', 20),
(38, 'Carrie-Ann', 'Moss', 'Carrie-Anne Moss grew up in Vancouver, British Columbia as youngest of two children. At the age of 20 she moved to Europe to pursue a career in modeling. In Spain she managed to get a regular role in the TV show "Dark Justice" (1991), which was produced in Barcelona for the 1st season, and followed it to the shooting locations in Los Angeles the next year. Later she appeared in numerous commercials and in the play "Outward Bound" at the Hudson Theater in Los Angeles.', 20),
(39, 'Tom', 'Hanks', 'Born in California, Tom Hanks grew up in what he calls a "fractured" family. His parents were pioneers in the development of marriage dissolution law in that state, and Tom moved around a lot, living with a succession of step-families. No problems, no abuse, no alcoholism - just a confused childhood. He had no acting experience in college and, in fact, credits the fact that he couldn''t get cast in a college play with actually starting his career. He went downtown, auditioned for a community theater play, was invited by the director of that play to go to Cleveland, and there his acting career started.', 21),
(40, 'Humphrey', 'Bogart', 'In 1930, he gained a contract with Fox, his feature film debut in a ten-minute short, Broadway''s Like That (1930), co-starring Ruth Etting and Joan Blondell. Fox released him after two years. After five years of stage and minor film roles, he had his breakthrough role in The Petrified Forest (1936) from Warner Bros. He won the part over Edward G. Robinson only after the star, Leslie Howard, threatened Warner Bros. that he would quit unless Bogart was given the key role of Duke Mantee, which he had played in the Broadway production with Howard. The film was a major success and led to a long-term contract with Warner Bros. From 1936 to 1940, Bogart appeared in 28 films, usually as a gangster, twice in Westerns and even a horror film. ', 22),
(41, 'Ingrid', 'Bergman', 'Born in Stockholm, Sweden, on August 29, 1915 - Ingrid Bergman was one of the greatest actresses from Hollywood''s lamented Golden Era. Her natural and unpretentious beauty and her immense acting talent made her one of the most celebrated figures in the history of American cinema. Bergman is also one of the most Oscar-awarded actresses, second only to Katharine Hepburn.', 22),
(42, 'Russel', 'Crowe', ' Russell got the acting bug early in life. Beginning as a child star on a local Australian TV show, Russell''s first big break came with two films ... the first, Romper Stomper (1992), gained him a name throughout the film community in Australia and the neighboring countries. The second, The Sum of Us (1994), helped put him on the American map, so to speak. Sharon Stone heard of him from Romper Stomper (1992) and wanted him for her film, The Quick and the Dead ', 23),
(43, 'Mel', 'Gibson', 'Though born in the US, Mel and his family moved to New South Wales, Australia. After high school, Mel studied at the University of New South Wales in Sydney, performing at the National Institute of Dramatic Arts alongside future film thespians Judy Davis and Geoffrey Rush. After college, Mel had a few stints on stage and starred in a few TV shows. Eventually, he was chosen to star in Mad Max (1979) and in a movie called Tim (1979), co-starring Piper Laurie. The small budgeted movie Mad Max (1979) made him known worldwide, while Tim (1979) garnered him an award for Best Actor from the Australian Film Institute', 24),
(44, 'Bruce', 'Willis', 'Actor and musician Bruce Willis is well known for his film appearances as wisecracking or hard-edged characters, often in spectacular action films. Collectively, he has appeared in films that have grossed in excess of $2.5 billion USD placing him in the top ten stars in terms of box office receipts. ', 25),
(45, 'Jason', ' Statham', 'Jason Statham has done quite a lot in a short time. He has been a Diver on the British National Diving Team and finished 12th in the World Championships in 1992. He has also been a fashion model, black market salesman and finally of course, actor. He got the audition for his debut role as Bacon in Lock, Stock and Two Smoking Barrels (1998) through French Connection, for whom he was modeling. They became a major investor in the film and introduced Jason to Guy Ritchie, who invited him to audition for a part in the film by challenging him to impersonate an illegal street vendor and convince him to purchase fake jewelery. Jason must have been doing something right because after the success of Lock, Stock and Two Smoking Barrels (1998) he teamed up again with Guy Ritchie for Snatch.', 26),
(46, 'Geoffrey', 'Rush', 'Geoffrey Rush attended Everton Park State High School during his formative years. His early interest in the theatre led to his 1971 stage debut at age 20 in "Wrong Side of the Moon" with the Queensland Theatre Company.\r\nKnown for his classical repertory work over the years, he scored an unexpected hit with his Queensland role as Snoopy in the musical "You''re a Good Man, Charlie Brown". ', 27),
(47, 'Helena', 'Bonham Carter', 'In the late 1990s, Helena Bonham Carter seemed poised to embark on the next phase of her career, moving from capable actress to compelling star. Audiences and critics had long been enchanted by her delicate beauty, evocative of another time and place; in 1997, she showed that she was more than a pretty face and a skilled line-reader, with her performance in "The Wings of the Dove," for which she received a Best Actress Oscar nomination.\r\n', 27),
(48, 'Jesse', 'Eisenberg', 'Jesse had his first professional role in an off-Broadway play ''The Gathering''. His first television role came in 1999 with "Get Real" (1999), but the show was cancelled in 2000. In his senior year of high school, he landed his first film role in Roger Dodger (2002). He won an award for ''Most Promising New Actor'' at the San Diego film festival.\r\n', 28),
(49, 'Cary', 'Elwes', 'e was born and raised in London and attended Harrow. After graduating from Harrow, he moved to the US and studied drama at Sarah Lawrence College. He left school after two years to begin his film career. Cary is well respected by colleagues and fans alike and considered by many to be one of the finest young actors working today.', 29),
(50, 'Mandy', 'Patinkin', 'Growing up he began singing in synagogue choirs at the age of 13-14 and still continues to use his fantastic voice in musicals and in recordings.', 29),
(51, 'Robin', 'Wright', 'She started her professional career as a model in 1980 at age 14, and worked both in Paris and Japan. After finishing high school she decided to become an actress. She got a role on the soap opera "Santa Barbara" (1984), for which she was nominated three times for a Daytime Emmy. During the first season of the show, she fell in love with fellow cast member Dane Witherspoon, whom she married in 1986. Meanwhile, she starred in The Princess Bride (1987), playing the title role.', 29);

-- --------------------------------------------------------

--
-- Table structure for table `director`
--

CREATE TABLE IF NOT EXISTS `director` (
  `director_id` int(11) NOT NULL AUTO_INCREMENT,
  `directorFirstName` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `directorLastName` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `movie_id` int(11) NOT NULL,
  PRIMARY KEY (`director_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=29 ;

--
-- Dumping data for table `director`
--

INSERT INTO `director` (`director_id`, `directorFirstName`, `directorLastName`, `movie_id`) VALUES
(1, 'Frank ', 'Darabont', 2),
(2, 'Gus ', 'Van Sant', 1),
(3, 'John', 'Hughes', 3),
(4, 'Rob', 'Reiner', 4),
(5, 'Sharon', ' Maguire', 5),
(6, 'James', 'Mangold', 6),
(7, 'David', 'Fincher', 7),
(8, 'Peter', 'Jackson', 8),
(9, 'Christopher', 'Nolan', 11),
(10, 'Victor', 'Flemming', 12),
(11, 'Stanley ', 'Donen', 13),
(12, 'David', 'Koepp', 15),
(13, 'Billy', 'Wilder', 14),
(14, 'Brian', 'De Palma', 16),
(15, 'Martin', 'Scorsese', 17),
(16, 'Harold', 'Ramis', 18),
(17, 'Andy', 'Wachowski', 20),
(18, 'Lana', 'Wachowski', 20),
(19, 'Robert', 'Zemeckis', 21),
(20, 'Michael ', 'Curtiz', 22),
(21, 'Ridley', 'Scott', 23),
(22, 'Mel', 'Gibson', 24),
(23, 'John', 'McTiernan', 25),
(24, 'Guy', 'Ritchie', 26),
(25, 'Tom', 'Hooper', 27),
(26, 'Paul Thomas', 'Anderson', 30);

-- --------------------------------------------------------

--
-- Table structure for table `genre`
--

CREATE TABLE IF NOT EXISTS `genre` (
  `genre_id` int(11) NOT NULL AUTO_INCREMENT,
  `genre_description` text COLLATE utf8_unicode_ci NOT NULL,
  `genreName` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `movie_id` int(11) NOT NULL,
  PRIMARY KEY (`genre_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `genre`
--

INSERT INTO `genre` (`genre_id`, `genre_description`, `genreName`, `movie_id`) VALUES
(1, 'A prose or verse composition, especially one telling a serious story, that is intended for representation by actors impersonating the characters and performing the dialogue and action.', 'Drama', 2),
(2, 'Thriller is a genre of film that uses suspense, tension and excitement as the main elements. The primary subgenres of thrillers are: mystery, crime and psychological thrillers', 'Thriller', 0),
(3, 'Comedy is a genre of film that uses humor as a driving force. The aim of a comedy film is to illicit laughter from the audience through entertaining stories and characters. Although the comedy film may take on some serious material, most have a happy ending.', 'Comedy', 3),
(4, 'Any film made during the Hollywood studio system era which has also received significant recognition, either at the time it was released or subsequently, by connoisseurs of great movie', 'Classics', 0),
(5, 'The action genre is a class of creative works characterized by more emphasis on exciting action sequences than on character development or story-telling.', 'Action', 7);

-- --------------------------------------------------------

--
-- Table structure for table `movie`
--

CREATE TABLE IF NOT EXISTS `movie` (
  `movie_id` int(11) NOT NULL AUTO_INCREMENT,
  `movieTitle` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `movieRunTime` decimal(10,0) NOT NULL,
  `movieDate` year(4) NOT NULL,
  `movieDescripion` text COLLATE utf8_unicode_ci NOT NULL,
  `director_id` int(11) NOT NULL,
  `genre_id` int(11) NOT NULL,
  `actor_id` int(11) NOT NULL,
  `writer_id` int(11) NOT NULL,
  PRIMARY KEY (`movie_id`),
  KEY `director_id` (`director_id`),
  KEY `genre_id` (`genre_id`),
  KEY `actor_id` (`actor_id`),
  KEY `writer_id` (`writer_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=31 ;

--
-- Dumping data for table `movie`
--

INSERT INTO `movie` (`movie_id`, `movieTitle`, `movieRunTime`, `movieDate`, `movieDescripion`, `director_id`, `genre_id`, `actor_id`, `writer_id`) VALUES
(1, 'Good Will Hunting', 126, 1997, 'Will Hunting (Damon), a janitor at MIT, has a gift for mathematics but needs help from a psychologist (Williams) to find direction in his life. ', 2, 1, 1, 1),
(2, 'Shawshank Redemption', 142, 1994, 'Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.', 1, 1, 3, 3),
(3, 'Ferris Buller''s Day Off', 103, 1986, 'A high school wise guy is determined to have a day off from school, despite of what the principal thinks of that.', 3, 3, 5, 4),
(4, 'When Harry Met Sally', 96, 1989, 'Harry and Sally have known each other for years, and are very good friends, but they fear sex would ruin the friendship.', 4, 3, 8, 5),
(5, 'Bridget Jones''s Diary', 97, 2001, 'A British woman is determined to improve herself while she looks for love in a year in which she keeps a personal diary.', 5, 3, 9, 6),
(6, 'Walk the Line', 136, 2005, 'A chronicle of country music legend Johnny Cash''s life, from his early days on an Arkansas cotton farm to his rise to fame with Sun Records in Memphis, where he recorded alongside Elvis Presley, Jerry Lee Lewis and Carl Perkins.', 6, 1, 13, 7),
(7, 'Fight Club', 139, 1999, 'An insomniac office worker and a devil-may-care soap maker form an underground fight club that transforms into a violent revolution.', 7, 5, 14, 8),
(8, 'Lord of the Rings: The Fellowship of the Ring', 178, 2001, 'An innocent hobbit of The Shire journeys with eight companions to the fires of Mount Doom to destroy the One Ring and the dark lord Sauron forever.\r\n', 8, 5, 16, 9),
(9, 'Lord of the Rings: The Two Towers', 179, 2002, 'While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron''s new ally, Saruman, and his hordes of Isengard.', 8, 5, 17, 9),
(10, 'Lord of the Rings: The Return of the Ring', 201, 2003, 'Aragorn leads the World of Men against Sauron''s army to draw the dark lord''s gaze from Frodo and Sam who are on the doorstep of Mount Doom with the One Ring.', 8, 5, 18, 9),
(11, 'The Dark Knight', 152, 2008, 'When Batman, Gordon and Harvey Dent launch an assault on the mob, they let the clown out of the box, the Joker, bent on turning Gotham on itself and bringing any heroes down to his level.', 9, 5, 19, 10),
(12, 'Gone with the Wind', 238, 1939, 'American classic in which a manipulative woman and a roguish man carry on a turbulent love affair in the American south during the Civil War and Reconstruction', 10, 4, 21, 11),
(13, 'Singin'' in the Rain', 103, 1952, 'A silent film production company and cast make a difficult transition to sound.', 11, 4, 23, 12),
(14, 'Double Indemnity', 107, 1944, 'An insurance rep lets himself be talked into a murder/insurance fraud scheme that arouses an insurance investigator''s suspicions.', 13, 2, 26, 13),
(15, 'Secret Window', 96, 2004, 'A writer is accused for plagiarism by a strange man, who then starts haunting him for "justice."', 12, 2, 27, 14),
(16, 'Untouchables', 119, 1987, 'Federal Agent Eliot Ness sets out to stop Al Capone; because of rampant corruption, he assembles a small, hand-picked team.', 14, 5, 28, 15),
(17, 'The Departed', 151, 2006, 'Two men from opposite sides of the law are undercover within the Massachusetts State Police and the Irish mafia, but violence and bloodshed boil when discoveries are made, and the moles are dispatched to find out their enemy''s identities.', 15, 2, 31, 16),
(18, 'Groundhog Day', 101, 1993, 'A weatherman finds himself living the same day over and over again.', 16, 3, 34, 17),
(19, 'Inception', 148, 2010, 'In a world where technology exists to enter the human mind through dream invasion, a highly skilled thief is given a final chance at redemption which involves executing his toughest job to date: Inception.', 9, 2, 31, 18),
(20, 'The Matrix', 136, 1999, 'A computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against its controllers.', 17, 2, 37, 19),
(21, 'Forrest Gump', 142, 1994, 'Forrest Gump, while not intelligent, has accidentally been present at many historic moments, but his true love, Jenny, eludes him.', 19, 1, 39, 21),
(22, 'Casalanca', 102, 1942, 'Set in unoccupied Africa during the early days of World War II: An American expatriate meets a former lover, with unforeseen complications.', 20, 4, 40, 22),
(23, 'Gladiator', 155, 2000, 'When a Roman general is betrayed and his family murdered by an emperor''s corrupt son, he comes to Rome as a gladiator to seek revenge.', 21, 5, 42, 23),
(24, 'Braveheart', 177, 1995, 'William Wallace, a commoner, unites the 13th Century Scots in their battle to overthrow English rule.', 22, 5, 43, 24),
(25, 'Die Hard', 131, 1988, 'John McClane, officer of the NYPD, tries to save wife Holly Gennaro and several others, taken hostage by German terrorist Hans Gruber during a Christmas party at the Nakatomi Plaza in Los Angeles.', 23, 5, 44, 25),
(26, 'Snatch', 104, 2000, 'Unscrupulous boxing promoters, violent bookmakers, a Russian gangster, incompetent amateur robbers, and supposedly Jewish jewelers fight to track down a priceless stolen diamond.', 24, 5, 45, 26),
(27, 'The King''s Speech', 118, 2010, 'The story of King George VI of Britain, his impromptu ascension to the throne and the speech therapist who helped the unsure monarch become worthy of it.', 25, 1, 46, 27),
(28, 'The Social Network', 120, 2010, 'Harvard student Mark Zuckerberg creates the social networking website that would become known as Facebook, but is later sued by two brothers who claimed he stole their idea, and the co-founder who was later squeezed out of the business.', 7, 1, 48, 28),
(29, 'The Princess Bride', 98, 1987, 'A classic fairy tale, with swordplay, giants, an evil prince, a beautiful princess, and yes, some kissing (as read by a kindly grandfather).', 4, 4, 49, 29);

-- --------------------------------------------------------

--
-- Table structure for table `studio`
--

CREATE TABLE IF NOT EXISTS `studio` (
  `studio_id` int(11) NOT NULL AUTO_INCREMENT,
  `studioName` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `studioDescription` text COLLATE utf8_unicode_ci NOT NULL,
  `studioFoundation` year(4) NOT NULL,
  `movie_id` int(11) NOT NULL,
  PRIMARY KEY (`studio_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `studio`
--

INSERT INTO `studio` (`studio_id`, `studioName`, `studioDescription`, `studioFoundation`, `movie_id`) VALUES
(1, 'Universal Studios', 'Universal Studios is one of the longest-lived motion', 1912, 1),
(2, 'Universal Studios', 'Universal Studios is one of the longest-lived motion', 1912, 2);

-- --------------------------------------------------------

--
-- Table structure for table `writer`
--

CREATE TABLE IF NOT EXISTS `writer` (
  `writer_id` int(11) NOT NULL AUTO_INCREMENT,
  `writerFirstName` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `writerLastName` varchar(52) COLLATE utf8_unicode_ci NOT NULL,
  `movie_id` int(11) NOT NULL,
  PRIMARY KEY (`writer_id`),
  KEY `movie_id` (`movie_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=31 ;

--
-- Dumping data for table `writer`
--

INSERT INTO `writer` (`writer_id`, `writerFirstName`, `writerLastName`, `movie_id`) VALUES
(1, 'Matt', 'Damon', 1),
(2, 'Ben', 'Affleck', 1),
(3, 'Stephen', 'King', 2),
(4, 'John', 'Hughes', 3),
(5, 'Nora', 'Ephron', 4),
(6, 'Helen', 'Fielding ', 5),
(7, 'Gill', 'Dennis', 6),
(8, 'Jim', 'Uhls ', 7),
(9, 'Fran', 'Walsh', 8),
(10, 'Jonathon', 'Nolan', 11),
(11, 'Sidney ', 'Howard', 12),
(12, 'Adolph', 'Green', 13),
(13, 'Billy', 'Wilder ', 14),
(14, 'David', 'Koepp', 15),
(15, 'David', 'Mamet', 16),
(16, 'William', 'Monahan ', 17),
(17, 'Danny', 'Rubin', 18),
(18, 'Christopher', 'Nolan', 19),
(19, 'Andy', 'Wachowski', 20),
(20, 'Lana', 'Wachowski', 20),
(21, 'Eric', 'Roth', 21),
(22, 'Julius J.', 'Epstein', 22),
(23, 'David', 'Franzoni', 23),
(24, 'Randall', 'Wallace', 24),
(25, 'Jeb', 'Stuart', 25),
(26, 'Guy', 'Ritchie', 26),
(27, 'David', 'Seidler ', 27),
(28, 'Aaron', 'Sorkin', 28),
(29, 'William', 'Goldman', 29);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `movie`
--
ALTER TABLE `movie`
  ADD CONSTRAINT `movie_ibfk_1` FOREIGN KEY (`director_id`) REFERENCES `director` (`director_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `movie_ibfk_2` FOREIGN KEY (`genre_id`) REFERENCES `genre` (`genre_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `movie_ibfk_3` FOREIGN KEY (`actor_id`) REFERENCES `actor` (`actor_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `movie_ibfk_4` FOREIGN KEY (`writer_id`) REFERENCES `writer` (`writer_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `writer`
--
ALTER TABLE `writer`
  ADD CONSTRAINT `writer_ibfk_1` FOREIGN KEY (`movie_id`) REFERENCES `movie` (`movie_id`) ON DELETE CASCADE ON UPDATE CASCADE;