Preview

Athabasca Assignment

Good Essays
Open Document
Open Document
837 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Athabasca Assignment
Assignment 1: Using a Database for Strategic Business Development
Assignment 1 is worth 5 percent of your final grade for this course. Answer all questions in the Hands-on MIS project “Improving Decision Making: Using a Database to Clarify Business Strategy” on pages 92–93 of the textbook. Read the assignment instructions in the textbook carefully and follow all instructions.
Background:
Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.

For this assignment, you will be analyzing the data in a simple, one-table database by creating queries and reports in Microsoft Access. The system you are “developing” will be used by The Queen’s Inn in St. John’s, Newfoundland for strategic business development purposes.

Remember that Access, Excel, and even FrontPage, are all tools. This assignment will help you discover how to use a database tool to support a business. You will be analyzing the data in the database and answering the questions in the exercise to create the queries and reports that are necessary to determine what the Inn’s current business situation is.
Instructions:
* If you have not yet set up your access to MyMISLab, go to the Learning Materials page for the proper steps and codes. It is vital that you set up MyMISLab correctly to ensure you have access to the resources for CMIS 351. * Go to MyMISLab and download the Exercise Data File: MIS11ch03 for this assignment from the Assignment 1 folder (after logging in, click Course Content, choose View All Content, then scroll

You May Also Find These Documents Helpful

  • Good Essays

    References: Cohen, B. (2004). Database Basics Part 2: Spreadsheets and Databases. Small Business Computing. Retrieved from…

    • 817 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Databases Databases play a role for the implementation of industry specific software for users and customers of Kudler Fine Foods. The use cases provided information on how data is readily available for use in reporting or forecasting future business. A relational database would be beneficial to the organization as it “…is usually designed with a number of related tables” (Rainer & Turban, 2008, p. 111). The tables are set up to give the user information on relational data from several accounting departments within the…

    • 757 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    I. Analyze the Database Environment II. Describe the Problems and Constraints III. Describe the Objectives of the Database Environment…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Cis515

    • 3200 Words
    • 13 Pages

    References: Carter, J. (n.d.). Database Design and Programming with Access, SQL, Visual Basic and ASP.…

    • 3200 Words
    • 13 Pages
    Powerful Essays
  • Good Essays

    Kudler’s Data Table Analysis ACC/542 September 27, 2010 Abstract Kudler Fine Foods is a fast growing company established in 1998 and their Initial store selected Microsoft Access as the database to track inventory, sales, orders, employees, and customers. Kudler’s products are perishable and inventory must be properly tracked. This paper will evaluate database tables from accounting perspective, and provide recommendations for improvement. Pivot Table and Entity Relationship diagram will help Kudler’s to build better decision-making process.…

    • 565 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Driver

    • 3248 Words
    • 13 Pages

    ONLINE DRIVING SCHOOL SAHASUHANA BT SHAHADAN This report is submitted in partial fulfillment of the requirements for the Bachelor of Computer Science (Database Management)…

    • 3248 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    Testing

    • 349 Words
    • 2 Pages

    Premium2258 Words10 Pages Bis245 Ilab A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the r…

    • 349 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Efficiency and Collaboration Proposal Team C BIS/220 July 14, 2014 Introduction Team “C” would like to propose a convenient and efficient system that will allow the company to function in a more proficient manner. The purpose of this proposal is to introduce a relational database system that will improve the company’s productivity by updating our current information system. Team C will demonstrate this by explaining the usefulness of converting data currently in Microsoft Excel spreadsheets into a rational database using Microsoft Access. Describe the benefits of using Microsoft Access in our organization and will include suggestions for the future use of collaborative software, showing how it can improve the communication of the sales department while also streamlining the work process.…

    • 828 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    ba125

    • 381 Words
    • 2 Pages

    Ethics, Privacy and Security Chapter 9 Emerging Trends and Technologies TBA Part III: Reference: Shelly, Cashman, and Vermaat,(2010). Database Management Essential Concepts and Techniques in Microsoft Access 2007, Philippine edition.…

    • 381 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Assignment01

    • 591 Words
    • 2 Pages

    2. View the video tour of Hard Rock Cafe that addresses this issue. http://media.pearsoncmg.com/ph/bp/bp_heizer_opsmgmt_8/chapter_content/video_clips/vidclips0 1_01.html…

    • 591 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Prepare a financial accounting spreadsheet with appropriate formulas, functions, formatting and charts. To create tables in a database, forms to enter data into the tables and a variety of queries to be performed based on the table.…

    • 2860 Words
    • 11 Pages
    Powerful Essays
  • Powerful Essays

    MILESTONE 2 Final

    • 2216 Words
    • 8 Pages

    Preliminary Q&A These questions will help us understand what type of a database that you are looking for. We will also use these questions as input data, to enrich the customer experience.…

    • 2216 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    The Company is seeking to have a database that will accommodate and sustain its business operations as it continues with the expansion plan. The existing database system is restricted in the functionalities linked to business reporting and intelligence. Tour Operator should change some of the issues such as eliminating the redundant data. The data integrity rules should be followed in the normalization process. The removal…

    • 948 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Access & Excel. The purpose of this assignment is to test the students’ ability in operating and managing business data…

    • 3101 Words
    • 12 Pages
    Good Essays
  • Best Essays

    to our manual online or by keeping it on your computer system, you have hassle-free answers with…

    • 1527 Words
    • 6 Pages
    Best Essays