Mapping Er Model to Relational Model Points: 50 points Instruction Portament you must documente in pet or decom Four belowie EER Schena forma de pense a relational schema. Make sure to sell primary keys and foreign e Provider Scheme in the format shown in the lecture ideaing made to en Model S PRO2 of the more NOTE, espected on should booking Advice in the version Ludhat to do but now you to things the thing Else Look that all the lines are individuals that go from one tribute to another don't mange or reuses, lines need to beINDIVIDUAL says, including the ines pointing to the same place, thin book Name Description RACE 1 year Country Category LAS EDITION N TEAM_ENTRY RACE_INVITATION N RACE_EDITION order HAS_STAGE date start N end Races_in N STAGE TEAM_INVITED position 1 Baces_in_stage M time license id Team_id date_end date_start RIDER height weight name N TEAM Belongs PERSON Category person_id STAFF N name has_role M ROLES birth date role name NOTE, the expected solution should look something like this: CHAPTER Titleid ChapterCode Description Duration End Time AgeRate WATCH CHAPTER Thield Chapter Code GENRE Nome Minute Description Email Complete TV SHOW Title BELONGS TO Name TVChannel AgRating Titteld MOVIE Titled TITLE Titled Name Country VON Description Duration End Time AgeRating WATCHING MOVIE Title email ACTS IN Actorld Minute TYPE Titled WATCHING TITLE Titled ACTOR Actorld Started Completed Name DOB USER email FirstName Middle Name LastName DOB Advice: I usually use the free version of LucidChart to do it, but any tool that allows you to draw things like this is enough. Excel + some arrows allows it 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. Figure below is the EER Schema for a simplified cycling races database. 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)