Computers and Technology, 25.12.2019 07:31 JeroMii

You work for a large corporation that has just purchased 2 hotel and resort corporations each consisting of over 100 hotels. each corporation operates a custom database. you are provided the data dictionary and er diagrams for the two operational databases. management would like you to design a data warehouse that allows them to achieve the most competitive advantage possible.

(note: the databases you will evaluate come from student groups in another class responding to the hokie resort problem. this problem also is provided for your review.)

to achieve this you decide to do the following:

review the hokie resort situation description and the er diagrams for the two operational databases.

write the three most important questions that management must answer to achieve a competitive advantage in the hotel market. submit the questions and a brief (1-2 pages) explanation/justification of why these are the most important questions. (10 points)

design a data warehouse star or snowflake schema that is sufficient for addressing these questions. submit an er model and the oracle ddl* that implements your data warehouse schema (note: you do not have to implement the schema in a dbms). (15 points)

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 17:40

Gabe wants to move text from one document to another document. he should copy the text, paste the text, and open the new document highlight the text, select the cut command, move to the new document, make sure the cursor is in the correct location, and select the paste command select the save as command, navigate to the new document, and click save highlight the text, open the new document, and press ctrl and v

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:30

Jaina and tomas are being considered as new tenants in an apartment. the landlord looks at their creditworthiness because he wants to be sure his new tenant pays the rent on time and in full. the table below summarizes the information that was on their applications. application information questions jaina tomas how many years have you had your job? 5 2 what is your monthly salary? $1,850 $2,500 how many credit cards do you have? 4 1 how much debt do you have? $13,000 $7,000 how many times were you late with payments on credit cards in the past year? 5 1 who will the landlord decide to be more creditworthy and why? tomas because the ratio of his debt to income is less. jaina because she has had her job longer, which makes her look more stable. jaina because she has more credit cards available to her. tomas because he makes more money per month.

Answers: 2

Answer

Computers and Technology, 24.06.2019 03:30

Auniform resource locator (url) is a formatted string of text that web browsers, email applications, and other software programs use to identify a particular resource on the internet. true false

Answers: 2

Answer

Computers and Technology, 24.06.2019 12:10

What is it called during the editing process when the processor ensures that a character holding a coffee mug from one angle is holding the same mug in the same way when the shot switches to another camera at another angle? cinematography continuity technology prop use

Answers: 1

Answer

You know the right answer?

You work for a large corporation that has just purchased 2 hotel and resort corporations each consis...

Questions