Ask Question, Ask an Expert

+61-413 786 465

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

Assignmenta restaurant is designing a database to keep

Assignment A restaurant is designing a database to keep track of customer services. A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees. Each employee is define ...

Question a suppose you are a marathon runner that can run a

Question : a) Suppose you are a marathon runner that can run a maximum of n miles on a single bottle of water. You are given a map of your marathon route with all the water stations marked. Design an efficient algorithm ...

You can work on this assignment individually or in a group

You can work on this assignment individually or in a group of 2. If you are working in a group please establish a group in Assignment 2 Group on Canvas In this assignment you are asked to explore the use of neural networ ...

Suppose that you have designed a database for morgan

Suppose that you have designed a database for Morgan Importing that has the following tables: EMPLOYEE (EmployeeID, LastName, FirstName, Department, Phone, Fax, EmailAddress) STORE (StoreName, City, Country, Phone, Fax, ...

Systems analysis project scenic routes operates a bus

Systems analysis project Scenic Routes operates a bus company that specializes in travelling on secondary roads, rather than Interstate highways. Their slogan is: "It Takes a Little Longer, But It's Scenic." The firm nee ...

Select from e d pwhere edeptddept and dcitypcity and

Select * From E, D, P WHERE E.dept=D.dept AND D.city=P.city AND D.budget>1M AND P.priority=A; Assuming relations have the same size and uniform distributions, what is the best plan with Nested Loop joins only? Write it a ...

Quesiton 1 what is data-manipulation language dml there are

Quesiton: 1. What is Data-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last ...

Questionsuppose a prolog database exists that gives

Question: Suppose a Prolog database exists that gives information about states and capital cities. Some cities are big, others small. Some states are eastern, others are western. a. Write a query to find all the small ca ...

In sql developer onlydeliverables include sql scripts and

In SQL Developer ONLY! Deliverables Include SQL scripts and screenshot of the results: D1. Create the following three user-defined roles that are shown in the table below and assign them the specified permissions for the ...

In sql developercreate a table userpermissions provide

IN SQL DEVELOPER Create a table UserPermissions (provide create and insert statements code) Document UserName Policy SYSTEM Menu JDOW W2 USAM Permissions SYSTEM W2 JDOW Form 1040 USAM Policy JDOW W2 SYSTEM Write a PL/SQL ...

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As