中等ICT-DBAS-004
One borrower can have many loans, and each loan belongs to one borrower. How should this be stored?
A. As a one-to-one link that allows only one loan forever.
B. With the borrower's full address typed again on every loan, and no keys.
C. As a one-to-many relationship, storing the borrower id on each loan.✓ 答案
D. It cannot be stored in a database.
解說
One borrower to many loans is one-to-many. The borrower id on the loan record is the foreign key. Repeating the address on every loan creates conflicting copies.