Question: Please answer letters A-E based on the problem below: PART II (25 points) - ER model: This ER model was created for the sole purposes
Please answer letters A-E based on the problem below:

PART II (25 points) - ER model: This ER model was created for the sole purposes of this homework. Project Management Institute (PMI) is a real company. Project Management Professional (PMP) is a real certification. The ER model below is a subset of how the data may be captured by this company. A person may join PMI as a member before attaining a PMP certification. The general PMI membership must be renewed every year for a yearly fee. Before a person can obtain a PMP certification, five items must be obtained: active member of PMI, 4 year degree, 36 months experience leading projects, 35 hours of project coursework, and passing the three hour proctored PMP test with a passing grade of 80%. The PMP certification is good for three years. To obtain a renewal of the certification, the person must do 60 Professional Development Units (PDU) within the three year time frame. The PMP renewal also includes a fee. Based on the ER model: A. List the name of each entity (5 points) B. List the entities that have an FK; list both the entity and the FK attribute (5 points) C. Which entities share a one to many relationship. List each entity pair and explain how the one to many relationship adheres to the business rules stated (5 points) D. With which other entities does the Person entity share an optional relationship? Explain under what circumstances an optional relationship is needed. (5 points) E. There are two relationships in the ERD that represent one-to-one cardinality with mandatory participation. For each example, list the two entities involved and explain the benefit of the cardinality and participation rules. (5 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
