Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASE #2 (To ensure that the data entered is consistent in both tables,…
DATABASE #2
To ensure that the data entered is consistent in both tables, a feature called, enforce referential integrity' can be applied to the relationship between the tables
-
-
-
When created, each field within the record structure is named and an appropriate data type is attached to the name
-
Data validation guarantees that data is present and the correct type, range or lenght
-
Examples are presence, length, type, format and range checks.
When the computer checks input data, it will either accept the data or display an error message saying why the data was rejected
-
-
-
-
To ensure this, there is a presence check in the field description for field name town ( required is set to YES and the validation rule is set states IS NOT NULL)
-
Used to ensure that data entered is of the correct type. There are many different types like numeric, text and date.
Ensures that data entered matches a predetermined pattern. For example, a postcode would have a pattern such as BTXX XXX.
-
-
-
-
-
-
-
-
-