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 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
The PreferredC... View full answer
Get step-by-step solutions from verified subject matter experts
