Step 5: Use usernode for presenting multiple node profiles or user searches (optional)
The usernode module tries to make users nodes. It cares for automatic creation and deletion of a node for each user, the so called usernode.
If the usernode module is installed, the nodeprofile module sets a nodefamily relation between the content type of usernodes and all nodeprofile content types so that it is possible to easily get all node profiles and display them at the usernode. Per default there is a link to each nodeprofile of a user on its usernode. You can theme the usernode to even show the full profile(s).
So the usernode is in particular useful in conjunction with nodeprofiles if you need a page for each user, where you want to present the available data. Usernode comes with a template.php, which adapts user links to point to the usernodes instead of user/USER_ID. If your theme has already a template.php file, just put the functions of usernode's template.php into yours.
Another use case of usernode is building user listings or user searches with views. Due to the automatically created nodefamily relation between your usernode content type and your nodeprofiles, it's even possible to include profile data into these user listings or searches. To do this, you need to use the views fusion module. Have a look at Step 4, which explains how the views fusion module can be used. The only difference is that one of your fused views has to list the usernode content type.
So e.g. if you have a view "profile" that lists your nodeprofiles, create another view "usernodes" which lists nodes of the usernode content type. Then create a fusion, e.g. use the usernode view as primary view fused with the profile view using the nodefamily parent-child relation.

Data relation
After reading this I looked through the tables. Maybe these queries help to understand the releations.
Join users with their nodes
SELECT * FROM users AS uLEFT JOIN usernode AS un ON u.uid = un.uid
LEFT JOIN node AS n ON n.nid = un.nid
LIMIT 5
Get the profile nodes. Should be limited by user and type
SELECT * FROM users AS uLEFT JOIN usernode AS un ON u.uid = un.uid
LEFT JOIN nodefamily AS nf ON nf.parent_nid = un.nid
LEFT JOIN node AS n ON n.nid = nf.child_nid
LIMIT 5