Filemaker Pro 9 (57)

Question 1

5. 3.14.1

1. p 323. CREATING A RELATIONAL DATABASE. How many steps to creating a database and what are they?

Answer 1

a. Tell Filemaker what tables you want
b. Add the FIELDS to each table
c. Add RELATIONSHIPS.

Question 2

2 Which tables need PRIMARY KEYS?

Answer 2

ALL OF THEM.

Question 3

3. You add the tables, then add the FIELDS.
   Start with the PRIMARY KEY FIELD.
   To keep things consistent, every PRIMARY FIELD will look similar:

Answer 3

It will match the NAME OF THE ENTITY with the word ID added at the end.

Question 4

4. What is the EASIEST way to add a SURROGATE KEY in FileMaker?

Answer 4

To use a SERIAL NUMBER.

Question 5

5. p 325 KEY FIELDS can be any TYPE (Text Number, Date, etc.), but ________ is usually the BEST CHOICE because:

Answer 5

NUMBER.

Because it is the EASIEST to MATCH EXACTLY.

Question 6

6. When you create a SERIAL NUMBER, you get the option to have it generated “ON CREATION” or “ON COMMIT.” What should you use?

Answer 6

ON CREATION, because when you create RELATED RECORDS through a PORTAL, you need to have the SERIAL NUMBER created without having to click out of the RELATED RECORD.

Question 7

7. What happens if, on a KEY FIELD, you DO NOT select the PROHIBIT MODIFICATION OF VALUE DURING DATA ENTRY?

Answer 7

Since KEY fields PROVIDE THE LINKS BETWEEN YOUR TABLES, RELATIONSHIPS WOULD BREAK IF KEY VALUES GOT CHANGED.

Question 8

8. When linking tables, the ACTUAL LINK is not the fact that one table has a KEY FIELD and another has a FOREIGN KEY FIELD. The ACTUAL LINK is:

Answer 8

the NUMBER (OR OTHER ID) INSIDE THE FIELD.