Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Aims:

a) To make a Data Warehouse conceptual design by using Star Schema Modeling.

b) To document all steps throughout the design process.

Submission Guidelines:

a) No hard-copy of the assignment is needed. Only electronic copy of your assignment is to be submitted to the LMS at CSE4DWD subject website.

b) Don’t forget to join a Statement of Authorship to your assignment, sign and date it.

c) You can zip all the files in one for the submission as the system doesn’t accept multiple files.

d) Assignment must be typed, not written or drawn by hand. Utilize the Word Drawing toolbar (or other tool of your preference) to draw figures in your assignment.

problem: Your task is to design a data warehouse for Pure Entertainment by using Star Schema Modeling.

Your design requires encompassing the given steps:

i) First construct a Data Warehouse Bus Matrix to identify the company's business processes and any likely Data Marts.

ii) Design the star schema for any Data Marts you have identified, ensuring your Dimensions are conformed, primary and foreign keys are clearly labeled, and that your attributes are named using verbose textual descriptions.

iii) Create the table with a row for each fact table in your design, indicating the granularity of each fact and a brief justification for selecting that granularity.

iv) Create the table with a row for each dimension table in your design, giving a brief justification for selecting that dimension, and indicating any attribute hierarchies which exist within the dimension.

v) Create the table with a row for each design feature you have used, such as handling of possible null foreign keys, and the inclusion of any fact-less fact tables, degenerate dimensions, role playing dimensions, junk dimensions, outriggers, mini-dimensions, or any other design techniques discussed in the lectures. Provide a brief description of each design feature used (how and where it is used – not the theory behind the concept) and a justification for its use.

vi) Identify which fields from your facts/dimensions are required to answer each of the business problems listed below.

•    Which ticket promotion outlets sell the most tickets? Does this vary across different months or event types?
•    What ticket batch sizes minimize the likelihood of outlets having unsold tickets whilst maximizing profit?
•    For which clients have we provided the most event tickets? How much do we make a year out of our top 5 clients?
•    How much commission did we pay to promoters in the last financial year? How does this compare to the past 5 years?
•    From which online customer locations do the more expensive event tickets (ex: premium and gold) sell?

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9159
  • Price:- $65

Priced at Now at $65, Verified Solution

  • AsyU replied

    First i want to say thanks to mywordsolution for providing excellent service. You guys are really awesome great work, your solution really help me alot.

Have any Question? 


Related Questions in DBMS

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Consider a typical sales invoice that would include the

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to re ...

Career opportunities in your majorknowledge workers

CAREER OPPORTUNITIES IN YOUR MAJOR Knowledge workers throughout the business world are building their own desktop databases (often called end-user databases or knowledge worker databases). To do so, they must understand ...

Apriori analysis and cluster analysis-data analysis

ApriorI analysis and Cluster analysis-Data Analysis assignment CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" se ...

Assignment - data mining and machine learning in the real

Assignment - Data Mining and Machine Learning in the Real World OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining. Your answers to the questions in the cells right ...

Select one of the four primary categories of terrorist

Select one of the four primary categories of terrorist hazards (Chemical, Biological, Radiological/Nuclear, Explosives). Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dis ...

Query 1list all movies played in landmark or music box

Query 1 List all movies played in Landmark or Music Box. Output only titles and eliminate duplicates. Query 2 List all stars born after 1960. Order them by their birthdate in ascending order. Output their first names, la ...

How up-to-date should data warehouse information

HOW UP-TO-DATE SHOULD DATA WAREHOUSE INFORMATION BE? Information timeliness is a must in a data warehouse-old and obsolete information leads to poor decision making. Below is a list of decision-making processes that peop ...

Discussionatleast 1 paragraph for each partpart 1 remote

Discussion Atleast 1 paragraph for each part Part 1: "Remote Access" Please respond to the following: • Remote access to corporate resources is becoming commonplace. From an auditing perspective, suggest two or more cont ...

Data warehouses and data martswrite a one- to two-page

Data Warehouses and Data Marts Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts t ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro