Btec Business Level 3 Unit 9 D2

Improved Essays
Show More
Task 9
For this task I must compare the usefulness of maintaining a database with MySQL compared with if I were to use the query language (QBE). For this task I will need to evaluate the advantages for both the languages, as well as the disadvantages, to find a conclusion which is evenly presented for both of the languages.
Advantages and Disadvantages
Although the two languages interlink in many different ways they have many different features that must be noticed by the user before the use of either, these two tables show the brief comparisons that should be made before using either of the two languages.
MySQL
Advantages Disadvantages
Point How it affects the user Point How it affects the user
The language used is easily learnt This means that the user can start off with …show more content…
Its fast Because there are less commands then other software, MySQL offers the majority of coding with a speed that no other software’s offer Stability issue This means that when the user is accessing the software there may be issues with the software itself, some of which have been experienced whilst doing this assessment.
This table sums up some of the advantages and disadvantages of MySQL software however there are some intertwining reason the can be expressed separately, for example how the user would react by issues, although these where not as appropriate so they would be classed under customer satisfaction rather than the actual operation of the software.
Query by Example QBE
Advantages

Related Documents

  • Superior Essays

    Btec Business Level 3 Unit 8 M1
    • 1213 Words
    • 5 Pages

    Btec Business Level 3 Unit 8 M1

    Computer aided design is substantially quicker, progressed and precise. It can be utilized to impart better as there is less mix-ups and better readability. It likewise attempts to the models naturally, additionally decreasing the odds of slip-ups. Generally speaking, CAD expands the benefit of organizations as it is so flexible and versatile. In spite of the expenses of this product, its adds to the nature of the final result/segment and spares significantly more time.…

    • 1213 Words
    • 5 Pages
    Superior Essays
    Read More
  • Improved Essays

    Nt1310 Unit 9 Essay
    • 631 Words
    • 3 Pages

    Nt1310 Unit 9 Essay

    As one language was updated as was the other as they were developed together to act as parallel, this is because QBE relies on a language like SQL for the specific commands but QBE turns actions by the users into SQL strings. Both MySQL and QBE are used to create relational databases with relationships, however they have many differences which makes them more suitable to specific users, such as QBE is simpler so better for beginners. Both are excellent at their purposes as they can make tables which can be looked over and modified, however, there is some advantages and disadvantages to…

    • 631 Words
    • 3 Pages
    Improved Essays
    Read More
  • Improved Essays

    Louisiana Health Information Exchanged: Case Study
    • 735 Words
    • 3 Pages

    Louisiana Health Information Exchanged: Case Study

    The Louisiana Health Information Exchanged (LaHIE) launched in 2011 is a secured, standardized electronic system that allows for the sharing of important health information within the state and eventually across states. They are partnered with Orion Health a software company that works globally with companies to meet their software needs. LaHIE has a web-based access system that allows access to health records with an iPad, personal computers and PC networking. It has a Hybrid Program meaning it uses a paper record system as well as electronic system that helps the state with overwhelming health care expenses improving in the electronic access and sharing of medical records using a network that is secure and confidential. This program also…

    • 735 Words
    • 3 Pages
    Improved Essays
    Read More
  • Decent Essays

    Unit 10 D2
    • 502 Words
    • 3 Pages

    Unit 10 D2

    Task 10 (D1) Discuss how potential errors in the design and construction of a database can be avoided. One of the potential errors that can occur when creating a database is that field names and names can be spelt incorrectly due to human error this can be difficult to spot if the database is big the way of making sure that there are no naming errors is to make sure that every is checked regularly and more than twice to make sure that the chances of finding a spelling mistake is reduced. Using the wrong data type is another potential error that can occur when creating a database this can be troublesome as if there is a relationship created between the tables and the mistake is found and changed then the database wouldn’t allow you to change the field where the data type is incorrect without removing the relationship first so it will be made into a long process of removing the relationship between the tables changing the data types for each of the table before remaking the relationship between the tables again the way of preventing this is by looking at the field names for the database and then choosing the correct data type also perhaps getting the opinion of another person and rechecking that they are all correct before creating the relationship.…

    • 502 Words
    • 3 Pages
    Decent Essays
    Read More
  • Decent Essays

    Btec Business Level 3 Unit 9 P1
    • 59 Words
    • 1 Pages

    Btec Business Level 3 Unit 9 P1

    As per our conversation on the phone, I would like to update you on the progress of submitting the payment details. FPI will send confirmation that any future premiums for the policies stated will be collected by the new card when they have updated their records. Once again, please accept my apologies for my mistakes in spelling your name.…

    • 59 Words
    • 1 Pages
    Decent Essays
    Read More
  • Improved Essays

    C464 Task 1 Business Plan
    • 508 Words
    • 3 Pages

    C464 Task 1 Business Plan

    C464 Task 1 Presentation Plan Outline Audience: My ideal intended audience is registered nurses who are employed in positions such as floor nurses or clinic nurses who provide direct patient care. Additionally, any employee who provides patient care, such as Certified Nursing Assistants, can benefit. The topic may also benefit nurse managers and trainers when communicating with staff and training new employees. This topic is significant to this audience because the primary concern for nurses and other healthcare providers is providing quality patient care, and one issue that many healthcare workers struggle with is stress-reduction.…

    • 508 Words
    • 3 Pages
    Improved Essays
    Read More
  • Great Essays

    Nt570 Unit 2 Assignment Of Localization
    • 1596 Words
    • 7 Pages

    Nt570 Unit 2 Assignment Of Localization

    ASSIGNMENT-1 TRANSLATION IN LOCALIZATION Internationalisation of software INN570 DUE DATE- 31 August 2014 Submitted To Submitted By Lecturer Geetanjali Bhatt Prof. Yue Xu N8969507 TRANSLATION IN LOCALIZATION Introduction: Localization is defined as the process of adapting/ customizing a product according to linguistic, cultural and technical requirements of the particular locales. It is the last step of creating a world ready application and lot of effort require to complete the task. The aim of localization to give the…

    • 1596 Words
    • 7 Pages
    Great Essays
    Read More
  • Great Essays

    Btec Business Level 3 Unit 9 P3
    • 1857 Words
    • 8 Pages

    Btec Business Level 3 Unit 9 P3

    P3- Compare the ways in which at least two organisations of your choice apply the marketing mix (7P’s) to the marketing planning process to achieve business objectives Definition of marketing mix When it comes to defining marketing mix in words, then it would be referred as the actions and methods used by a business to promote their products or services. The marketing mix is important, because each of the elements on the diagram above influence each other when taking decisions. These 7P’s make up the whole business plan and if they are practiced in the right way there would be a great success to the business. (The economic times, no date) Title: Marketing Mix diagram:…

    • 1857 Words
    • 8 Pages
    Great Essays
    Read More
  • Great Essays

    Business Law: Discussion Questions
    • 1880 Words
    • 8 Pages

    Business Law: Discussion Questions

    WRITTEN QUESTIONS 1. IDENTIFY THE CURRENT STATUTORY REQUIREMENTS FOR TAX COMPLIANCE AND LIST AND CALCULATE THE TAX LIABILITIES FOR HOUZIT PTY LTD UNDER TAXATION LEGISLATION. STATUTORY REQUIREMENTS a. Business Registration. Registering the business organisation will enable the company to register itself to the following in order to comply with the legal requirements set by the government to regulate business entities. • Tax File Number (TFN) • Australian Business Number (ABN) • Goods and Services Tax (GST) • Pay As You Go (PAYG) Withholding b. Tax Obligations.…

    • 1880 Words
    • 8 Pages
    Great Essays
    Read More
  • Improved Essays

    Simply Serendipity Inc Case Study
    • 930 Words
    • 4 Pages

    Simply Serendipity Inc Case Study

    Project Risk Management Simply Serendipity Inc. is looking at implementing a new information technology system that would allow its employees to access and maintain some of their own human resource information. The information that they would be able to accessed and changed would include their home address, telephone number, and email address. All employees would also be able to access and change their tax withholding and pension plan contributions. The implementation of this plan would reduce the workload on the human resource department by placing this responsibility on the employee.…

    • 930 Words
    • 4 Pages
    Improved Essays
    Read More
  • Improved Essays

    Benefit Of Using A Relational Database
    • 710 Words
    • 3 Pages

    Benefit Of Using A Relational Database

    The benefit of using a relational database is that it can help the efficiency of data storage by avoiding data duplication. It is very easy to change data and the format of it which can be added or removed easily. The data can only be stored once so no more than one record change is needed. Relational databases are used to work together by primary key and foreign key as this creates a link between more than one table. By this it can use the attributes and entities within the database which makes it easier to access.…

    • 710 Words
    • 3 Pages
    Improved Essays
    Read More
  • Great Essays

    Mysql Vs Mongo
    • 1465 Words
    • 6 Pages

    Mysql Vs Mongo

    Homework - MySQL & MongoDB Write a 5-page paper to compare MySQL and Mongo with regards to how queries are prepared and executed, and the reasons why. Include a section to compare and contrast the two technologies with regards to how they foster data integrity, performance and security. In the ever-changing world of technology, there have been many clear advancements in the space of databases. Two very common databases are MySQL and MongoDB.…

    • 1465 Words
    • 6 Pages
    Great Essays
    Read More
  • Great Essays

    The Pros And Cons Of A Centralized Database
    • 1094 Words
    • 5 Pages

    The Pros And Cons Of A Centralized Database

    Centralized Database or Database Replication: A Business Case There are numerous considerations when implementing either a centralized database or multiple replicated databases. These considerations include the question of whether the return-on-investment outweighs the upfront and future cost of the solution, what risks are associated with each solution and whether those risks are acceptable to the business, and what impact either solution would have on performance and productivity. By addressing these questions and weighing which solution most aligns with the overall business strategy while introducing more positive than negative consequences, the company can make the appropriate decision and move forward with the planning, design, and implementation of the solution.…

    • 1094 Words
    • 5 Pages
    Great Essays
    Read More
  • Improved Essays

    What Are The Major Dimensions Of Information System Quality?
    • 724 Words
    • 3 Pages

    What Are The Major Dimensions Of Information System Quality?

    The first research question was explored through the literature review and consideration of the needs of the WCC as an example of an organization requiring an asset management information system. When attempting to update their model (Delone & McLean, 2004) there were three major dimensions of information system quality. These included service, system, and information quality. Each of these measures of quality needs to be investigated, controlled, and measured (Petter, DeLone & McLean, 2013). This is important since the majors will have an influence on user satisfaction and use.…

    • 724 Words
    • 3 Pages
    Improved Essays
    Read More
  • Superior Essays

    Advantages And Disadvantages Of The Database Management System
    • 1307 Words
    • 6 Pages

    Advantages And Disadvantages Of The Database Management System

    According to (Connolly, 2003) the database is “A shared collection of logically related data, and a description of this data, designed to meet the information needs of an organization”. The Database Management System (DBMS) is software that enables users to define, create, maintain and control access to the database. The database has identified three levels of abstraction. All these three levels will have different aspects and they are as follows: • Physical or external level- The database system can show for the users the part of the database what they need to use.…

    • 1307 Words
    • 6 Pages
    Superior Essays
    Read More

Related Topics

Ready To Get Started?
Discover
Company
Follow
©2024 Cram.com
Privacy Policy |  About Ads |  Site Map |  Advertise  | 
  • Cookie Settings