country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

IMAT5167 Data Warehouse Design And OLAP

tag 0 Download9 Pages / 2,041 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: IMAT 5167
  • University: De Montfort University
  • Country: United Kingdom

Question:

Scenario: Midlands Theatre (MT) Company

Company Overview:

Midlands Theatre (MT) is a chain of small theatres that are found within the suburbs of several cities and towns within the Midlands, including Leicester and Birmingham. It specialises in high quality theatre productions that may be seen to be insufficiently “mainstream” for the general population. The company purchased its first theatre in January 1982, and since then has seen substantial increases in the number of clients that want to visit a local theatre to see a production that is more alternative to those typically found within the city centre theatres and/or large entertainment complexes. In response to the growing client base, MT sometimes offers a matinee (i.e., afternoon) performance of a popular production in addition to the traditional evening performance time.

Alongside the increase in number of theatre goers comes the issue of managing the additional bookings and ticketing requirements. The Managing Director of MT, Ms. Heritage, has decided that a computerised booking system for MT is needed. Although the ultimate aim is to enable the on-line booking of tickets for any MT productions at any MT theatres, Ms. Heritage would like a simple booking system to be created first. This first version booking system will automate the existing manual booking processes, which are detailed below.

Information regarding current booking processes at Midlands Theatre (MT):

Each of the theatres in MT’s portfolio has a schedule of productions for a given month in a particular calendar year. For instance, a schedule for a production entitled “Wind Blows”, which ran for one week at the Cropston Theatre during March 2018, is provided in Table 1.

Table 1.  Example of one week performance at the Cropston Theatre

Name of Production

Day and Date

Afternoon

Evening

“Wind Blows”

Scriptwriters: William

Director: Henry

Monday 7/3/2018

No performance

7.30pm

 

Tuesday 8/3/2018

No performance

7.30pm

 

Wednesday 9/3/2018

2.30pm

7.30pm

 

Thursday 10/3/2018

No performance

7.30pm

 

Friday 11/3/2018

2.30pm

7.30pm

 

Saturday 12/3/2018

2.30pm

7.30pm

 

Sunday 13/3/2018

2pm – note earlier start

6.45pm – note earlier start

 

Only one production is shown at a theatre at a time, and some of the more popular productions run both afternoon (matinee) and evening performances.

Productions could be at a theatre for several weeks, although the majority of productions run only for a few days over one week. The run of the next production cannot start until the previous production has ended (in other words there is no interleaving of the performance runs of different productions).  It is common for the same production to have runs in all of MT’s theatres - one theatre after another - so that the widest number of potential clients for a production is reached.

When a potential theatre goer wants to purchase a ticket for a particular performance of a production at a MT theatre in advance, s/he contacts the central booking service via the website, telephone or an App. Whenever a ticket is purchased, a unique purchase number is allocated, the performance to be attended, the theatre, the client details (such as name, postcode and house number, and telephone), the total amount paid and the method of payment (cash, Paypal, debit card or credit card) and the method of ticket delivery (either by mail/email or by client pick up from the local theatre box office) are recorded. If several tickets are bought at the same time by the same person, each ticket is recorded as if it were bought separately.  

Table 2. Further Information about each Entity (Type) on the EER Diagram

Entity Type

Entity Instance

Theatre

A particular MT theatre e.g., Cropston

Production

A particular production e.g., How the Wind Blows

Performance

A particular performance of a production run, e.g., a performance of Wind Blows at Cropston Theatre on Monday 7/3/18 at 7.30pm

Client

A particular client of a theatre e.g., Mr Eric Charles

TicketPurchase

A particular ticket bought for a particular performance e.g., Ticket Purchase No. 29, which is for Cropston Theatre for the 9/3/18 performance  at 7.30pm of  Wind Blows and is bought by Ms Helen w2544.

Any remaining tickets for a performance are available to buy on the day from the local theatre box office. The same details are recorded, although clearly in this case the ticket will always be collected from the local theatre box office!

