Consider the following ER diagram for a bank conceptual database schema: See image.

Task:

  • List the non-weak entity tpes in the ER diagram
  • Identify any weak entity type, and give its name, its partial key, and its identifying relationship and entity
  • Explain rule(s) that are used to map a weak entity type to a relation (table).
  • List the names of all relationship types, and specify the cardinality constraints. Each BANK is related to one or more BANK-BRANCHEs. Each BANK_BRANCH has zero or more LOANs and zero or more ACCOUNTs. Each ACCOUNT is related to exactly one BANK-BRANCH and to at least one CUSTOMER. Each LOAN is related to exactly one BANK_BRANCH and to at least one CUSTOMER. Each CUSTOMER is related to zero or more ACCOUNTs and to zero or more LOANs.
  • Specify the (min, max) constraint on each participation of an entity type in a relationship type. The additional (min, max) constraints are: Every customer must have at least one account but is restricted to at most two loans at a time, and that a bank branch cannot have more than 500 loans.
  • Identify total participations in the diagram.
Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.