Fundamentals of Database Managment – By Mark

Fundamentals of Database Managment – By Mark

I need one of these two answered: Including a graphic image with
your design is encouraged, as visuals are much more effective at
communicating such designs than a text description. If the graphic
is sizable, your report will be easier to read if you include it as
an appendix, and refer to it in your report; however, a moderately
sized graphic is appropriate to include in the body of your
report.MINICASES 1. Consider the Happy Cruise Lines relational database
in Minicase 5.1.The company has decided to reconfigure this
database as a distributed database among its major locations: New
York, which is its headquarters, and its other major U.S. ports,
Miami, Los Angeles, and Houston. Distributed and replicated among
these four locations, the tables have the following
characteristics:SHIP consists of 20 records and is used in all four cities.
CRUISE consists of 4,000 records. CRUISE records are used most
heavily in the cities from which the cruise described in the record
began. PORT consists of 42 records. The records that describe
Atlantic Ocean ports are used most heavily in New York and Miami.
The records that describe Caribbean Sea ports are used most heavily
in Houston and Miami. The records that describe Pacific Ocean ports
are usedmost heavily in Los Angeles. VISIT consists of 15,000
records and is primarily used in New York and Los Angeles.
PASSENGER consists of 230,000 records and is primarily used in New
York and Los Angeles. VOYAGE consists of 720,000 records and is
used in all four cities. Design a distributed relational database
for Happy Cruise Lines. Justify your placement, replication, and
partitioning of the tables.2. Consider the Super Baseball League relational database in
Minicase 5.2. The league has decided to organize its database as a
distributed database with replicated tables. The nodes on the
distributed database will be Chicago (the league’s headquarters),
Atlanta, San Francisco (where the league personnel office is
located), and Dallas. The tables have the following
characteristics: TEAM consists of 20 records and is located in
Chicago and Atlanta.COACH consists of 85 records and is located in San Francisco and
Dallas. WORKEXP consists of 20,000 records and is located in San
Francisco and Dallas. BATS consists of 800,000 records and is
located in Chicago and Atlanta. PLAYER consists of 100,000 records
and is located in San Francisco and Atlanta. AFFILIATION consists
of 20,000 records and is located in Chicago and San Francisco.
STADIUM consists of 20 records and is located only in Chicago.
Assume that telecommunications costs among the cities are all about
the same. Develop and justify a plan for solving the following
queries: a. A query is issued from Chicago to get a list of all the
work experience of all the coaches on the Dodgers. b. A query is
issued from Atlanta to get a list of the names of the coaches who
work for the team based at Smith Memorial Stadium. c. A query is
issued from Dallas to find the names of all the players who have
compiled a batting average of at least. 300 while playing on the
Dodgers.

Is this the question you were looking for? If so, place your order here to get started!