Database Creation Script: Create the MOVIE table

act$\_$id act$\_$fname act$\_$lname act$\_$gender

$1$ James Stewart M

$2$ Deborah Kerr F

$3$ Peter Otoole M

$4$ Robert De Niro M

$5$ F$.$ Murray Abraham M

$6$ Harrison Ford M

$7$ Nicole Kidman F

$8$ Stephen Baldwin M

$9$ Jack Nicholson M

$10$ Mark Wahlberg M

$11$ Woody Allen M

$12$ Claire Danes F

$13$ Tim Robbins M

$14$ Kevin Spacey M

$15$ Kate Winslet F

$16$ Robin Willams M

$17$ Jon Voight M

$18$ Ewan McGregor M

$19$ Christian Bale M

$20$ Maggie Gyllenhaal F

$21$ Dev Patel M

$22$ Sigourney Weaver F

$23$ Kevin Spacey M

$24$ Denzel Washington M

$25$ Brad Pitt M

$26$ Edward Norton M

$27$ Julia Roberts F

$28$ Meryl Streep F

$29$ Liam Neason M

$30$ Ben Kingsley M

act$\_$id Mov$\_$id Role

$1100$ John Scottie Ferguson

$2101$ Miss Giddens

$3102$ T$.$E$.$ Lawrence

$4103$ Michael

$5104$ Antonio Salieri

$6105$ Rick Deckard

$7106$ Alice Harford

$8107$ McManus

$9108$ J$.$J$.$ Gittes

$10109$ Eddie Adams

$11110$ Alvy Singer

$12111$ San

$13112$ Andy Dufresne

$14113$ Lester Bumham

$15114$ Rose Dewitt Bukater

$16115$ Sean Maguire

$17116$ Eddie Adams

$18117$ Renton

$19118$ Alfred Borden

$20119$ Elizabeth Darko

$21120$ Older Jamal

$22121$ Ripley

$23122$ Bobby Darin

$24128$ Detective Keith Frazier

$24129$ Alonzo Harris

$25130$ Billy Beane

$26131$ The Narrator

$26132$ Lester Worm Murphy

$26133$ Aaron Stampler

$27134$ Erin Brockovich

$28135$ Linda

$29136$ Oskar Schindler

$30137$ Mahatma Gandhi

mov$\_$id mov$\_$title mov$\_$year mov$\_$time mov$\_$lang mov$\_$dt$\_$rel mov$\_$rel$\_$country

$100$ Vertigo $1958128$ English $24-$Aug$-1958$ UK

$101$ The Innocents $1961100$ English $19-$Feb$-1962$ SW

$102$ Lawrence of Arabia $1962216$ English $11-$Dec$-1962$ UK

$103$ Deer Hunter $1978183$ English $8-$Mar$-1979$ UK

$104$ Amadeus $1984160$ English $7-$Jan$-1985$ UK

$105$ Blade Runner $1982117$ English $9-$Sep$-1982$ UK

$106$ Eyes Wide Shut $1999159$ English $3-$Sep$-1999$ UK

$107$ The Usual Suspects $1995106$ English $25-$Aug$-1995$ UK

$108$ Chinatown $1974130$ English $9-$Aug$-1974$ UK

$109$ Boogie Nights $1997155$ English $16-$Feb$-1998$ UK

$110$ Annie Hall $197793$ English $20-$Apr$-1977$ USA

$111$ Princess Mononoke $1997134$ Japanese $19-$Oct$-2001$ UK

$112$ The Shawshank Redemption $1994142$ English $17-$Feb$-1995$ UK

$113$ American Beauty $1999122$ English $17-$Sep$-1999$ USA

$114$ Titanic $1997194$ English $23-$Jan$-1998$ UK

$115$ Good Will Hunting $1997126$ English $3-$Jun$-1998$ UK

$116$ Deliverance $1972109$ English $5-$Oct$-1982$ UK

$117$ Trainspotting $199694$ English $23-$Feb$-1996$ UK

$118$ The Prestige $2006130$ English $10-$Nov$-2006$ UK

$119$ Donnie Darko $2001113$ English $19-$Jan$-2001$ USA

$120$ Slumdog Millionaire $2008120$ English $12-$Nov$-2008$ USA

$121$ Aliens $1986137$ English $14-$Jul$-1986$ USA

$122$ Beyond the Sea $2004118$ English $17-$Dec$-2004$ USA

$123$ Avatar $2009162$ English $17-$Dec$-2009$ UK

$124$ Seven Samurai $1954207$ Japanese $26-$Apr$-1954$ JP

$125$ Spirited Away $2001125$ Japanese $12-$Sep$-2003$ UK

$126$ Back to the Future $1985116$ English $4-$Dec$-1985$ UK

$127$ Braveheart $1995178$ English $8-$Sep$-1995$ UK

$128$ Inside Man $2006129$ English $20-$Mar$-2006$ USA

$129$ Training Day $2001122$ English $2-$Sep$-2001$ USA

$130$ Moneyball $2011133$ English $19-$Sep$-2011$ USA

$131$ Fight Club $1999139$ English $10-$Sep$-1999$ USA

$132$ Rounders $1998121$ English $4-$Sep$-1998$ USA

$133$ Primal Fear $1996130$ English $3-$Apr$-1996$ USA

$134$ Erin Brockovich $2000130$ English $17-$Mar$-2000$ USA

$135$ The Deer Hunter $1979183$ English $23-$Feb$-1979$ USA

$136$ Schindler's List $1994195$ English $4-$Feb$-1994$ USA

$137$ Gandhi $1982191$ English $12-$Jun$-1982$ USA

$$Acts in$$ is many$-$to$-$many:

Since this relationship is many$-$to$-$many, it must be implemented at the logical level using the bridge entity CASTING $($see BR #$2$ and BR #$3$ below$)$

A row in the CASTING table represents an actor in a movie $($plus the role he$/$she played in that movie$)$

BR #$1$a: An ACTOR acts in zero or more $($many$)$ MOVIEs

BR #$1$b: A MOVIE has zero or more $($many$)$ ACTORs

$========================================================================$

$$Is cast in$$ is one$-$to$-$many:

This relationship helps implement the many$-$to$-$many relationship between ACTOR and MOVIE using CASTING as a bridge entity

BR #$2$a: An ACTOR is cast in zero or more $($many$)$ CASTINGs

BR #$2$b: A CASTING is tied to one and only one ACTOR

$========================================================================$

$$Contains$$ is one$-$to$-$many:

This relationship helps implement the many$-$to$-$many relationship between ACTOR and MOVIE using CASTING as a bridge entity

BR #$3$a: A MOVIE contains zero or more $($many$)$ CASTINGs

BR #$3$b: A CASTING is tied to one and only one MOVIEConceptual Design

Logical Design