Preview

Case Study: Chelsea Hardware Store

Powerful Essays
Open Document
Open Document
2073 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Case Study: Chelsea Hardware Store
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

    Case Study: Jcpenney

    • 385 Words
    • 2 Pages

    Ron Johnson made some bad decisions that caused him to only last as the CEO of JCPenney for seventeen months (Kinicki & Williams, 2013). His bad decisions consisted of misreading what the shoppers wanted, no testing of ideas prior to execution, distancing himself from the essential consumers, misread the JCPenney brand (Tuttle, 2013).…

    • 385 Words
    • 2 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
  • 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

    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

    Case Study: Jcpenney

    • 631 Words
    • 3 Pages

    James Cash Penney founded JCPenney in 1902 in Kemmerer, Wyoming. It was originally called J.C. Penney Corporation, Inc. JCPenney is known for selling clothing, home furnishings, jewelry, makeup, and cooking supplies. JCPenney has a partnership with Sephora and Ralph Lauren, which are big name brands. Their current headquarters is located in Plano, Texas.…

    • 631 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
  • Good Essays

    Cloud computing refers to the use of computing resources, including software and data storage, on the Internet (A Cloud) rather than on local computers.…

    • 997 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    In 1970 Dr. E.F. Codd published a paper “A Relational Model of Data for Large Shared Data Banks”. Codd’s model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM Corporation Inc., to use Codd’s model. SEQUEL later was shortened to SQL. In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard language.1…

    • 396 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    sql server notes

    • 36521 Words
    • 147 Pages

    SQL is a database computer language designed for the retrieval and management of data in relational…

    • 36521 Words
    • 147 Pages
    Satisfactory Essays
  • Powerful Essays

    Infomation Systems

    • 2974 Words
    • 12 Pages

    A management system is the software that allows a computer to perform functions of storing, retrieving, adding, deleting and modifying data. Relational database management systems (RDBMS) implement the relational model of tables and relationships. In this project proposal, we are going to propose a system for an agricultural company named Monsanto. Monsanto is a relatively new company which shares the name and history of a company that was founded in 1901; the Monsanto of today is focused on agriculture and supporting farmers around the world in their mission to produce more while conserving more.…

    • 2974 Words
    • 12 Pages
    Powerful Essays