Preview

Doctor

Satisfactory Essays
Open Document
Open Document
2483 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Doctor
Assignment: CS Making Business Decisions II

You understand that database technology can dramatically improve your ability to analyze information, compared to spreadsheet technology, and assist you in developing your strategic plans for the cafe. To help you familiarize yourself with databases and their associated business value you need to create a report detailing the basics of databases and why they are better for running a business than spreadsheet applications. Be sure to provide a detailed explanation of relational databases along with their associated business advantages.
PROJECT FOCUS:
Once you understand the benefits associated with a relational database you decide to build a small database to help you track and analyze customer orders and sales information.
Identify the different types of entities, attributes, keys and relationships you will want to consider when designing the database.

For this assignment, you will NOT create a database. You will list the type of data you want to collect, group it accordingly, break it into field and determine attributes. Think about how the different pieces of data relate to one another and what purpose they serve. You may use Excel, Word, or Visio for this assignment.

Assignment: CS Making Business Decisions II

You understand that database technology can dramatically improve your ability to analyze information, compared to spreadsheet technology, and assist you in developing your strategic plans for the cafe. To help you familiarize yourself with databases and their associated business value you need to create a report detailing the basics of databases and why they are better for running a business than spreadsheet applications. Be sure to provide a detailed explanation of relational databases along with their associated business advantages.
PROJECT FOCUS:
Once you understand the benefits associated with a relational database you decide to build a small database to help you track and analyze

You May Also Find These Documents Helpful

  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    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.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Better Essays

    In this paper the writer will seek to respond to the questions designated for both scenarios. This paper will list typical fields for each type of data. Provide an example of two relationships that you need to track. This paper will also answer the questions of: Do you need a database system? If not, can Excel® handle the data and the output? What are the advantages and disadvantages? Would you use a personal database or an enterprise database? Explain your answer. Would a decision support system (DSS) be helpful? Explain your answer.…

    • 1392 Words
    • 6 Pages
    Better Essays
  • 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

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is gathered, I will divide this information into tables. Information will be properly placed into columns and I will set a primary key. Upon completion of table design, I will set the relationships between tables. I will refine my design and apply normalization rules to my design.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Week 1 BIS221

    • 536 Words
    • 3 Pages

    Databases allows companies to organize all their information on one place, making it easy for people to access and share information.…

    • 536 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
  • Good Essays

    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
  • Better Essays

    Normalization of the database: This is a critical step for making the database. Normalization will help create table structures as well…

    • 3100 Words
    • 13 Pages
    Better Essays
  • Satisfactory Essays

    The database needs to be created to exactly as the client requests and as he needs it as this is one of the most important factors of building any database: to make it to the user’s requirements.…

    • 373 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    Rob, P., & Coronel, C. (2002). Database systems: design, implementation, and management (5th ed.). Boston, MA: Course Technology.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Best Essays

    Termpaper

    • 4159 Words
    • 22 Pages

    1.Identify the potential sales and department store transactions that can be stored within the database.…

    • 4159 Words
    • 22 Pages
    Best Essays
  • Good Essays

    Week 1 SOW 1

    • 452 Words
    • 2 Pages

    Building the Physical Database: The data model will be translated into the Relational Database Management system of choice. All Tables and Columns with specific data types will be created and will include Relational and other constraints.…

    • 452 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Week 2

    • 263 Words
    • 2 Pages

    What are some ways databases are used in the work environment? What are some ways database use could be improved in the workplace?…

    • 263 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays
  • Better Essays

    A database stores keyed information in an organized and accessible manner. The size and capacity of databases can vary widely, from a small database used by an individual to file phone numbers, to an extremely large enterprise database that stores several gigabytes of information accessed by thousands of individuals. Databases are essential for almost every company in today's business world. Database can help us keep track of, inventory, billing, pay role, phone numbers and much more. Lacking the use of databases, work will take longer to accomplish. Another wonderful feature about having a database in place is that a record of all transitions can be kept for analyzing purposes.…

    • 807 Words
    • 4 Pages
    Better Essays