Create A File (Table) and Set Index Order
Each field in a record is defined by name, type and length.
In order to keep the file, also called a "table," in sequence, one or more fields are defined as key fields, upon which indexes are created and maintained.
The index is updated whenever records are added or deleted or any data in a key field changes.
,
Create Data Entry Forms
Data entry is accomplished by designing a form to display each record.
Data entry forms contain field validation, which determines what data can go in and what cannot.
,
Reporting
Reports provide details and summaries in a more elaborate fashion than queries.
Reports have page and column headers and can be sorted into order by multiple fields; for example, city within county within state.
Once a report description has been composed, it can be saved for use again.
,
Update/Edit
In a single-user, one-file-at-a-time application, there is nothing to predefine here.
Changing data is a matter of opening the file and selecting the EDIT mode.
However, in a multiuser system, security must be administered and audit trails must be programmed.
,
View/Query
Browse an entire file or select records.
Selected records are usually created as a temporary file that can be sorted into a different sequence and, after viewing, can be deleted or saved for later use.
The ease with which a query can be composed determines how often users ask their own questions versus relying on IT staff.
For example, retrieving d.
,
What is a database management system?
A database management system is a piece of software designed to facilitate data manipulation and database structure management.
It also acts as a gate between the database and the users and apps that want to view or change the data.
User accessible catalog describing metadata.
DBMS library management system.
Data abstraction and independence.