Question: Identify each entity (indicate it if the entity is a weak entity) and its ket attribute. Also, identify its attributes. Indicates it if an attribute

- Identify each entity (indicate it if the entity is a weak entity) and its ket attribute. Also, identify its attributes. Indicates it if an attribute is composite or multivalued or derived.
- For each relationship identify the cardinality ratio (one-to-one, one-to-many, many-to-one, or many-to-many), and describe the information it conveys considering both sides of relationship.
- For each relationship, identify the participation constraints (total or partial participation) and describe the information it conveys considering both sides of relationship.
- Indicate if the relationship is an identifying relationship (a relationship of a weak entity).
- Indicate attribute(s) of a relationship, if any.
BANK BRANCHES BANK BRANCH Code Name)( Addr Branch no ACCTS LOANS Acct no Loan_no ACCOUNT Type LOAN Type AC L_C Ssn Name CUSTOMER A Phone Addr
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
