Database Creation Script: Create the MOVIE table

$$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 Conceptual Design

Logical Design

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