Draw the entities and relationships suggested by each word problem. Include the proper

foreign key$($s$).$ Upload your results to Canvas as a $.$jpg or $.$pdf$.$ These problems are all M:N

relationships and ternary relationships. Put your name in the upper left hand corner of your

solution page. t$$s difficult to imagine that Leonardo DiCaprio would be as successful if it weren$$t for his

six movies directed by Martin Scorsese. It$$s just as hard to imagine Quentin Tarantino

not directing Samuel L$.$ Jackson. We want to keep a database of actors, movies and

directors $($together they make a Production$).$ Actors get an ActorID $($at imdb.com Fred

Astaire is actor $1)$ and we want their name, dob and date of first credited movie. Movies

get a MovieID $($at imdb.com the movie with ID $1$ is Carmencita$)$ and we want the movie

title, US release date and gross receipts $($how much money it made$).$ Directors get a

DirectorID $($imdb doesn$$t differentiate between actors and director, so Fred$$s still

number one$),$ and we want the director$$s name, year of first movie direction and

number of Academy Award nominations for Best Director. We assume that each

director, movie and actor has done this at least once before. We also need to capture

the salary paid to each actor for each movie and director and the ordinal place of each

actor$$s name in each directed movie.