Question

Draw an EER that models the given requirements.

Consider modeling a bank:

• The bank keeps personal information of each customer including name, sex, address, phone number, social security number, and date of birth.
• Each customer owns one or more bank accounts (The bank does not support a joint account shared with multiple customers).
• Each bank account is specified with the account number, open date, and type.
• An account may have several transactions (deposit/withdrawal). A transaction has a unique ID, amount, date, and type.

Answer 1

Draw an EER that models the given requirements  

consider modeling a bank:

What is EER Diagram?

Enhanced entity- relationship(EER) diagrams are basically an expanded upon version of ER diagrams EER models are helpful tools for desiging database with high level models

Above EER Diagram explonation: above example consisting 4 classes and specific attributes and provide the relationship in between classes

Important Point: doubled dash line in between two classes represents the Total Participation

single dash line in between two classes represents the partial participation

Total participation: the total participation means each entity involved in the relationship

partial participation: the partial participation means not all entites are involved in the relationship

- kindly requesting upvote rating my answer and my answer clearly explain 100 % correct my answer please rating my answer