Filemaker Pro 9 (54)

Question 1

This set entered on 5-12-2014
5.2.14.1

1. A PRIMARY KEY is:

Answer 1

a KEY FIELD that is in the same table that holds THE RECORDS IT IDENTIFIES.

Question 2

2. In the INVOICE TABLE, what is the PRIMARY KEY?

Answer 2

the INVOICE NUMBER FIELD because it IDENTIFIES AN INVOICE RECORD. If you put the INVOICE NUMBER in the LINE ITEMS table, it is NOT a PRIMARY KEY THERE.

Question 3

3. If you put the INVOICE NUMBER in the LINE ITEMS table, it is NOT a PRIMARY KEY there, it is:

Answer 3

a FOREIGN KEY.

Question 4

4. What do FOREIGN KEYS do?

Answer 4

FOREIGN KEYS IDENTIFY RECORDS IN OTHER TABLES.

Question 5

5. Where do you need to put the FOREIGN KEY?

Answer 5

When you have a ONE TO MANY RELATIONSHIP, you MUST put the FOREIGN KEY in the table ON THE “MANY” SIDE.

Question 6

6. By looking at the ENTITY RELATIONSHIP DIAGRAM, how do you know where the FOREIGN KEY GOES?

Answer 6

When you see a CROW’S FOOT in the ER Diagram, you NEED a FOREIGN KEY in the TABLE TO WHICH IT IS ATTACHED.

Question 7

7. In a ONE TO MANY RELATIONSHIP, where is the PRIMARY KEY?

Answer 7

It is ALWAYS on the “ONE” table. The FOREIGN KEY is ALWAYS on the “MANY” table.