For each search type, decide what user data is needed for searching, matching and display and map the database tables and relationships that hold that data.

For example, the Customer Search system needs to search on customer name or address, requires name, address, date of birth and sex for matching, and in addition to the matching fields, requires Customer- ID, Customer-Type (individual or organization) and Name-Status (current, former or alias) for display.

This data is stored in User Source Tables as follows: