Figure below is the EER Schema for a Video streaming platform. Map this schema into a relational schema. Make sure to specify all primary keys and foreign keys. Provide Relational Schema in the format shown in the lecture slides (Module: Mapping ER model to Relational Model: See page 2 of this assignment for an example).

Figure below is the EER Schema for a Video streaming platform. Map this schema into a relational schema. Make sure to specify all primary keys and foreign keys. Provide Relational Schema in the format shown in the lecture slides (Module: Mapping ER model to Relational Model: See page 2 of this assignment for an example). Titleid Name Country Name Actorld DOB Description Year Name ACTOR ACTS_IN TITLE -BELONGS TO GENRE Description MOVIE A TVSHOW Age_Rating Age_Rating Started Completed TV Channel HAS IN LIST End Time Duration Chapter_code WATCHING_TITLE Date CHAPTER Description Duration Minute WATCHING_MOVIE End_Time Completed Age Rating WATCHING_CHAPTER Minute First_Name email Middle Name USER Last_Name DOB NOTE, the expected solution should look like this: BOOK Book_id Title Publisher_name BOOK_AUTHORS Book_id Author_name PUBLISHER Name Address Phone BOOK_COPIES Book_id Branch_id No_of_copies BOOK_LOANS Book_id Branch_id Card_no Date_out Due_date LIBRARY_BRANCH Branch_id Branch_name Address BORROWER Card_no Name Address Phone Advice: - Look that all the lines are individual lines that go from one attribute to another. Please don't merge or reuse lines, lines need to be INDIVIDUAL always, including if they are 3 lines pointing to the same place, like in book_id