ONLY USE ERDplus DO NOT USE ANY OTHER DATABASE MODELING TOOL ONLY ERD PLUS.

PLEASE TAKE A PICTURE OF EACH OF THE REQUIREMENTS FOR THE RELATIONSHIP

PLEASE DON'T USE THE CHEGG ANSWER THATS ALREADY ON HERE THAT IS NOT USING ERDPLUS

a. What is the key of the weak entity type on this diagram?

b. Draw this diagram using ERDPlus, but instead of using Chens notation, use both the (min, max) and the crows foot notation. Make sure that the structural constraints in your diagram reflect precisely those in the diagram above and, in addition, they also reflect the following refinement. Every customer must have at least one account but is restricted to at most two loans at a time. A bank branch cannot have more than 1,000 loans.

EXAMPLES OF THIS FOR DIFFERENT PROBLEMS

1. Consider the following ER diagram representing part of a BANK database. Use Crow's Foot notation to indicate the structural constraints on the CONFERENCE_REVIEW ERD: Use (min,max) notation to indicate the structural constraints on the CONFERENCE_REVIEW ERD