Question: 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: Customer

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:Customer

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

Step by Step Solution

3.42 Rating (139 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The PreferredC... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related A Practical Guide To Database Design Questions!