What type of entertainment events are the most popular

Assignment Help Database Management System
Reference no: EM13718680

- To create a Data Warehouse conceptual design using Star Schema Modelling

- To document allsteps during the design process

1. What type of entertainment events are the most popular? Has this always been the case or has there been a shift in recent years?

2. Are there certain times of the year when more events are held? Are certain types of events more common at particular times of the year? Do we have more event organizations during school holidays comparing with normal school days?

3. How much the consultation income has been received for organizing the event in past 5 years?  What is the average time spent for consultations on each event?

4. Which area of venues used for organizing events is most popular in past 10 years?

5. Whichage group of children is most likely hire toys across nation? Does thisvary across different location or times of the year?

6. Which category of toys is most popular across nation, what is the total sales in past 5 years?

7. Does the promotion activity provide the benefits to the company? The promotion period in Christmas month has increased the sales comparing with the same period in last year?  Any toys have not been rented out during the promotion period?

8. Who are the most loyal clients (top 5) to our business? What is the main location of those people (clients) purchasing event/party organization?

9. Do customers/clientsprefer to go online rent or see local officers? 

10.  Do VIP members bring more business to our company?

How much penalty income in past 5 years for late return of the toys? What percentage of toys is damaged during the hires in past 5 years?

Your task is to design a data warehouse for Toys Hire & Children's Partyusing multidimensional Modelling. Your design needs to encompass the following steps:

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

(ii) Designthe star schema for any Data Marts you have identified, ensuring your Dimensions are conformed, primary and foreign keys are clearly labelled, and that yourattributes are named using verbose textual descriptions.

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

Fact table name

Fact granularity

Fact table type

Brief justification

 

 

 

 

(iv) Create the following table with a row for each dimension table in your design, giving a brief justification for choosing that dimension, and indicating any attribute hierarchies that exist within the dimension. (12 marks).

Dimension table name

Brief justification

Attribute hierarchies

 

 

 

(v) Create the following table with a row for each design featureyou 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.

Design feature

Brief description

Brief justification

 

 

 

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

Reference no: EM13718680

Questions Cloud

How many gold atoms would lie on a line : In a crystal of gold, centers of individual atoms are approximately 0.288 nm apart. How many gold atoms would lie on a 3.73 inch line?
Define a cube of aluminum metal has a mass : A cube of aluminum metal has a mass of 55.6 at 25 degrees Celsius. If the density of aluminum is 2.79 g/cm^3, what is the length of the side in inches?
An american petroleum engineer : Question 2. 2. (TCO I) An American Petroleum Engineer, who has been on an Offshore Nigerian Oil Platform for 30 days, enters Lagos harbor in a work boat with 15 Nigerian oil rig workers. The work boat is stopped by the Lagos Harbor Police. The..
Discussion with the bartender : Drummond, a customer in a bar, gets into a heated discussion with the bartender (Bob) over politics. Bob gets very angry and throws a glass of scotch at Drummond, splashing him in the face with the alcohol.The alcoholcauses severe burning ofDr..
What type of entertainment events are the most popular : What type of entertainment events are the most popular? Has this always been the case or has there been a shift in recent years - Which area of venues used for organizing events is most popular in past 10 years?
How many rhodium atoms could you buy for exactly one nickel : Rhodium, a metal used as a catalyst and in jewelry, currently sells for $1500. per troy ounce. If 6.022 x 10^23 rhodium atoms have a mass of 102.9 grams, how many rhodium atoms could you buy for exactly one nickel
Determine the mean and confidence interval : You obtain the following six measurements for the mass of water delivered by a special calibrated volumetric pipette: 1.180 g, 1.185 g, 1.181 g, 1.173 g, 1.182 g, and 1.181 g. determine the mean and confidence interval of these measurements at a c..
Explain how many inches of snow can be on the roof : If the weight limit for a roof is 55 lbs/ft^2, how many inches of snow can be on the roof before it must be removed? Again assume that 10 inches of snow is equivalent to 1 inch of liquid water if melted. Liquid water is 62.4 pounds/cu-foot (lbs/ft..
Explain the same average kinetic energy as the atoms : Consider a 1.0-L sample of helium gas and a 1.0-L sample of argon gas, both at room temperature and atmospheric pressure. Answer the following questions:

Reviews

Write a Review

 

Database Management System Questions & Answers

  Identify super key of r based on functional dependencies

Identify the Functional Dependencies in R. Be sure to maximize the number of attributes on the right hand side (RHS) and minimize the number of attributes on the left hand side (LHS) of each FD. You should exclude any trivial FDs in your answer.

  Database implementation and queries please tell me howmuch

please tell me howmuch it costs and please give me some discount as this is the second time i am

  Write functional dependencies in table concerns invoicing

Write the functional dependencies in the following table that concerns invoicing (an application Premiere Products in considering adding to its database), subject to the specified conditions.

  Construct an entity-relationship model for the database

Construct an entity-relationship (ER) model for the database. Make sure you include in your model details of entities, relationships, attributes, keys and limits in participation.

  Create a data warehouse conceptual design

Create a Data Warehouse conceptual design using Star Schema Modelling and document all steps during the design process

  Question 1 consider the relational schemapartpart-id name

question 1. consider the relational schemapartpart-id name costsubpartpart-id subpart-id counta tuple p1 p2 3 in the

  Identify each relationship type and write all of the busines

Identify each relationship type and write all of the business rules and create the bask Crow's Foot ERD for DealCo.

  Create an er diagram using the set of requirements

Create an ER diagram using the set of requirements provided for Oxford City Council's bicycle sharing scheme and identify the minimal set of functional dependencies and all candidate keys for the relation R

  Develop an entity-relationship diagram as a conceptual mode

For the following requirements analysis description, develop an Entity-Relationship Diagram as a conceptual model that captures all of the requirements to the fullest extent possible.

  Use technology and information resources to research issues

Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

  The task in this project is to design a normalized database

the task in this project is to design a normalized database that could be used to collect and store information for a

  How virtual applications and desktops or both will delivered

Regional Gardens Ltd is a company that runs number related gardening enterprises. It has a large display garden that it opens for public inspection a number of times in a year.

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