If the attribute “PreferredCreditCard” is to be added, how would the entity/ attribute list change?

Referring to the data model shown in Figure 2.8:

Transcribed Image Text:

Customer "Customer Identifier Customer TelephoneNumber CustomerName Customer Street Address CustomerCity Customer State Customer ZipCode CustomerCreditRating Order Advertised Item "ItemNumber ItemDescription ItemDepartment Item Weight ItemColor ItemPrice Ordered Item **OrderNumber "ItemNumber QuantityOrdered Selling Price ShippingDate **OrderNumber Customeridentifer Order Date Shipping Street Address Shipping City Shipping State ShippingZipCode CustomerCredit CardNumber ShippingDate Credit Card **CustomerCredit CardNumber CustomerCredit CardName Customeridentifier FIGURE 2.8 The final entity/attribute diagram. Supplier **Supplier ID SupplierName Supplier Street Address SupplierCity SupplierState Supplier ZipCode Restock Item **Supplier ID **ItemNumber Reorder Price