Q:

What is the definition of the database approach?

A:

Quick Answer

The database approach is a way in which data is stored within a computer. It is organized into various charts that are accessed by a variety of computer applications from different locations. Databases are composed of a variety of information that is pertinent and relevant to the organization that is using the database.

Continue Reading

Full Answer

Databases are often composed of two different pieces of information. The data and the schema are related to each other, but are not the same thing. The schema is the way in which the data will be organized within a table or chart. It can be complex, but is often as simple as the rules that the data must obey in order to create the database. Essentially, it organizes the data. The data is the actual information that is put into the database. It can be composed of numbers, letters or other characters and is representative of some physical entities. Certain rules can be set in place by the schema that will prevent different types of data from being put into the database. For example, some employer related information may prevent an employer from having a date of birth that shows that are less than 18 years old. This can help human resources catch any errors that exist with employee birthdates.

Learn more about Software
Sources:

Related Questions

  • Q:

    What is the difference between a spreadsheet and a database?

    A:

    A spreadsheet is used to keep track of data and do calculations, while a database is used to store information to be manipulated at a later time. Information might start out stored on a spreadsheet, but as the amount of information grows, the need for a database might arise.

    Full Answer >
    Filed Under:
  • Q:

    Why is a primary key important?

    A:

    In database design, a primary key is important because it serves as a unique identifier for a row of data in a database table. A primary key makes it convenient for a user to add, sort, modify or delete data in a database.

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

    Full Answer >
    Filed Under:

Explore