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

  Produce an entity-relationship diagram

Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropriate attributes for each entity shown, and identify the primary key for eac..

  Draw dependency diagram after identifying all dependencies

Draw the dependency diagram after identifying all dependencies in this data structure. See Lecture 6, Slide 27 for dependency diagram and convert this data structure to a set of 3NF relations. Clearly showing each step

  Create an entity-relationship diagram and design

create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices

  Design an entity-relationship model of the problem

Design an entity-relationship model of the problem, convert the model into a relational model, and assess the normal form of each schema.

  Use sql to create database

Use SQL to create the following database; to including referential integrity. You may NOT use the GUI for this part of the exercise. COURSE ( CourseNu, CourseName, CreditHrs).

  Clustered versus unclustered indexes

Choice of search key for the index. What is a composite search key, and what considerations are made in choosing composite search keys? What are index-only plans, and what is the in?uence of potential index-only evaluation plans on the choice of sear..

  What difficulties did you encountered and how did you

write a 200- to 300-word short-answer response for the followingwhat difficulties did you encountered and how did you

  Sketch dfsa for identifiers-contain only letters and digits

Sketch a DFSA for identifiers which contain only letters and digits, where identifier should have at least one letter, but it need not be first character.

  Create a database using oracle packaged procedure

Create a database using Oracle packaged procedure

  Use data mining technique

The software MUST use DATA MINING TECHNIQUES (at least one like classification or association rule mining etc). The work involves analysing loads of the Hospitals data to search for the desired patterns.

  Draw a context diagram and a level-0 dfd

develop the report having each task clearly numbered togetherwith your answer. You are also expected to write an introduction and conclusion for this report.In performing the following tasks, you have to strictly follow all diagramming rules used ..

  Make the flowchart of the above business processes

create the flowchart of the above business processes. The assignment will be completed in 2 parts:1. AS-IS Model2.TO-BE Model once feedback is given from Professor after completing Part 1 (AS-IS Model)

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