Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

Engineering


Home >> Computer Engineering

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.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M92024363

Have any Question?


Related Questions in Computer Engineering

The current price of dumbas common stock is 25 per share

The current price of DUMBA's common stock is $25 per share. You plan on buying it today, holding it for 4 years, and then selling it. You anticipate receiving a dividend per share of $1.00 one year from today, $2.00 two ...

Argue why wireshark should be outlawed and it is a clear

Argue why Wireshark should be outlawed and it is a clear violation of privacy act and then argue why it should not be out outlawed and that it is a vital resource to be freely used and does not violate the privacy act

When selecting a new computer identify the key components

When selecting a new computer, identify the key components that drive the performance of the machine. And, if you were to spend additional funds on increasing the computer's performance, which component would provide the ...

Question research different information systems management

Question : Research different information systems management disaster response plans of major organizations that have had to respond to fairly recent disasters. Discuss the results of the organization's recovery efforts.

Suppose i am designing a personnel database for a

Suppose I am designing a personnel database for a university. The university has three types of personnel: students, staff, and faculty. Here are the characteristics of the three groups: -All three groups have a name and ...

Please respondexplain the properties and characteristics of

PLEASE RESPOND Explain the properties and characteristics of Transmission Control Protocol/Internet Protocol (TCP/IP).

String firstnamearraychar gradearrayassuming that this text

String firstName[ARRAY]; char grade[ARRAY]; Assuming that this text file is already inputted into the program. Write a loop that will display the students that have "A" or "B" next to their names. If the stuent has a "A" ...

System analysis and design1 describe a scenario in which

System Analysis and Design: 1) Describe a scenario in which the distribution of users determine the output technology. 2) What is the difference between gradual conversion and modular conversion? 3) At University, the co ...

Question in a sequence diagram how do you represent a newly

Question : In a sequence diagram, how do you represent a newly created object? What is the difference between components and artifacts?

Write a java console application that calculates and

Write a java console application that calculates and displays the bank interest for N bank accounts. N should be declared as a constant and it should be equal to the largest digit of your student ID number (e.g. if your ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved