Products, features, and substitute products: Your firm manufactures a variety of specialized data networking equipment. Each product has a unique model number, a description, and a date introduced....

Products, features, and substitute products: Your firm manufactures a variety of specialized data networking equipment. Each product has a unique model number, a description, and a date introduced. For each product, you also want to the database to keep a pricing history: a set of list prices for the product, each with the date that the price became effective. For each product, you also maintain a list of “features”; each feature has an ID and a description. A product may have many different features, and many different products may have the same feature. For each product, there is a single designated “best substitute” product you offer customers when you are out of stock. You want the database to remember the designated best substitute for each product.

Design a database to store this information. Draw an ER diagram, and write a database design outline. You may add “ID” fields where necessary.