129 CHAPTER 2 Introduction to Structured Query Language James Morgan owns and operates Morgan Importing, which purchases antiques and home furnishings in Asia, ships those items to a warehouse facility in Los Angeles, and then sells these items in the United States. James tracks the Asian purchases and subse- quent shipments of these items to Los Angeles by using a database to keep a list of items purchased, shipments of the purchased items, and the items in each shipment. His data- base includes the following tables: ting ITEM (atemID, Description, Purchase Date, Store, City, Quantity LocalCurrencyAmount, ExchangeRate) SHIPMENT (ShipmentID, ShipperName, ShipperInvoiceNumber Departure Date, ArrivalDate, InsuredValue) SHIPMENT ITEM (ShipmentID, ShipmentltemID, ItemID, Value) In the database schema above, the primary keys are underlined and the foreign keys are shown in italics. The database that James has created is named MI, and the three tables in the MI database schema are shown in Figure 2-62 The column characteristics for the tables are shown in Figures 2-63, 2-64, and 2-65. The data for the tables are shown in Figures 2.66.2-67,and 2-68. The relationship between ITEM RE 2-62 l Database The ITEM table ITEM HIPMENT hippertine The SHIPMENTQuantit table DepartureCate Date The SHIPMENT ITEM table EschangeRate HPMENT ITEM