Help

Creating a database
F
ILEMAKER PRO HELP 153
8. For each table, decide which fields will store data, and which ones will be used from other
(related) tables.
Based on a table’s subject, you can see where it makes sense to store the data and where to
use data from a related table. Other than match fields, all fields should appear only once in your
database. Cross out occurrences of fields that don’t pertain to the table’s subject.
9. Determine the relationships between the tables. In your plan, draw a line from each match
field in a table to the corresponding match field in the related table.
What establishes a relationship between tables is that their match fields contain matching data.
Customer ID
Address
Phone
Customer Name
Country
Salesperson
Customers table
Products table
Line Items table
Order Date
Customer ID
Order Date
Invoice ID
Invoice ID
Unit Price
Product ID
Qty
Subtotal
Discount
Extended Price
Product Name
Tota l
Tota l i n Sto ck
Order Date
Product ID
Unit Price
Product Name
Stock
Category
Invoices table
Region
Region
Salesperson
Discount
Total in Stock
Customer ID
Address
Phone
Customer Name
Country
Salesperson
Customers table
Products table
Line Items table
Order Date
Customer ID
Order Date
Invoice ID
Invoice ID
Unit Price
Product ID
Qty
Subtotal
Discount
Extended Price
Product Name
Tota l
Tota l i n Sto ck
Order Date
Product ID
Unit Price
Product Name
Stock
Category
Invoices table
Region
Region
Salesperson
Discount
Total in Stock