Using the Physical Data Model in Figure 3.2, describe the sequence of tables to be accessed in order to show, for an advertised item, the available suppliers for each that have a customer rating of “4” or better.

Transcribed Image Text:

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