Database Design Sears Roebuck, the most well-known and oldest mail-order retailer in the country, discontinued its mail-order operations in 1993. Other mail-order marketers are using information systems to trim printing and postage costs of their catalogs. They also want to more effectively target their customers.

Explain how an appropriately designed coding system for inventory items (see Chapter 8), incorporated in a relational database system with SQL capabilities, could allow more cost-efficient and effective mail-order operations. Sketch the necessary database table structure.