Exercise 4 (ER Model) [25 points] Consider the following requirements about an online movie review system: .Every movie has a unique ID, name, year, length, brief description, and the url to its . Celebrities direct and act in movies. The database keeps the name and date of birth of . For a celebrity that acts in a movie, the database keeps what role he/she acts in. A .Production corporations produce movies. A production corporation has a name, a cover celebrities to identify a celebrity. celebrity might act in several roles in the same movie. website, and an address. The address includes street, city, state, and zip code. Each online user must have an email address (which is used to log in), a password and a name. A user also has to provide age and gender to the system Online users can write reviews for movies. A review has a title, content, a score ranging from 1 to 5, and a timestamp Online users can also make friends. They can add one another as a friend. Friendship is bi-directional 1 meaning "A is a friend of B" implies that "B is a friend of A". Design an Entity-Relationship diagram that models the online movie review system and takes into account the requirements listed above. That means that you have to identify suitable entity sets, relationship sets, attributes, keys of entity sets, and so on. Further, add the cardinalities (1:1, 1:m, m:1, :n) to the relationship sets Exercise 4 (ER Model) [25 points] Consider the following requirements about an online movie review system: .Every movie has a unique ID, name, year, length, brief description, and the url to its . Celebrities direct and act in movies. The database keeps the name and date of birth of . For a celebrity that acts in a movie, the database keeps what role he/she acts in. A .Production corporations produce movies. A production corporation has a name, a cover celebrities to identify a celebrity. celebrity might act in several roles in the same movie. website, and an address. The address includes street, city, state, and zip code. Each online user must have an email address (which is used to log in), a password and a name. A user also has to provide age and gender to the system Online users can write reviews for movies. A review has a title, content, a score ranging from 1 to 5, and a timestamp Online users can also make friends. They can add one another as a friend. Friendship is bi-directional 1 meaning "A is a friend of B" implies that "B is a friend of A". Design an Entity-Relationship diagram that models the online movie review system and takes into account the requirements listed above. That means that you have to identify suitable entity sets, relationship sets, attributes, keys of entity sets, and so on. Further, add the cardinalities (1:1, 1:m, m:1, :n) to the relationship sets