Problem 2. (25 pts) Understanding of E-R Diagrams Use the material on E-R Model

Question

Problem 2. (25 pts) Understanding of E-R Diagrams Use the material on E-R Model discussed in the book and in class to answer the following questions about E-R Model and E-R Diagrams: a) (5 pts) Consider the following E-R Diagram: Branch Bank bld pName webSite Branches bNo phone addr street city zip state Accounts Loans Account ald type balance Loan Lld type amount HasLoan ( HasAccount > M Customer cld CName cPhone which is the following statements can be inferred from the diagram?: I. If Bank = 100 and Branch = 1000, then Branches = 10. II. Every bank has at least one account since the relationship Accounts is 1 to N. III. Branch has three candidate keys, namely K = {bId, bNo}, k, = {LId, bNo}, and K3 = {ald, bNo}. IV. Both I and III V. None of the above Answer:

Explanation / Answer

Solution:

I is false because there can be a variable number of branches for a particular bank.

II is false

III is also true, three cardinality keys

Answer:

III

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.