Given the following: A movie has attributes title, year, length, incolor An actor has attributes name, address, gender, birthdate A producer has attributes name, address, gender, networth A director has attributes name, address, gender, studioaffliation A movie has one or more actors and an actor may act in many movies A producer may produce many movies and a movie may have one or more producers A director may direct many movies but a movie has single director Some actors are producers and directors as well A) Draw an ERD in UML notation B) Convert the ERD from A) into a relational diagram Hint: Make sure to reduce many to many relationships to one to many 10 pts 10 pts