Reference no: EM131142057
Database and Data Warehousing Design
One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company's ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.
Design Document
Write a four to six (4-6) page design document in which you:
Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.
Create a schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure.Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain your rationale behind the design of your E-R Diagram.
Create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram must map data between source systems, data warehouses and specified data marts. The diagram should map data between source systems, data warehouses, and specified data marts. Note: The graphically depicted solution is not included in the required page length.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.
Draw demand and supply curves for skilled worker
: Draw demand and supply curves for skilled and unskilled workers, marking the initial equilibrium in each market.
|
Provide a brief reviewof the national response framework
: Provide a brief reviewof the National Response Framework (NRF), National Incident Management System (NIMS), and at least one other national-level strategy (of which there are dozens to choose).
|
Do you agree with how your classmates used the vocabulary
: Do you agree with how your classmates used the vocabulary? Did the student handle the negatives in the formulas accurately? Did you notice anything interesting about the results of No Image and No Image?
|
What would be the effect on inflation
: If cyclical unemployment increases, what would you expect to happen to inflation? If cyclical unemployment falls, what would be the effect on inflation?
|
Explain your rationale behind the design of your e-r diagram
: Create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required p..
|
What gives rise to cyclical unemployment
: If the labor market always clears, is there any unemployment? Any cyclical unemployment? What does it mean for the labor market "not to clear"?
|
Determine the percentage increase due to skin effect
: Assuming an increase in resistance of 2% for spiraling, calculate and verify the dc resistance - Then calculate the dc resistance at 50°C, and determine the percentage increase due to skin effect.
|
How much will the money supply increase
: Suppose Bob decides to keep $5,000 of his find as cash and deposits only $95,000 in his bank. By how much will the money supply increase?
|
What are the possible causes for the existence of the issue
: Include information about the organization and the issue you have identified or for which you were consulted. Number of Employees: Identify the number of employees to be trained and their current skill levels. Locations of Employees: Identify where t..
|