Databases Reference
In-Depth Information
MINICASES
1.
Happy Cruise Lines is headquartered in New York and
in addition has regional offices in the cruise port cities
of Miami, Houston, and Los Angeles. New York has a
large server and several LANs. The other three sites each
have a single LAN with a smaller server. The company's
four offices communicate with each other via land-based
telecommunications lines. The company's ships, each
of which has a server on board, communicate with the
New York headquarters via satellite. Also located in
New York is the company's Web site, through which
passengers and travel agents can book cruises.
a. Devise a data security strategy for Happy Cruise
Lines
individual teams. Each team has a server with a LAN
at its stadium or offices near the stadium. The League
has a server with a LAN at its Chicago headquarters.
The league and each of the teams maintain a Web site
at their locations. People can get general information
about the league at the league's Web site; they can
get information about the individual teams as well as
buy game tickets through each team's Web site. Data
collected at the team locations, such as player statistics
updates and game attendance figures, is uploaded nightly
to the server at league headquarters via telephone lines.
a. Devise
a
data
security
strategy
for
the
Super
that
incorporates appropriate
data security
Baseball
League,
incorporating
appropriate
data
measures.
b. Happy Cruise Line's main relational database (see
Minicase 5.1), located in New York, is considered
critical to the company's functioning. It must be kept
up and running as consistently as possible and it must
be quickly recoverable if something goes wrong.
Devise backup and recovery and disaster recovery
strategies for the company.
c. A particularly popular Christmas-week cruise is
booking up fast. There are only a few cabins left and
the company wants to be careful to not ''overbook''
the cruise. With customers, travel agents, and the
company's own reservations agents all accessing the
database at the same time, devise a strategy that will
avoid overbooking.
2.
The Super Baseball League maintains a substantially
decentralized IS organization with the focus on the
security measures.
b. The Super Baseball League's main relational
database (see Minicase 5.2), located at its head-
quarters in Chicago, is for the most part a repository
of data collected from the teams. The league wants
to keep the headquarters database up and running,
but it is more important to keep the individual team
databases in their stadiums or offices up and running
with as little downtime as possible. Devise backup
and recovery and disaster recovery strategies for the
Super Baseball League.
c. Fans can order or buy tickets from the individual
teams over the telephone, through the teams' Web
sites, or in person at the teams' box offices. All of this
activity takes place simultaneously. Devise a strategy
that will avoid selling a particular seat for a particular
game more than once.
Search WWH ::
Custom Search