Preview

Data Warehouse and Concepts and Design

Powerful Essays
Open Document
Open Document
3017 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Warehouse and Concepts and Design
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

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Unit 18 M1 Research Paper

    • 268 Words
    • 2 Pages

    Student Name Course Computer Science and IT Unit 18 Database Design Assignment Title Features of a relational databes and Testing Mia’s Sandwich Shop Database Assign 2/2 Complete this section before submitting your work: Student declaration: I certify this is my own work. Any sources I have used to assist me with this assignment are fully referenced. Student evaluation: Develop future SMART Targets.…

    • 268 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    CMGT 400 Week 1 DQs

    • 676 Words
    • 3 Pages

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    MIS 563 COURSE PROJECT

    • 2795 Words
    • 12 Pages

    This finding has ABC University seeking a streamlined way to manage their data and for users to access the data that is clean. With this, the University has proposed the creation and implementation of a data warehouse to house all the data from each one of these operational databases into one central location where all students, staff and faculty can access the data using a self service tool such as a report or a data connection to Microsoft Excel to pull data into pivot tables.…

    • 2795 Words
    • 12 Pages
    Powerful Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Cis 515week 3

    • 1024 Words
    • 4 Pages

    In order to properly indentify the university’s requirements and create an accurate proposal, the first step should be to create and Entity Relationship Model (ERM). The ERM will provide a visual representation of the data structure of the data stores and show the relationships between the data. The following diagram displays the ERM:…

    • 1024 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables, Entity –Relational Diagram (ERD), establish connection to your local MySQL Server, create physical database and insert data to the tables.…

    • 1137 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    System Build Project

    • 391 Words
    • 2 Pages

    For this project, you will design a system for the organization of your choosing. This could be for a current or former employer or some fictitious organization. The system you design might be data storage, telecommunications, e-commerce, accounting information, manufacturing process system, inventory management, or some other system approved by your instructor. You will discover (or create, if you choose a fictional organization) and explain the main systems in place, discuss the integration, and explain how the data collected by these systems helps the organization make decisions and carry out the strategic plan. This project must meet the written communication skills at a Bachelor level competency as described in the Writing Across the Curriculum Initiative.…

    • 391 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    Ross, M. (2009, May 29). The 10 Essential Rules of Dimensional Modeling. Retrieved from http://www.informationweek.com/news/software/bi/showArticle.jhtml?articleID=217700810&pgno=1&queryText=&isPrev=…

    • 1512 Words
    • 7 Pages
    Best Essays
  • Satisfactory Essays

    assign1

    • 309 Words
    • 1 Page

    iVideo, a local video renting shop, is considering creating a database to keep track of…

    • 309 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Database is designed to make transactional systems that run efficiently. Characteristically, this is type of database that is an online transaction processing database. An electronic strength record system is a big example of a submission that runs on an OLTP database. An OLTP database is typically controlled to a single application. The significant fact is that a transactional database does not lend itself to analytics. To effectively achievement analytics, you require a data warehouse. A data warehouse is a database of a diverse kind of an online analytical processing database (In Yang, In Everson & in Yin, 2004). A data warehouse survives as a layer on top of another OLTP databases. The data warehouse obtains the data from all these databases and builds a layer optimized for and dedicated to analytics. A database designed is used to handle transactions designed analytics. It is not structured to do analytics well. A data warehouse is structured to make analytics fast and easy.…

    • 628 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Data Management

    • 2658 Words
    • 11 Pages

    4. Dexter is 45 years old and 181 cm tall. For the last 8 years, his doctor has charted Dexter’s…

    • 2658 Words
    • 11 Pages
    Good Essays
  • Satisfactory Essays

    Digital Forensic Evidence

    • 592 Words
    • 3 Pages

    The future research in this work will involve the implementation of the model in a real world data organization to help to define the functionality of the…

    • 592 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Business Requirment

    • 2599 Words
    • 11 Pages

    4-I Inc. was founded in 2002 by Israel Telleria as an independent security consulting firm in Miami, State of Florida, with a focus on database application security. Since then, we have grown to provide a wide range of offerings, including physical security assessments, security training, auditing and policy review. Operational Systems and Databases, Infrastructure and security We have done a significant amount of work for city, state, local and Federal government agencies throughout the country, in addition to private sector and corporate clients. We believe that our experience and expertise are well aligned with your needs.…

    • 2599 Words
    • 11 Pages
    Powerful Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    Data warehousing and on-line analytical processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Many commercial products and services are now available, and all of the principal database management system vendors now have offerings in these areas. Decision support places some rather different requirements on database technology compared to traditional on-line transaction processing applications. This paper provides an overview of data warehousing and OLAP technologies, with an emphasis on their new requirements. We describe back end tools for extracting, cleaning and loading data into a data warehouse; multidimensional data models typical of OLAP; front end client tools for querying and data analysis; server extensions for efficient query processing; and tools for metadata management and for managing the warehouse.…

    • 2507 Words
    • 11 Pages
    Best Essays
  • Satisfactory Essays

    AACS1733 Information Technology and Systems ASSIGNMENT 2014/2015 Objective This coursework aims to provide students an opportunity to explore the use of Microsoft Excel and PowerPoint so as to enhance their understanding of the application software features in spreadsheet and presentation. Grouping This is a group-based assignment. Student must form a group with 4 members and maximum 5 members (ACCORDING TO ATTENDANCE NAME LIST SEQUENCE). Plagiarism All work is to be the result of the students own individual and group effort. Assignment contents are not allowed to be copied from the Internet or from other students. A student who plagiarizes will receive zero point credit on the assignment. Late Policy The assignment should be submitted on the due date stated below unless there are legitimate reasons as to why a student can not complete the assignment by due date. As a general rule, no extension of time will be granted. Assignment received after the due date without legitimate reason will be penalized. Submission date Week 10s Friday Assignment return week Week 14 Assessment This assignment contributes 40 of the overall course assessment. The marks allocations are divided into 2 sections for a specific group. The first section is students workbook (as required in Section A). The second section is students power point slides (as required in Section B). Each group is 4 members and maximum 5 members according to the attendance name list sequence. Assignment Report Format 5 marks Submission Form (as a cover page), Assessment Form, Plagiarism Statement, Plagiarism Statement Form 2. Acknowledgement 3. Table of contents 4. References 5. Hand-in hardcopy (MS Excel and MS Power Point) in report format and softcopy (MS Excel and MS Power Point) in CD format. Section A Excel Workbook 20 marks Content of the workbook (5 marks) Display appropriate content such as data, charts and images that relevant and useful to the given task. Knowledge skill (10 marks)…

    • 1501 Words
    • 5 Pages
    Satisfactory Essays