Q:

What are the components of a database?

A:

Quick Answer

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.

Know More
What are the components of a database?
Credit: Martin Barraud Stone Getty Images

Full Answer

A simple database has a single table with rows for the data and columns that define the data elements. For an address book, the table columns define data elements such as name, address, city, state and phone number, while a table row, or record, contains data for each person in the book. The query language provides a way to find specific types of data in each record and return results that match the criteria. These results display in a form that uses the defined data elements but only shows records that meet the criteria. These three components make up almost every type of database.

Relational databases use multiple tables and define relationships between them using a schema in addition to data elements. Records and data elements from each table merge, based on the query, and display in the form. Routinely used queries often become reports. A report uses the same query but reports on changes in data over time.


Is this answer helpful?

Similar Questions

  • Q:

    What are the components of a database environment?

    A:

    There are five major components in a database environment: data, hardware, software, people and procedures. The data is a collection of facts, typically related. The hardware is the physical devices in the database environment. Operating systems, database management systems and applications make up the software. Examples of people in the database environment are the system administrator, programmers and end users. Procedures are the instructions and rules for the database.

    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:
  • 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 the definition of the database approach?

    A:

    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.

    Full Answer >
    Filed Under:

Explore