The following outline schema was developed for a customer company database for a large organisation manufacturing and wholesaling a wide range of chemicals for agricultural pest control and land fertilization:

Customerno, customer name, customer address, invoice address, delivery address, contact name, contact_tel_no, customer type, product category, delivery day, salesmanno, credit limit, credit terms, invoice date, discount, turnover this year, turnover last year, current balance.

Identify some potential users of this data and specify suitable external schemas for each.

Sales, Account, warehouse