Filemaker Pro 9 (53)

Question 1

This set entered on 5-12-2014
5.1.14.4

1. p 318. KEYS. Filemaker knows what records are related because:

Answer 1

you tell it to expect them to have some data in common.

Question 2

2. An INVOICE has an INVOICE NUMBER that is very good at identifying the INVOICE because:

Answer 2

a. it is UNIQUE
b. It is UNCHANGING
c. It is CONSISTENT.

Question 3

3. In database terms, the INVOICE NUMBER is called:

Answer 3

a KEY

Question 4

4. A KEY is:

Answer 4

a FIELD whose value UNIQUELY, UNCHANGINGLY, and CONSISTENTLY identifies ONE RECORD.

Question 5

5. In database theory there are TWO TYPES of KEYS:

Answer 5

a. PRIMARY

b. FOREIGN

Question 6

6. How many TYPES of PRIMARY KEYS are there?

Answer 6

a. SURROGATE KEY

b. NATURAL KEY

Question 7

7. What is a SURROGATE KEY?

Answer 7

It is based on made up data, such as a number generated by the SERIAL NUMBER option. It never repeats, and has no meaning.
But UNLESS YOU GENERATE THE VALUE IN YOUR DATABASE, it is NOT A SURROGATE KEY, even if someone else made it up in THEIR SYSTEM.
A SURROGATE KEY IS MADE UP BY YOUR DATABASE.

Question 8

8. What is a NATURAL KEY?

Answer 8

It is a REAL PIECE of data that can be used as a KEY, such as an INTERNAL INVENTORY CONTROL NUMBER.

Question 9

9. Is a SOCIAL SECURITY NUMBER a NATURAL KEY?

Answer 9

YES. It may be a SURROGATE KEY to the Social Security Administration, BUT IT IS A NATURAL KEY TO YOU.