Relational Databases

3. A key that is a unique identifier for a single row/record.
6. A description of all the attributes' properties in held in a data ____.
9. The check made to ensure data entered falls within a specified parameter/s.
10. How a foreign key is described in the validation section of the data dictionary.
12. What does an entity-occurrence diagram help to describe?
14. An attribute/key that is created to be the primary key.
15. A primary key is always required because it can never be ____
16. A data type used to store a TRUE or FALSE value in a database.
18. Data integrity in a relational database should be ____.

1. Used to create a relationship between two entities.
2. SQL stands for Structured ____ Language.
4. A foreign key should NEVER be ____ in the data dictionary.
5. A data type used to store a whole number in a database.
7. There are three types of these: one-to-one, one-to-many, many-to-many.
8. A ____ is made up of attributes.
11. A structured way of storing data.
13. Each attribute has a data ____ such as integer, real, text etc.
17. A check made to ensure data entered is a specified number of characters long.