Connor at 13:15, 6 August 2012

2012-08-06T13:15:10Z

Connor: Created page with "

Movie Database

This database features two entities (movies and actors) in a many-to-many relation. Each entity has its own table. A third table, casti..."

2012-07-11T08:39:05Z

Created page with "<h3>Movie Database</h3> <p>This database features two entities (movies and actors) in a many-to-many relation. Each entity has its own table. A third table, <i>casti..."

New page
<h3>Movie Database</h3>

<p>This database features two entities (movies and actors) in a
many-to-many relation. Each entity has its own table. A third
table,
<i>casting</i>

, is used to link them. The relationship is many-to-many because
each film features many actors and each actor has appeared in
many films.</p>

<h2>movie</h2>

<table border="1">
<tr>
<th>Field name</th>
<th>Type</th>
<th>Notes</th>
</tr>

<tr>
<td notranslate="1">id</td>
<td notranslate="1">INTEGER</td>
<td>An arbitrary unique identifier</td>
</tr>

<tr>
<td notranslate="1">title</td>
<td notranslate="1">CHAR(70)</td>
<td>The name of the film - usually in the language of the
first release.</td>
</tr>

<tr>
<td notranslate="1">yr</td>
<td notranslate="1">DECIMAL(4)</td>
<td>Year of first release.</td>
</tr>

<tr>
<td notranslate="1">director</td>
<td notranslate="1">INT</td>
<td>A reference to the actor table.</td>
</tr>

<tr>
<td notranslate="1">budget</td>
<td notranslate="1">INTEGER</td>
<td>How much the movie cost to make (in a variety of currencies unfortunately).</td>
</tr>
<tr>
<td notranslate="1">gross</td>
<td notranslate="1">INTEGER</td>
<td>How much the movie made at the box office.</td>
</tr>
</table>

<h2>actor</h2>

<table border="1">
<tr>
<th>Field name</th>

<th>Type</th>

<th>Notes</th>
</tr>

<tr>
<td notranslate="1">id</td>

<td notranslate="1">INTEGER</td>

<td>An arbitrary unique identifier</td>
</tr>

<tr>
<td notranslate="1">name</td>

<td notranslate="1">CHAR(36)</td>

<td>The name of the actor (the term actor is used to refer to
both male and female thesps.)</td>
</tr>
</table>

<h2>casting</h2>

<table border="1">
<tr>
<th>Field name</th>

<th>Type</th>

<th>Notes</th>
</tr>

<tr>
<td notranslate="1">movieid</td>

<td notranslate="1">INTEGER</td>

<td>A reference to the movie table.</td>
</tr>

<tr>
<td notranslate="1">actorid</td>

<td notranslate="1">INTEGER</td>

<td>A reference to the actor table.</td>
</tr>

<tr>
<td notranslate="1">ord</td>

<td notranslate="1">INTEGER</td>

<td>The ordinal position of the actor in the cast list. The
star of the movie will have ord value 1 the co-star will have
value 2, ...</td>
</tr>
</table>

<hr />

<h2>Footnotes</h2>
<p>This data has been drawn from the [http://www.imdb.com/ Internet Movie Database] The cast lists have been truncated to exclude those actors with a single appearance.</p>

<p>New releases and English language films are predominant.</p>

<p>Often the the title is in the original language thus '''My Life as a Dog''' is '''Mitt liv som hund''' and '''The Good the Bad and the Ugly''' is '''Buono, il brutto, il cattivo, Il'''</p>

<p>Because of the actor culling the ord values may not be consecutive for a given film.</p>

@@ Line 55: / Line 55: @@
      </tr>
    </table>
    <h2>actor</h2>
@@ Line 84: / Line 90: @@
      </tr>
    </table>
-  <h2>casting</h2>
+ <h2>casting</h2>
    <table border="1">
@@ Line 123: / Line 135: @@
 </table>
- <hr />
+<h2>Example</h2>
+<table border="1">
-<h2>Footnotes</h2>
+<tr><th>'''movieid'''</th><th>'''actorid'''</th><th>'''ord'''</th></tr>
-<p>This data has been drawn from the [http://www.imdb.com/ Internet Movie Database] The cast lists have been truncated to exclude those actors with a single appearance.</p>
+<tr><td>10003</td><td>20</td><td>4</td></tr>
+<tr><td>10004</td><td>50</td><td>1</td></tr>
-<p>New releases and English language films are predominant.</p>
+</table>
-−
-<p>Often the the title is in the original language thus '''My Life as a Dog''' is '''Mitt liv som hund''' and '''The Good the Bad and the Ugly''' is '''Buono, il brutto, il cattivo, Il'''</p>
-−
-<p>Because of the actor culling the ord values may not be consecutive for a given film.</p>

More details about the database. - Revision history

Connor at 13:15, 6 August 2012

Connor: Created page with "

Movie Database