edited by
590 views
1 votes
1 votes

Consider the following ER diagram :


“borrower” mapping cardinality is many-to-many. While converting the ER diagram into a relational DBMS model, the relationship set “borrower” is converted into a relation

borrower(cust_id, loan_id, access_date)

, what is the primary key of “borrower”?

  1. cust_id 
  2. loan_id 
  3. (cust_id, loan_id) 
  4. (cust_id, loan_id, access_date) 
edited by

1 Answer

3 votes
3 votes

Relation schema for borrower:

  • Primary key of customer is cust_id
  • Primary key of loan is loan_id
  • Descriptive attribute access_date
  • borrower mapping cardinality is many-to-many
borrower(cust_id, loan_id, access_date)

Where

(cust_id, loan_id)

Is the primary key.

Answer:

No related questions found