subject
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)

ansver
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 23:00, brookerebman15
Which type of tab stop is most for weights and measurements?
Answers: 1
image
Computers and Technology, 23.06.2019 01:20, sosick90501
Write a function balancechemical to balance chemical reactions by solving a linear set of equations. the inputs arguments are: reagents: symbols of reagents in string row array products: symbols of products in string row array elements: elements in the reaction in string row array elcmpreag: elemental composition of reactants in two dimensional numeric array elcmpprdcts: elemental composition of prducts in two dimensional numeric array hint: the first part of the problem is setting up the set of linear equations that should be solve. the second part of the problem is to find the integers from the solution. one way to do this is to mulitiply the rational basis for the nullspace by increasing larger integers until both the left-and right-side integers exist. for example, for the reaction that involves reacting with to produce and : reagents=["ch4", "o2"]; products =["co2", "h2o"]; elements =["c","h", "o"] elcmpreag=[1,4,0;
Answers: 3
image
Computers and Technology, 23.06.2019 11:00, shawn20034
This chapter lists many ways in which becoming computer literate is beneficial. think about what your life will be like once you’re started in your career. what areas of computing will be most important for you to understand? how would an understanding of computer hardware and software you in working from home, working with groups in other countries and contributing your talents.
Answers: 1
image
Computers and Technology, 24.06.2019 17:40, orlandokojoasem1234
Write an assembly language program to input a string from the user. your program should do these two things: 1. count and display the number of words in the user input string. 2. flip the case of each character from upper to lower or lower to upper. for example if the user types in: "hello there. how are you? " your output should be: the number of words in the input string is: 5 the output string is : hello there. how are you?
Answers: 2
You know the right answer?
You work for a large corporation that has just purchased 2 hotel and resort corporations each consis...

Questions in other subjects: