Preview

Case Study Of Chelsea Hardware

Powerful Essays
Open Document
Open Document
2073 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Case Study Of Chelsea Hardware
Introduction
Chelsea Hardware is one of the best hardware store specialized in Computers, Laptops, and all other IT accessories in Colombo at a reasonable cost. Chelsea Hardware consists of an in excess of 4000 clients in Sri Lanka and World Wide, who are acknowledge on the special administration to extend their business.
Auston is a private school, established in 1996, that has been get ready understudies for professions in Engineering and Project-Management. Currently there have been issues concerned on the grades obtained by the students which in return lecturers and Auston is blamed towards the issue. The lecturers claim that the students don’t attend the classes on a regular basis while the register of attendance proves that the students
…show more content…
You can additionally have the capacity to make structures and make separate reports for printing.
• Bond kept up between tables.
• They are equipped for gathering, sorting, sifting, computing and erasing information.
However there are some disadvantages such as:
Microsoft Access is valuable for individual offices or little to-medium business segments. Any area whose utilization goes past 2 GB will hit a divider and find confinements.
• All the information from your database is saved into one file. This limits options and how you choose utilize data; slowing down reports, queries, and forms. Its performance becomes slow as the user scales data size. Multimedia data can use up MS Access limited space quickly.
MySQL
Mysql is an openly accessible open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most prevalent dialect for including, getting to and overseeing substance in a database. It is most noted for its brisk transforming, demonstrated unwavering quality, simplicity and adaptability of utilization. By using MySQL there some advantages for
…show more content…
• It's Open-Source
There are some disadvantages using MySQL for example:
• It Suffers From Relatively Poor Performance Scaling.
• Improvement Is Not Community Driven – and Hence Has Lagg

According to the above statements I have chosen MySQL has my DMS. It was outlined particularly to oversee information in RDMS and its origination was based upon social polynomial math. The scope of its abilities incorporates information question and redesign, mapping creation and alteration, and information access control. It was one of the first dialects utilizing the RDMS demonstrate and is definitely the most broadly utilized dialect for these social databases.

Questionnaire
A questionnaire is a research instrument consisting of a series of a question and other prompts for the purpose of gathering information from respondents. There are some advantages in questionnaire such as:
• The aftereffects of the surveys can normally be rapidly and effectively evaluated by either a scientist or through the utilization of a product bundle.
• Might be dissected all the more "experimentally" and impartially than different types of

