# Opdracht De filmadministratie*

Jouw klant wil een administratie op stellen voor het verwerken van filmgegevens.

Bij elke film hoort de lijst met acteurs en het personage dat zij in de film speelden.

Verder moeten de gegevens van de volledige filmcrew worden opgeslagen.

De filmcrew bestaat uit de regisseur, cameramensen, etc, etc.

Jouw klant heeft een voorbeeld gegeven hoe het overzicht dat hij uit de database wil kunnen halen er uit ziet.

#### Voorbeeld overzicht

<table border="1" id="bkmrk-film-gegevens-%C2%A0-%C2%A0-fi" style="border-collapse: collapse; width: 100%; height: 919px;"><tbody><tr style="height: 29px;"><td style="width: 33.3333%; background-color: #f7e9c1; height: 29px;">**Film gegevens**</td><td style="width: 33.3333%; background-color: #f7e9c1; height: 29px;">  
</td><td style="width: 33.3333%; background-color: #f7e9c1; height: 29px;">  
</td></tr><tr style="height: 29px;"><td style="width: 33.3333%; height: 29px;">FilmID</td><td style="width: 33.3333%; height: 29px;">1999/57</td><td style="width: 33.3333%; height: 29px;">  
</td></tr><tr style="height: 29px;"><td style="width: 33.3333%; height: 29px;">Titel</td><td style="width: 33.3333%; height: 29px;">Bicentienniel Man</td><td style="width: 33.3333%; height: 29px;">  
</td></tr><tr style="height: 29px;"><td style="width: 33.3333%; height: 29px;">Productiehuis</td><td style="width: 33.3333%; height: 29px;">Touschstone Pictures</td><td style="width: 33.3333%; height: 29px;">  
</td></tr><tr style="height: 29px;"><td style="width: 33.3333%; height: 29px;">Release Data</td><td style="width: 33.3333%; height: 29px;">17 december 1999</td><td style="width: 33.3333%; height: 29px;">  
</td></tr><tr style="height: 29px;"><td style="width: 33.3333%; height: 29px;">MPAA rating</td><td style="width: 33.3333%; height: 29px;">PG</td><td style="width: 33.3333%; height: 29px;">  
</td></tr><tr style="height: 63px;"><td style="width: 33.3333%; height: 63px;">Korte inhoud</td><td style="width: 33.3333%; height: 63px;">In the first decade of the new millenium a new discovery is done.....</td><td style="width: 33.3333%; height: 63px;">  
</td></tr><tr style="height: 29px;"><td style="width: 33.3333%; height: 29px; background-color: #f7e9c1;">**Main cast**</td><td style="width: 33.3333%; height: 29px; background-color: #f7e9c1;">**Acteur**</td><td style="width: 33.3333%; height: 29px; background-color: #f7e9c1;">**Personage**</td></tr><tr style="height: 29px;"><td style="width: 33.3333%; height: 29px;">  
</td><td style="width: 33.3333%; height: 29px;">Robin Williams</td><td style="width: 33.3333%; height: 29px;">Andrew Martin</td></tr><tr style="height: 29px;"><td style="width: 33.3333%; height: 29px;">  
</td><td style="width: 33.3333%; height: 29px;">Sam Neil</td><td style="width: 33.3333%; height: 29px;">The Sentinel</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Loliver Patt</td><td style="width: 33.3333%; height: 35px;">Rupert Burns

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">An Delusion

</td><td style="width: 33.3333%; height: 35px;">Elise Stephard

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">...

</td><td style="width: 33.3333%; height: 35px;"></td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px; background-color: #f7e9c1;">**Crew**</td><td style="width: 33.3333%; height: 35px; background-color: #f7e9c1;">**Rol**

</td><td style="width: 33.3333%; height: 35px; background-color: #f7e9c1;">**Naam**

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Director

</td><td style="width: 33.3333%; height: 35px;">Cax Bischop

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Screen Writer

</td><td style="width: 33.3333%; height: 35px;">Nick Kazan

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Special Effects

</td><td style="width: 33.3333%; height: 35px;">Steve Jewel

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Special Effects

</td><td style="width: 33.3333%; height: 35px;">Thor Knight

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Producer

</td><td style="width: 33.3333%; height: 35px;">Mark Gardiff

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Custume Designer

</td><td style="width: 33.3333%; height: 35px;">Elisabeth Grand

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Custume Designer

</td><td style="width: 33.3333%; height: 35px;">Jason Bonne

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">Custume Designer

</td><td style="width: 33.3333%; height: 35px;">Carine Elisabeth Studs

</td></tr><tr style="height: 35px;"><td style="width: 33.3333%; height: 35px;">  
</td><td style="width: 33.3333%; height: 35px;">...

</td><td style="width: 33.3333%; height: 35px;"></td></tr></tbody></table>

Teken het volledige ERD in Lucichart en lever een screendump in waar alle entiteiten duidelijk te zien zijn en waar alle attributen, keys en relaties zijn weergegeven.

\--