1
Q
- 3.14.1
1. p 323. CREATING A RELATIONAL DATABASE. How many steps to creating a database and what are they?
A
a. Tell Filemaker what tables you want
b. Add the FIELDS to each table
c. Add RELATIONSHIPS.
2
Q
2 Which tables need PRIMARY KEYS?
A
ALL OF THEM.
3
Q
- You add the tables, then add the FIELDS.
Start with the PRIMARY KEY FIELD.
To keep things consistent, every PRIMARY FIELD will look similar:
A
It will match the NAME OF THE ENTITY with the word ID added at the end.
4
Q
- What is the EASIEST way to add a SURROGATE KEY in FileMaker?
A
To use a SERIAL NUMBER.
5
Q
- p 325 KEY FIELDS can be any TYPE (Text Number, Date, etc.), but ________ is usually the BEST CHOICE because:
A
NUMBER.
Because it is the EASIEST to MATCH EXACTLY.
6
Q
- When you create a SERIAL NUMBER, you get the option to have it generated “ON CREATION” or “ON COMMIT.” What should you use?
A
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.
7
Q
- What happens if, on a KEY FIELD, you DO NOT select the PROHIBIT MODIFICATION OF VALUE DURING DATA ENTRY?
A
Since KEY fields PROVIDE THE LINKS BETWEEN YOUR TABLES, RELATIONSHIPS WOULD BREAK IF KEY VALUES GOT CHANGED.
8
Q
- 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:
A
the NUMBER (OR OTHER ID) INSIDE THE FIELD.
