Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Structure (Key field (Are individual pieces of of data that are…
Database Structure
Key field
Are individual pieces of of data that are unique
Are used to differentiate one record from another
Database
It store data that has been organised in some way
Data
It is an information that store in a database
Field
It is an area in a fixed or known location in a unit of data such as a record
Table
It is a collection of related data held in a table format within a database
Record
It is a composed of fields and contains all the data about one particular thing
Text data
A data that contains the alphabet A-Z or a telephone number
Descending sorting
Start with the highest value and move until reaches the lowest value
Asending sorting
Start with the lowest value and move until reaches the highest value
Date
The data that include the date and time
Number data
the data that contains number 0-9
Sorting data