Role of metadata in data acquisition process

Assignment Help Database Management System
Reference no: EM13319288

Explaining the role of metadata in data acquisition process

Question 1) You are a vice president of marketing for a nation-wide appliance manufacturer with three production plants. Explain different ways you would tend to analyze your sales. What are the business dimensions for your analysis?

Question 2) You are a manager for data warehouse project at the retail chain with stores all across the country and users in every store. How would you ensure that all the details essential to decide on DBMS are gathered during the requirements phase? Write a memo to the Senior Analyst directly responsible to coordinate the requirements definition phase.

Question 3) You have recently been promoted to administrator for the data warehouse of a nationwide automobile insurance company. You are asked to prepare a checklist for selecting a proper vendor tool to help you with the data warehouse administration. Make the list of the functions in the management and control component of your data warehouse architecture. Use this list to derive tool-selection checklist.

Question 4) As a data acquisition specialist, what types of metadata can help you? Select one of the data acquisition processes and explain the role of metadata in that process.

Question 5) What is a factless fact table? Design a simple STAR schema with a factless fact table to track patients in a hospital by diagnostic procedures and time.

Reference no: EM13319288

Questions Cloud

A decline in the price of imported oil : Draw the short-run tradeoff between inflation and unemployment. How might the Fed move the economy from one point on this curve to another?
Find the velocity of the water coming out of the hole : You have a cylindrical cup of water that springs a leak 5 cm below the surface of the water. What is the velocity of the water coming out of the hole
Explain why aggregate demand might increase by more than : The government spends $3 billion to buy police cars. Explain why aggregate demand might increase by more than $3 billion. Explain why aggregate demand might increase by less than $3 billion.
What is the difference between these wavelengths : Visible light passes through a diffraction grating that has 900 slits per centimeter, and the interference pattern is observed on a screen that is 2.46m from the grating. What is the difference between these wavelengths
Role of metadata in data acquisition process : You are a vice president of marketing for a nation-wide appliance manufacturer with three production plants. Explain different ways you would tend to analyze your sales. What are the business dimensions for your analysis?
Determine density of rock : Solid rock suspended in air by spring scale has m=2.50 kg, When rock submerged in water, mass = 1.90 kg, determine Density of rock,
Calculate the exchange rate between canada and japan : The business section of most major newspapers contains a table showing U.S. exchange rates. Find such a table and use it to answer the following questions. a. Does this table show nominal or real exchange rates? Explain. b. What are the exchange rate..
Find the ultimate moment capacity according to aci : Given a reinforced concrete beam made with 3000psi concrete and grade 40 steel. The effective width is 12 inches, the beam depth is 24 inches and the reinforcement is 4#7 bars centered 2-1/2 inches
What matters more to bob and rita—the overall inflation : Let’s consider the effects of inflation in an economy composed only of two people: Bob, a bean farmer, and Rita, a rice farmer. Bob and Rita both always consume equal amounts of rice and beans. In 2000, the price of beans was $1, and the price of ric..

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd