Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database (Parts of a Database (Field: column in a table, characteristic…
Database
Parts of a Database
Field: column in a table, characteristic of something stored in a database
Record: All the data about one item eg; student name, address, primary school, SATS results
Entity: something we store data about eg: car or an exam subject
Becomes a table in a database, one instance of an entity becomes a record
Attribute: is something about an entity, this becomes a field in a database
-
Foreign Key: is a primary key in another table, used to link the tables
-
-
-
Validation
-
Verification : asks you to input password or email twice, checks the data is the same
Format Check: eg: postcode
Range Check: between 10 and 20
Length Check: only x number of characters can be stored
Presence Check: means this field MUST be completed
Data Type: Restricts data entered to a particular data type eg: text, number, date/ time
LookUp Check: used to link tables foreign keys look up the data from the primary key in another table
Check Digit: uses a calculation to check a number generated is correct eg: ISBN
-
-
-