Filemaker Pro 9 (47)

Question 1

Deck created in 5-8-14

1. p 303. MULTIPLE TABLES AND RELATIONSHIPS. A database is:

Answer 1

a collection of tables, layouts, and other things that forms an organized system.

Question 2

2. A TABLE holds information about:

Answer 2

ONE KIND OF THING, like people, orders, products, or supplies.

Question 3

3. A FIELD holds:

Answer 3

one ATTRIBUTE OF SOMETHING: the first name, the order date, the color of a product, the supplier’s address, etc.

Question 4

4. An ATTRIBUTE is:

Answer 4

An INDIVIDUAL CHARACTERISTIC. A bicycle might have several ATTRIBUTES: color, height, style, and price. In a database, each of these ATTRIBUTES GETS ITS OWN FIELD.

Question 5

5. Database developers use the word ENTITY to mean:

Answer 5

“ONE KIND OF THING.” PERSON is an ENTITY, and so is INVOICE.

Question 6

6. ONE SPECIFIC thing IS an ENTITY, because:

Answer 6

ONE SPECIFIC THING IS NOT AN ENTITY, BILL GATES IS NOT AN ENTITY, AND NEITHER IS INVOICE #2483.

Question 7

7. A RELATIONSHIP is:

Answer 7

a connection from one table to another, ALONG WITH THE RULES that define HOW RECORDS IN THE TABLES GO TOGETHER.

Question 8

8. An INVOICE has LINE ITEMS, but an INVOICE TABLE and a LINE ITEM TABLE are separate and united by a RELATIONSHIP. How does the RELATIONSHIP WORK?

Answer 8

The LINE ITEM Table has a field called INVOICE NUMBER, which holds the INVOICE NUMBER for each line item. This relationship creates a MECHANISM TO HOOK TOGETHER an INVOICE RECORD and a LINE ITEM RECORD.