Your friend Phoebe, a manager of a chain of bookstores, wants to expand the activities at her bookstores to include movies. She has some ideas for how she wants to do this, and she needs you to help with database design activities to address these ideas. In particular, she would like you to design a database that can keep track of the movies, stars, and directors$$ data. For instance:

For each director, Phoebe wants to keep a record of his or her number, name, year of birth, and the year of death if he or she is deceased.

For each movie, Phoebe wants to list its number, title, year of production, type, its director, and the MPAA rating.

For each movie star, Phoebe needs to know his or her number, name, birthplace $($city and state$),$ year of birth, and the year of death if he or she is deceased.

In addition, to support her business processing, Phoebe wants to be able to know who plays in what movies $($hint: think about the relationship between MOVIE and STAR. Is it $1$:$1,1$:N$,$ or M:N$?$ This will affect your database design for sure$).$b