Consider Figure 1-15. While designing the attributes for the Customer table, is it necessary to designate an attribute, such as Customer ID, as a key field? Can we use an ordinary attribute, such as Customer Name, to determine the existence of a customer record? Why?

Figure 1-15

Transcribed Image Text:

CUSTOMER Places ORDER Contains Is Billed On INVOICE Is Paid On ORDER LINE PAYMENT Has PRODUCT LINE Includes PRODUCT