Discussion Post: Database Systems
Part I
Create a discussion thread (with your name) and answer the following question(s):
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.
Part II
Create a discussion thread (with your name) and answer the following question(s):
Discuss the characteristics of relations that make them different from ordinary tables and files.
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.