A relational database has been created according to the ERD.  The tables

are as follows:

  • Theatre(Theatre#, Name, Address, MainTel);
  • Production(P#, Title, ProductionDirector, PlayAuthor);
  • Performance(Per#, P#, Theatre#, pDate, pHour, pMinute, Comments);
  • Client(Client#, title, name, address, telNo, e-mail);
  • TicketPurchase(Purchase#, Client#, Per#, PaymentMethod, DeliveryMethod, TotalAmount).

Having established the online transaction processing database, Ms. Heritage wants more intelligence information from the available data and she is looking for a potential data warehouse for MT.  As the first step in this process, she expects to setup a data mart for ticket sales as the first step.  The data mart should satisfy the following analysis requirements:

  • Yearly total sale for each theatre.
  • All clients who visited MT theatres in at least 4 different months in a year.
  • List the titles, production directors and play authors of all products with the highest total sale.

Here, by ticket sale value, we refer to the value of money rather than number of tickets.  For this data mart, only the data involved in ticket sales are stored, and any data not involved in at least one ticket sale should not be included.

You can access the OLTP database in my database schema: ops$yyang00.  For example, you can access the data for Theatres using the following SQL statement:

select * from ops$yyang00.theatre;

Your Tasks

You are to develop a prototype of ORACLE data mart for ticket sales as a part of a potential data warehouse for MT.  For this assignment you are required to work individually.

You have been given the MT company scenario, together with an Extended Entity Relationship (EER) Diagram and corresponding tables for the existing relational database. 

Task 1: Analyse the given database design and the requirement for data mart, identify the dimensions and fact for your data mart  

Task 2: Design the star schema for the data mart and identify the corresponding PKs and FKs  

Task 3: According to given data and requirements, determine the relevant attributes and suitable granularity in your data mart  

Task 4: Map your star schema to logical relations  

Task 5: Create the corresponding tables in Oracle using SQL

Task 6: Identify your source data from the OLTP database and design your data extraction rules.  You need to give a detailed mapping and transformation list from the source to the destination.

Task 7: Implement your data extraction, transformation and loading through Oracle SQL.  The number of rows extracted into each dimension or fact table in your data mart should be printed from Oracle query.

Task 8: Comment on how your data mart satisfies the requirements of MT.  Implement the required data analysis requirements for both data mart and the original OLTP database.  Compare your queries and comments on the advantages of data mart in analysis operations. Test results from Oracle query should be included.

Evidence of the successful execution of your queries is required.  For large outputs, you need to provide only the last page of outputs with the number of rows in the end.

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 9 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). IMAT5167 Data Warehouse Design And OLAP. Retrieved from https://myassignmenthelp.com/free-samples/imat5167-data-warehouse-design-and-olap.

"IMAT5167 Data Warehouse Design And OLAP." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/imat5167-data-warehouse-design-and-olap.

My Assignment Help (2020) IMAT5167 Data Warehouse Design And OLAP [Online]. Available from: https://myassignmenthelp.com/free-samples/imat5167-data-warehouse-design-and-olap
[Accessed 25 November 2020].

My Assignment Help. 'IMAT5167 Data Warehouse Design And OLAP' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/imat5167-data-warehouse-design-and-olap> accessed 25 November 2020.

My Assignment Help. IMAT5167 Data Warehouse Design And OLAP [Internet]. My Assignment Help. 2020 [cited 25 November 2020]. Available from: https://myassignmenthelp.com/free-samples/imat5167-data-warehouse-design-and-olap.


Students are often on the lookout for a top-notch academic website that can relieve them of their academic concerns. We, at MyAssignmenthelp.com, have got everything covered for you. After completing an assignment successfully, students often search for reliable reword tools, online word count tools, etc. The inability to find a reliable one can lead them to be accused of the severe crime of plagiarism. Our word count tools, paraphrase tools, etc., helps you scan your document thoroughly, and get the desired results. Our essay editors also manually revise each content, check the word count, and edit all the glaring errors to maintain the flawlessness of your assignment remarkably. Get in touch with us today!

Latest It Write Up Samples

BCO6653 Management Of Information Technology

Download : 0 | Pages : 5
  • Course Code: BCO6653
  • University: Victoria University
  • Country: Australia

Answer: Introduction For all types of businesses, integration of IT (Information Technology) has brought a drastic positive change. This is true only if appropriate technology is used. IT has the capacity of changing the business operations’ scope and working, with positive impact on its market competency. There is no denial that the IT innovations have let the businesses to succeed as well as fail. The failure is ...

Read More arrow

COMP5349 Cloud Computing

Download : 0 | Pages : 7
  • Course Code: COMP5349
  • University: The University Of Sydney
  • Country: Australia

Answer: Introduction Regional Gardens runs a number of gardening enterprises and it is also open for public inspection. The management of the organization has decided to move to a hybrid cloud environment in order to integrate the business operations of the organization. The report gives an idea of the process of implementation of cloud within Regional Gardens. The risks and the security issues associated with the use of hybrid cloud are eval...

Read More arrow

ZLX05 HND In Computing

Download : 0 | Pages : 34
  • Course Code: ZLX05
  • University: ICON College Of Technology And Management
  • Country: United Kingdom

Answer: Object Oriented Programming (OOP) Principles: Classes: A Class describes the characteristics of some real objects/events that occurs in the real word. The class specifies the characteristics of class as the properties and behavior and operations on those attributes as the methods. Example: Person is a class Objects: Objects are instance of classes. Example: John is a person Data Abstraction: Data abstraction is used to hide compl...

Read More arrow

COM3023-N ICT Service Management

Download : 0 | Pages : 15
  • Course Code: COM3023-N
  • University: Teesside University
  • Country: United Kingdom

Answer: Purpose And History The Aperture Science has been a famous research company that is expanding their business in three sectors of the business including robotics, Pudding, and Textile research. The purpose of the ITIL document is to highlight the aspects necessary for the consideration for the deployment of an iOS  application the daily operational problems of the common individuals. The technology will be introduced to the indivi...

Read More arrow

COIT20260 Cloud Computing For Smart Applications

Download : 0 | Pages : 5
  • Course Code: COIT20260
  • University: Central Queensland University
  • Country: Australia

Answer: Introduction The report talks about a business case study, of a company called AB Pty. Ltd. It manages a product delivery business for the area Austin downtown, Texas, USA. This company looks like a small scale business as it contains only three trucks for making the delivery of the products. The products are delivered to the customers of the specified zone. The company is facing a problem in the delivery service which is supposed to ...

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,500,131

Orders

4.9/5

Overall Rating

5,101

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

755 Order Completed

95% Response Time

Douglas Cowley

Masters in Finance with Specialization in Audit

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2115 Order Completed

97% Response Time

Kimberley Chen

MPA in Accounting

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2109 Order Completed

99% Response Time

Emma Zhong

Ph.D in Project Management with Specialization in Project Communications Management

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

440 Order Completed

99% Response Time

Jack Arens

MBA in HRM

London, United Kingdom

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Good evening Thank you very much for your GREAT WORK I really appreciate your effort I like it

flag

User Id: 394056 - 25 Nov 2020

Australia

student rating student rating student rating student rating student rating

Can i come back and share my grade as i\'m about to submit but im very pleased with your work thank you very much

flag

User Id: 552971 - 25 Nov 2020

Australia

student rating student rating student rating student rating student rating

it was really helpful. i got my asssignment on time even before the deadline.it was written really well i am glad that I came to Myassignmenthelp.

flag

User Id: 401534 - 24 Nov 2020

Australia

student rating student rating student rating student rating student rating

very professional i got it before the due time i set, the sheet that was sent to me was very neat and very well done.

flag

User Id: 551988 - 23 Nov 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?