Question

Assume that RMO plans to change its pricing policy. If two or more catalogs are in circulation at the same time, then all item prices in the catalogs must be the same. Prices can still rise or fall over time and those changes will be recorded in the database and printed in newly issued catalogs. Any customer who makes an order will always be given the lower of the current price or the price in the current catalog. What changes to the tables shown in Figure will be required to ensure that the RMO database is in 3NF after the pricing policychange?


$1.99
Sales0
Views210
Comments0
  • CreatedDecember 27, 2012
  • Files Included
Post your question
5000