You May Also Find These Documents Helpful

  • Good Essays

    I would think that have to choose MySQL would be the best fit for Wild Wood Apartments. It may run higher in query testing but the overall processes and structure would work better for a small to medium size company. It meets all the requirements that the Wild Wood Apartments has for operating systems, table and row size, Much of MySQL's appeal originates in its relative simplicity and ease of use. This will be necessary for people who are not use to using this type of system.…

    • 664 Words
    • 4 Pages
    Good Essays
  • Good Essays

    One benefit of a relational database management system is that it contains a built-in query language, which lets you obtain immediate answers to the questions you ask about your data. _________________________…

    • 585 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Nt1310 Unit 1 Module 2

    • 5116 Words
    • 21 Pages

    MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced "My S-Q-L", but is often also pronounced /may’si:kwal/ ("My Sequel"). It is named for original developer Michael Widenius 's daughter…

    • 5116 Words
    • 21 Pages
    Satisfactory Essays
  • Good Essays

    When dealing with large amounts of information that you will need to conduct business a spreadsheet may be an inferior choice. The choice of many users is to use spreadsheet applications when possible to store and house their data. This stems from the understanding of the systems. Most users understand the basic concepts behind spreadsheet applications and can manipulate their way through these systems with ease compared to using a database system. What many people don’t understand is how easy it is to retrieve their data later on if they would have used a database system.…

    • 817 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Bis 220 Wk 4

    • 526 Words
    • 3 Pages

    Microsoft Access has evolved into very user friendly tool and has become simple to learn. It provides for the easier adding, subtracting, and altering of data once the database. Access offers the ability to construct queries to extract reports from the database to analyze all aspects of the data captured in the database (Grauer, 2011). Whereas this is possible in Excel, it is much more cumbersome. Access also offers the ability for more than one user to update tables at the same time but will not allow for the updating of one record by two individuals at the same time.…

    • 526 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Each individual workstation will use Microsoft Windows 7 professional x64 service pack 1 for the operating system. The Main database server will use Microsoft Server 2008 R2 x64 for the operating system. The DBMS that will be used will be Microsoft Office Access. A form will be created to add data to the database and make it easy to retrieve data when needed. Reports can be downloaded and printed to show results of the data base inquiry.…

    • 799 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Microsoft Access is a tool used to manage information which helps store information for references, reports, and analysis. It also helps to manage huge sums of information. (OpenGates Software, 2012) Microsoft Access consists of Tables, Relationships, Queries, Forms, Reports, Macros, and Modules. (SimplyAccess, 2012)…

    • 828 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

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

    • 837 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Graphical User Interface

    • 559 Words
    • 3 Pages

    The choice of MySQL as the database platform has many advantage, some of them are:…

    • 559 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    One of the benefits of information technology is also the capability to store a large amount of information.…

    • 1544 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Microsoft Access and Microsoft Excel have many similarities that often times make it hard to decide what program to use. For example, both of the programs have the capabilities to store large amounts of data, run queries and, analysis, and perform complex calculations that return sought-after data. However, by converting data held in Microsoft Excel spreadsheets to Microsoft Access it can be useful for a company because Microsoft Access stores company data in tables that appear to be the same as Microsoft Excel spreadsheets only Microsoft Access is designed for complex querying in relation to data stored in other tables. Additionally, according to Microsoft Office 2012, Access is the best choice when one needs to track and record data regularly, and display, export, or print subsets of that data. Access forms provide a more convenient interface than an Excel worksheet for working with data Using Access or Excel to manage data. Anyone can use Access to automate frequently performed actions, and Access reports let’s one summarize data in printed or electronic form.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Better Essays

    The differences in the architectures are based on how the tables and records are related. Relational architecture is a very popular database. It is also the most mature and widely used database system in production. Relational databases can be used to track patient care in the form of treatments, outcomes of those treatments, and critical indicators of a patient 's current state such as blood pressure, heart rate, and blood glucose levels. They can also be used to interconnect with multiple informational systems throughout a healthcare facility. Relational databases have the potential to eliminate paper storage and transfer of information and to answer important questions about healthcare efficacy. Relational systems serve as the repositories of record behind nearly all online transactions and most online content management systems including social networks. This database also serves as a well-understood point of reference for new extensions and revolutions in database systems that may arise in the future. Another type of database architecture is the Object-oriented model. This model is powerful and quite complex. With the relatively new object-relational database model is the wide spread and simple relational database model extended by some basic object-oriented concepts. These allow them to work with the relational database model but also have some advantages of the…

    • 754 Words
    • 4 Pages
    Better Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    When building a system for information, you have to decide how much responsibility for data management your software will take. A database can be rather large or it can be small depending on the information that is being stored. Request for information from a database are made in the form of a query or a question asking the database for particular information. All database management systems are not the same from a technical standpoint. They differ mostly in the way they organize their information internally. The internal organization can then determine how quickly and supplely the information can be extracted (Jupitermedia, 2011) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Another advantage of the database approach is flexibility in terms of data usage. The data is kept in…

    • 592 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Databases are very important to every person in the world today. Whatever you do in you daily routine you are bound to come in contact with some form of database and our world has become so dependent on it that most people won’t even realize the importance of databases. A database is a bunch of files that are usually integrated electronically together to make up one big file. The database stores all of these files in one location and numerous people can access this information all at the same time if they have the proper access from the database administrator.…

    • 1084 Words
    • 5 Pages
    Better Essays