1. For each relationship, identify the participation constraints (total or parti
ID: 3744128 • Letter: 1
Question
1. For each relationship, identify the participation constraints (total or partial participation) and describe the information it conveys considering both sides of relationship.
2. Indicate if the relationship is an identifying relationship (i.e., a relationship of a weak entity).
3. Indicate attribute(s) of a relationship, if any.
Figure 3.21 An ER diagram for a BANK database schema. BANK BRANCHES BANK_BRANCH ode Name Addr Addr Branch no ACCTS LOANS Acct no Balance Loanno Amount ACCOUNT Type LOAN ype A C L C Ssn Name Phone CUSTOMER AddrExplanation / Answer
BRANCHES
1) total participation because every bank_branch is branches of the bank.it conveys information about bank code name address and branch no., branch address.
2) it is a weak entity because the bank needs to identify its branch
3) branch no is the relationship attributes.
LOANS
1) Total participation because each loan belongs to any of the branches.it conveys information about the address, branch no., loan no., amount, type.
2) it is a weak entity because of we need branch no. and loan no. to identify loan.
3)loan no.,branch no. is the relationship attributes.
ACCTS
1) Total participation because each account belongs to any of the branches. it conveys information about account no., balance, type, branch no., address.
2) it is a weak entity because of we need branch no and account no.to identify account.
3) branch no and account no. is the relationship attributes.
A_C
1) Total participation because each customer has an account. it conveys information about account no., balance, type,ssn, name, address, phone.
2) it is a strong entity because one customer can have two or more account.
3) ssn and account no. is the relationship attributes.
L_C
1) partial participation because every customer does not have a loan account. it conveys information about loan no., amount, type,ssn, name, address, phone.
2) it is a strong entity because one customer can have two or more loan account.
3) ssn and loan no. is the relationship attributes.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.