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?

Transcribed Image Text:

Table Catalog CatalogProduct Customer Attributes CataloglD, Season, Year, Description, EffectiveDate, EndDate CataloglD, ProductlD, Price, SpecialPrice AccountNo, Name, BillingAddress, ShippingAddress, DayTelephoneNumber, NightTelephoneNumber Inventoryltem InventorylD, ProductID, Size, Color, Options, QuantityOnHand, AverageCost, ReorderQuantity Order OrderlD, AccountNo, OrderDate, PriorityCode, ShippingAndHandling, Tax, GrandTotal, EmailAddress, ReplyMethod, PhoneClerk, CallStartTime, LengthOfCall, DateReceived, ProcessorClerk Orderltem OrderltemID, OrderlD, IrventorylD, TrackingNo, Quantity, Price, BackorderStatus OrderTransaction OrderTransactionlD, OrderlD, Date, TransactionType, Amount, PaymentMethod Productltem Returnltem Shipment Shipper ProductlD, Vendor, Gender, Description ReturnltemlD, OrderlD, InventorylD, Quantity, Price, Reason, Condition, Disposal TrackingNo, ShipperiD, DateSent, TimeSent, ShippingCost, DateArrived, TimeArrived ShipperlD, Name, Address, ContactName, Telephone