It is a special data processing system, or part of a data processing system, which aids in the storage, manipulation, reporting, management, and control of data. It is a program that lets one or more computer users create and access data in a database.
B. Define how each of the following fit and function within the framework of relational DBMS.
Data fields - includes field structure (size of each field and whether it is a date, an integer, or a text field) and field organization (names and locations of data fields within a document record).
Forms - it can be used to facilitate database data entry and/or retrieval operations. Its outcome is better compared to tables.
Foreign Key – it identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. The columns in the referencing table must be the primary key or other candidate key in the referenced table. The values in one row of the referencing columns must occur in a single row in the referenced table.
Queries - are the primary mechanism for retrieving information from a database and consist of questions presented to the database in a predefined format.
Records - A database record consists of one set of tuple for a given relational table. In a relational database, records correspond to rows in each table.
Reports - A database report presents information retrieved from a table or query in a preformatted, attractive manner.
Table Linkages – this is where primary key and foreign key are used to link each other.
