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
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.Learn more about Software
The four types of database access include tables, forms, reports and queries. Each type of access allows the user to view the data in a different format.Full Answer >
Microsoft InfoPath allows users to create various electronic forms, including surveys, expense reports and time cards, to work in tandem with an existing business database or as a standalone solution. Companies also use it to improve the interface of their websites and automate the process of collecting and sharing information.Full Answer >
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 >
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 >