Please include steps and thought process. Thank you!

Question 7 (14 points) Produce a relational schema diagram that corresponds to the linked ER diagram for a database for the television show Saturday Night Live (SNL). Your relational schema diagram should include primary and foreign keys. Often-times in database system development, requirements will change after the conceptual data model has been drafted: in your rela- tional schema diagram, add the following three additional attributes: attribute "birth_date for the relation schema Host; attribute "start_date for the relation schema Writer; and attribute "salary" for relation schema Cast Member. Please refer back to the requirements in Question 6, for additional details that may constrain the design of the relational schema model. Use the tool linked to create an image. Hints: please carefully note that "rerun date, address, and phone" are multi-valued attributes; how would those be depicted in the relational schema diagram? Also, please carefully note the many-to-many relationships; how would those be depicted in the relational schema diagram? FYI: in ERDplus, define your primary key for a relation schema before you attempt to create a foreign key relationship to the relation schema. Figure 1: ER Diagram for Question 7 name Host 1 performed in 1 N season seq_num hosted N show id featured title N Show 1 live date M wrote rerun date Sketch P Q Writer performed in name N address name Cast member phone Question 7 (14 points) Produce a relational schema diagram that corresponds to the linked ER diagram for a database for the television show Saturday Night Live (SNL). Your relational schema diagram should include primary and foreign keys. Often-times in database system development, requirements will change after the conceptual data model has been drafted: in your rela- tional schema diagram, add the following three additional attributes: attribute "birth_date for the relation schema Host; attribute "start_date for the relation schema Writer; and attribute "salary" for relation schema Cast Member. Please refer back to the requirements in Question 6, for additional details that may constrain the design of the relational schema model. Use the tool linked to create an image. Hints: please carefully note that "rerun date, address, and phone" are multi-valued attributes; how would those be depicted in the relational schema diagram? Also, please carefully note the many-to-many relationships; how would those be depicted in the relational schema diagram? FYI: in ERDplus, define your primary key for a relation schema before you attempt to create a foreign key relationship to the relation schema. Figure 1: ER Diagram for Question 7 name Host 1 performed in 1 N season seq_num hosted N show id featured title N Show 1 live date M wrote rerun date Sketch P Q Writer performed in name N address name Cast member phone