Assume that RMO plans to change its pricing policy. If two or more catalogs are in circulation

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?
Assume that RMO plans to change its pricing policy. If
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Systems analysis and design in a changing world

ISBN: 978-1423902287

5th edition

Authors: John W. Satzinger, Robert B. Jackson, Stephen D. Burd

Question Posted: