Solution-List the all facts and dimensions of the enterprise

List the all facts and dimensions of the enterprise

Assignment Help Database Management System

Reference no: EM13326633

You are required to design a data warehouse schema for recording the history of rental services of XYZ's customers (not including the customers who have ordered or picked up cars but have not returned their rental cars). The schema needs including the necessary data about the demonstration. The fact table should contain four kinds of data dimensions:

customer information, car information, store information and time. For each data dimension, you need to consider a reasonable hierarchy (e.g., time dimension - Year, Month, Week, Day; Geography - Country, State (Province), City, St.). More specifically, you need to answer the following four questions:

(1) Proceed to a source analysis: list the all facts and dimensions of the enterprise
(2) Provide a data profile to describe the source data (read "carRentalDataSource.xlsx" to answer this question)
(3) Choose a model (star, snowflake or constellation) and discuss why it is an appropriate choice
(4) Draw a diagram to show your proposed data warehouse schema

Reference no: EM13326633

Questions Cloud

Confirm your status as a gendered person : Describe your own experience of becoming consciously aware that you "have" a gender, male and discuss the role this awareness may have played in your overall growth and development as a person (Male).

Create a database : Create a database that implements the proposed data warehouse schema.

What was the magnitude of the force propelling him : The Zacchini family was renowned for their humancannonball act in which a family member was shot from a cannon using either elastic bands or compressed air. what was the magnitude of the force propelling him

What is convergence theory : What is convergence theory? and do you think convergence theory describes the society in which you live? From an explicit analytical perspective that you can identify and apply, what are the major social benefits and drawbacks associated with capital..

List the all facts and dimensions of the enterprise : Choose a model (star, snowflake or constellation) and discuss why it is an appropriate choice.

Determine the coefficient of linear expansion : When the temperature of a coin is raised by 71.8 C°, the coin's diameter increases by 2.11 x 10-5 m. find the coefficient of linear expansion

How the approach proposed in the paper is different : Summarise the differences between the ETL process in the paper and that in the scenario.

Urban area in a semi-arid region reduce its water use : Briefly described with reference that how might an urban area in a semi-arid region reduce its water use?

Analysis reveals about biovails strategic weaknesses : Establishing a worst-case scenario, discuss the known liability that Biovail has incurred for deceiving its investors. Perform a comparative financial analysis of Biovail, Abbot Labs, and Cephalon. Describe what this analysis reveals about Biovail's ..

User Account

All Pages

List the all facts and dimensions of the enterprise

Reference no: EM13326633

Reference no: EM13326633

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT