A movie has a title, release date, rating $($e$.$g$.$ PG$-13),$ running time, director, and one or more

actors. Each movie is either a domestic or a foreign movie, but not both. A foreign movie uses a

language other than English and might provide English subtitles. Domestic movies are further

categorized into comedy, drama, action and horror movies. There are domestic movies that

belong to more than one genre. A comedy movie has a degree of $$funniness$$ which ranges

between $1$ and $5.$ A drama movie has a short description such as $$love story$,$documentary$,$

$$humanity$,$ etc.

Each movie is reviewed by one or more critics, each of whom gives an evaluation that ranges

from zero to five stars. A critic has a name and a unique phone number. A critic reviews one or

more movies.

Each movie is supplied by only one distributor. One distributor provides one or more movies.

For each distributor, we keep track of its unique name, address, and phone number. A

distributor$$s address consists of street$\_$address, city, state, and zip$\_$code. The individual

components of the address can be accessed separately, and the entire address can also be

retrieved as a unit.

Each movie might be nominated to one or more award and eventually might win one or more

award. Each award is associated with one or more nominated movie, but only one winner is

selected for each award. Movies can exist without receiving nominations or winning any awards.

We keep track of the name and year of each award. For each movie, the number of award

nominations and the number of award wins, if any, can be computed from the known

information.

Part $2$: Map the EER diagram from part $1$ into relational schemas $(20$ points$)$

Due: $3/1/2024$ by $11$:$59$ PM

Convert your EER diagram from part $1$ into relation schemas. In a PDF file, specify the

followings for each relation:

$($i$)$ the name of the relation,

$($ii$)$ the names of its attributes,

$($iii$)$ the domain of each attribute,

$($iv$)$ the primary key, and

$($v$)$ the foreign key$($s$),$ if any.

If needed, you can update your EER diagram from part $1$ before mapping. There is no required

format of your relation schemas. Submit your PDF file that has all the components listed

above for each relation and the EER diagram that your relation schemas are mapped from.