Data Warehouse and Concepts and Design

Topics: Foreign key, SQL, Data modeling Pages: 11 (3017 words) Published: August 12, 2013
CSE4DWD – Data Warehouse Concepts and Design
Assignment, Semester 1 2013
(30% of total assessment)

Dimensional Modelling Business Case Due Date: 9.30am Friday, 17th May 2013 Objectives  To create a Data Warehouse conceptual design using Star Schema Modelling  To document all steps during the design process This is an INDIVIDUAL assignment. You are not permitted to work in a group when writing this assignment. Copying, Plagiarism: Plagiarism is the submission of somebody else’s work in a manner that gives the impression that the work is your own. The Department of Computer Science and Computer Engineering treats plagiarism very seriously. When it is detected, penalties are strictly imposed. Students are referred to the Department of Computer Science and Computer Engineering's Handbook and policy documents with regard to plagiarism and assignment return, and also to the section on ‘Academic Misconduct’ in the unit outline distributed in the first lecture and available on LMS/WebCT. No extensions will be given: Penalties are applied to late assignments (5% of total assignment mark given is deducted per day, accepted up to 5 days after the due date only). If there are circumstances that prevent the assignment being submitted on time, an application for special consideration may be made. See the departmental Student Handbook for details. Note that delays caused by computer downtime cannot be accepted as a valid reason for a late submission without penalty. Students must plan their work to allow for both scheduled and unscheduled downtime. Submission Guidelines:  No hard-copy of the assignment is required. Only electronic copy of your assignment is to be submitted to the LMS at CSE4DWD subject web site.  Do not forget to attach a Statement of Authorship to your assignment, sign and date it.  You can zip all files in one for the submission since the system does not accept multiple files.  Assignment should be typed, not written/drawn by hand. Use the Word Drawing toolbar (or another tool of your choice) to draw figures in your assignment.

1

Entertainment events Data Warehouse
Pure Entertainment is an innovative Event Management & Entertainment Agency that showcases worldclass artists and performers to create exciting entertainment for corporate events and major occasions. Pure Entertainment has a dedicated portfolio of both private and corporate events; it manages all types of entertainment events specialising in entertainment for weddings, major events, festivals, fashion shows, private parties, nightclub appearances, live music, new launch & more. Its services include professional consultation, full event planning, advertising, artist booking, and ticketing services. It offers bespoke events throughout Australia. The company also offers sound and lighting hire. By making optimum use of the client’s budget the company plans the entire extravaganza, enjoyment. Pure Entertainment keeps a list of venues and equipment that may be used/rented for entertainment events. Pure Entertainment Agency has access to international singers, actors, entertainers and celebrities in all categories available to book for corporate, private, and public events/tours. All Pure artists have been hand-selected to provide fresh and unique performances. The company can efficiently provide accurate information with respect to artist pricing and availability. The advertising activity for the events organized by Pure Entertainment: There are different methods or types of advertisements undertaken at Pure Entertainment such as through distribution of flyers or posters an also through other media such as newspapers, television or radio. One of the business questions that Pure Entertainment wants to address is if an advertisement type is more cost effective than another. The tickets for any performance are sold online via the pure website, as well as from promotion outlets, such as retail stores, cafes, restaurants, shops, and boutiques. Each...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Data Warehouse Essay
  • Data Warehouses Essay
  • Data Mining and Data Warehouse Essay
  • Essay about Data Warehousing Logical Design
  • Data Warehouse Testing Essay
  • Databases and Data Warehouses Essay
  • The Data Warehouse Lifecycle Toolkit Essay
  • Essay about Data Warehouses & Data Mining

Become a StudyMode Member

Sign Up - It's Free
HidupMusik | 天國的階梯 | Download