Q:

What are the advantages and disadvantages of using a database?

A:

There are many advantages to using a database, like a reduction of useless data, increasing consistency and improving data integrity while there are also disadvantages, like requiring lots of time for development and maintenance, substantial startup costs and application programs becoming reliant on the database. Databases can be extremely important tools for managing large amounts of data but they also have their own downsides.

Data is frequently redundant. There are numerous instances when data quickly becomes superfluous and reaches such massive proportions that it makes the collection almost impossible to use for practical purposes. This is why databases can be so important. They can be programmed to help organize the data, maintain it and even allow users to find exactly what they need without the hassle of having to sift through heaps of information they don't care about. Databases can also provide important security. They keep all of the information in one place. This doesn't just improve the expedience and functionality of various applications, it also protects those applications from being compromised. Databases, once made, also help to save various costs.

The problem with databases, though, is that creating them can be a long, costly venture. Once they are made, they can save money, but databases that are made from scratch can require huge amounts of money. Furthermore, databases oftentimes require hardware and software for their startup, and these things can also rack up big costs. What's also highly disadvantageous is that databases will be hooked up to various application programs. So, if the database is compromised, all of those applications will subsequently suffer.

Sources:

  1. cl500.net

Is this answer helpful?

Similar Questions

  • Q:

    What is the Access database?

    A:

    The Microsoft Access database program is a management system included in the Microsoft Office application suite, and an Access database is a file that one creates while using this software program. It comes with the professional edition and higher levels of the Office suite, and it is also available as a separate program. It stores data in a proprietary format and can link to or import data in other programs.

    Full Answer >
    Filed Under:
  • Q:

    Why is database design so important?

    A:

    A good database design is important in ensuring consistent data, elimination of data redundancy, efficient execution of queries and high performance application. Taking the time to design a database saves time and frustration during development, and a well-designed database ensures ease of access and retrieval of information.

    Full Answer >
    Filed Under:
  • Q:

    What is the purpose of a database?

    A:

    A database is used to collect and organize data. Although an electronic version such as one created in Microsoft Access may be the first that comes to mind, there are many non-automated database versions as well, such as a personal phone and address book.

    Full Answer >
    Filed Under:
  • Q:

    What are the components of a database?

    A:

    Database components include one or more tables for the data, a query language that retrieves specific data elements, and forms for entering or displaying data. Additional components include reporting tools and customized page views of data. Relational databases have a schema that defines the relationship between tables and may include components that automate routine tasks.

    Full Answer >
    Filed Under:

Explore