Assume that RMO will use a relational database, as shown in Figure (a). Assume further that a new catalog group located in Milan, Italy, will now create and maintain the catalog. To minimize networking costs, the catalog group will have a dedicated database server attached to its LAN. Develop a plan to partition the RMO database. Which tables should be replicated on the catalog group€™s local database server? Update Figure (b) to show the new distributed database architecture.
(a)

(b)

Transcribed Image Text:

Corporate headquarters LAN Data center LAN Phone- order cen LAN Replicated database Central database server Wide area network partition Warehouse LAN three locations) Mail- order cente LAN Replicaterd database partition Replicated database partition