(Answered): Q2: Figure below includes an EER diagram for a medium sized software vendor. Transform the diagram ...

Q2: Figure below includes an EER diagram for a medium sized software vendor. Transform the diagram into a relational schema that shows referential integrity constraints. Verify that resulting relations are in 3NF. [5M] EMPLOYEE Emp ID Emp Name Emp Type Belongs To REGION Region ID Region Name COUNTRY Country ID Country Name o COUNTRY MANAGER DEVELOPMENT MANAGER Supervises DEVELOPER Developer Type Manage Supervises ASSIGNMENT Score Hours Rate MEMBERSHIP Joined Loft Leads PROJECT Pro ProjStart Date Prof End Date TEAM TD Team Name Responsible for Team Start Date Team End Date SENIOR WIZARD is Deputy JUNIOR Mentor GP 2019,2016 2015 anos