21 terms

Relational Database Terms

When working Relational Database it is to know certain terminologies and concepts.
STUDY
PLAY
Relational Database
A database consisting of more than two related tables. The relationship between the tables is created by placing a primary key of the primary in to the secondary table.
Database Tables
Database tables stores in rows and records in an organised. It is also known as Entity.
Record
A row is made up of fields and contain full details of particular. A table is made of many record.,
Field
A column in a table, also known as attribute
Tuple
Technical Term by database expert and academia; used by developers of relational databases for record.
Queries
It is tool or for extracting information required matching specific requirements.
Forms
It is used for entering, viewing and editing data inside a database
Primary Key
A field that uniquely identifies a given each record in table
Foreign Key
A primary key of one table that is placed as a field in another table with objective of creating relationship between the tables.
Composite Key
Group of fields used to uniquely identify a particular record. While each fields may not be unique the combination identifies each records uniquely.
Attributes
It is another name for fields identifying each columns in database tables.
Entity
It represents main object with a business which relates to table each within a database. It is another name for database tables.
Sort
Arrange the rows in a table in either ascending or descending order.
Report
It is way displaying information from database queries andreports
Macro
It is a simple way of programming the database that performs various actions like opening a form or report or activating a combo box.
Data Integrity
It is a requirement about making sure that data stored in a dtabase and information extracted is reliable, complete and valid.
Format
It is used to customize the way stored data such is numbers, dates, times, and text are displayed and printed.
Input mask
It can be added to table fields, queries, and to form controls with a purpose of specifying how data is stored.
Data
Is a collection of facts that is useless until you process it or put in to context.
Information
Is the useful output or result of the processing of a database that is arranged or put in to context.
Data Types
It is one of the main attribute of a filed it determines what kind of data it can store e.g. text, date, currency, etc.
YOU MIGHT ALSO LIKE...