1. Update the RMO relational database design in Figure based on the changes that you made to the ERD. Be sure that all your database tables are in 3NF.

2. Write ODL schema specifications for all new classes and relationships that you added to the class diagram.
3. Verify that the new classes and relationships are accurately represented in the updated relational database design that you developed for question 1.
The €œRethinking RMO€ case in Chapter 5 asked you to consider additional things and relationships that would need to be modeled if RMO were to implement its own customer charge accounts. If you have not already done so, complete that exercise and update the ERD and class diagram accordingly, and then complete the followingtasks:

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