Discussion Post: Database Systems
Consider the ER diagram shown in Figure 3.22 for part of a BANK database (also below for reference). Each bank can have multiple branches, and each branch can have multiple accounts and loans.
• List the strong (nonweak) entity types in the ER diagram.
• Is there a weak entity type? If so, give its name, its partial key, and its identifying relationship.
• What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram?
• List the names of all relationship types, and specify the (min,max) constraint on each participation of an entity type in a relationship type. Justify your choices.
The response should include a reference list. Using one-inch margins, Times New Roman 12 pnt font, double-space and APA style of writing and citations.