Design distributed relational database for happy cruise line

Assignment Help Basic Computer Science

Reference no: EM131269632

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 used most 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.

Reference no: EM131269632

Questions Cloud

Define the nature of knowledge management : Explain the quote and make sure to define the nature of knowledge management and the types and kinds of leadership challenges that knowledge management engenders.

Clarify the leadership style of this leader : BUS413 - Write a brief Biography and historical analysis that explain the origins and significance events of the leader and explain the main qualities of this leader that affect success in five aspects of his life, with examples.

What are some of the changes between leaders : What are some of the changes between leaders in the 20th Century and the 21st Century?

Did barclays bank neglect social responsibility : What actions regarding Corporate Social Responsibility (CSR) could Barclays have engaged in after the scandal broke to set things right and ensure that such an event would not happen again?

Design distributed relational database for happy cruise line : Design a distributed relational database for Happy Cruise Lines. Justify your placement, replication, and partitioning of the tables.

What is total change in profit for a change in production : The weekly marginal profit for an output of x units is given.- What is the total change in profit for a change in production from 10 units per week to 40 units?

Determine the standard deviation over the period : Determine the Rate of Return over the sample period for the stock. Determine the Std. Deviation over the period. Determine the Correlation with the S&P 500.

Component of the cost of building the new road : Suppose that the construction of a new road by the government would divert traffic from an older road, thereby driving some of the gas stations on the older road out of business. Discuss the factors that determine the extent to which this should be t..

Discussion of response time and logistics costs presented : Pick two of the six distribution networks discussed, compare them in terms of response time and logistics costs (inventory cost, facilities cost, and transportation cost). Do the differences in response time and logistics costs fit with the discussio..

User Account

All Pages