Describe How a Data Warehouse can be Used to Improve the Decision Making - IT Assignment Help

Assignment Task

Question 1 :
Describe how a data warehouse can be used to improve the decision making in a large government department and what benefits these improvements bring. Design the star schema for the data warehouse. In your answer specify the technology/processes underpinning such a data warehouse.

Question 2 :
(a) What is the difference between clustering and dense index? Is it possible in general to have two clustering indices on the same relation for different search keys? Explain your answer using an appropriate example.

(b) What are the causes of bucket overflow in a hash file organization? What can be done to reduce the occurrence of bucket overflows? Describe in detail using a specific scenario.

Question 3 :
What is the difference between conceptual and logical modelling? Explain if conceptual modelling is sufficient for the physical implementation of the design of a database (using SQL). Provide a detailed justification in support or against your explanation. Use any relevant scenario to explain your arguments.

Question 4 :
Consider a Happy Cruise Lines relational database. 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 Seaports 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, partitioning of the tables.

This IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.