Using the physical data model in Figure 3.2, for a specific Advertised_Item, describe the sequence of tables to find the Supplier having the lowest price for that item. Are any indexes necessary and why?

Transcribed Image Text:

Customer **CustomerIdentifier Customer TelephoneNumber CustomerName CustomerStreetAddress CustomerCity CustomerState CustomerZipCode CustomerCredit Rating CustPreferredCredit Card Order **OrderNumber Customeridentifer Ordered Item **OrderNumber **ItemNumber OrderDate Shipping Street Address Shipping City Shipping State Credit Card **Customer Credit CardNumber Customer Credit CardName Advertised Item **ItemNumber ItemDescription ItemDepartment Item Weight ItemColor ItemPrice LowestPrice LowestPriceSupplier QuantityOrdered Selling Price ItemShipping Date ShippingZipCode CustomerCredit CardNumber OrderShippingDate Order TotalCost CustomerIdentifier PreferredOption FIGURE 3.2 The physical data model. Supplier **SupplierID Supplier Name Supplier Street Address SupplierCity Supplier State Supplier ZipCode Restock_Item **SupplierID **ItemNumber ReorderPrice