Q:

What is database software used for?

A:

Database software is used for the management and storage of data and databases. The organization of databases is exceedingly important when comprising a database of criminals, evaluating medical and school information, and storing government and driver information.

Database software is typically easy to use so that end users can evaluate data, store it, add to it, and edit it or delete it. The capture and analyzing of data is typically performed by database management systems, otherwise known as DBMSs. These types of database software systems are programmed in SQL, and examples include Microsoft SQL Server, MySQL, Oracle SAP HANA and FoxPro.

Not all database software requires a person to be knowledgeable in SQL or needs programming queries. Web-based database programs such as Microsoft Access are available and can be much easier for a novice to use. The user can navigate the database via the program's GUI controls, without using SQL.

DBMS types of software have four main categories: definition of data, update, retrieval and administration. A DBMS system is also required to protect the integrity of data and provide its security. The precursor to database software was revolutionized by Edgar F. Codd in 1970, with his relational model.


Is this answer helpful?

Similar Questions

  • Q:

    What is the importance of a database management system?

    A:

    A database management system is important because it manages data efficiently and allows users to perform multiple tasks with ease. A database management system stores, organizes and manages a large amount of information within a single software application. Use of this system increases efficiency of business operations and reduces overall costs.

    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 is a database management system used for?

    A:

    A database management system is used to let employees and owners access a large variety of information from a specific location like a computer. It allows access to specific information based on the user's credentials.

    Full Answer >
    Filed Under:
  • Q:

    When using a database, what is a field?

    A:

    In a database, the field is the smallest source of input for users to enter data. For example, a field in a database may ask for a company's name, tax identification number or income. A group of many fields is called a record, and a field in a spreadsheet is known as a cell.

    Full Answer >
    Filed Under:

Explore