How to identify the tables and assign columns

Possible tables and columns for an accounts payable system

Vendors Invoices Invoice Line Items
Vendor name Invoice number* Invoice number*
Vendor address Invoice date Item part number
Vendor city Terms* Item quantity
Vendor state Invoice total Item description
Vendor Zip Code Payment date Item unit price
Vendor phone number Payment total Item extension
Vendor fax number Invoice due date Account number*
Vendor web address Credit total Sequence number
Vendor contact first name Account number*
Vendor contact last name
Vendor contact phone
Vendor AR first name
Vendor AR last name
Vendor AR phone
Terms*
Account number*

Description

The notation used in this figure

Back