Database

Question 1

Primary Key

Answer 1

Primary key fields hold values that will be unique for each record or entity in the table

Question 2

Foreign Key

Answer 2

Primary key from one table that is used in another table

Question 3

Validation

Answer 3

• Helps to reduce data entry errors
• It is used to check that data entered in a field is acceptable/meets the critera when compared to criteria set in the database design

Question 4

One to many relationship

Answer 4

In a one-to-many relationship, one record in a table can be associated with one or more records in another table