The following is a description of a database that keeps track of information about movies.

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.