database/table/etc

Question 1

what does a relational database consist of and connected by?

Answer 1

more than one table and connected by relationships in database

Question 2

what does tables consisted of?

Answer 2

one or more record

Question 3

what do keys do?

Answer 3

uniquely identify records in a table

Question 4

give use of primary key

Answer 4

it uniquely identifies records in table

Question 5

give use of foreign key

Answer 5

a primary key that has taken from one table and into another

Question 6

what is data validation?

Answer 6

checks if data is reasonable, sensible and within limits.

Question 7

what does data validation guarantee and what will happen if data is rejected?

Answer 7

that data is present and correct type, range or length, it will display error message if data is rejected

Question 8

what is data verification and give an example

Answer 8

method of checking data is input correctly e.g proof reading

Question 9

define presence check

Answer 9

ensures that data is present, cannot be left blank or null

Question 10

define length check

Answer 10

ensures data is correct number of characters

Question 11

define type check

Answer 11

makes sure correct data entering e.g numeric, text ,date

Question 12

define format check

Answer 12

determine if data entered matches predetermined pattern

Question 13

define range check

Answer 13

ensures entered data is within lower limits and upper limits