relationship between tables

Possibly. it depends on your data:
if a user has a single occupation then the user table needs an occupation_id column
if an occupation belongs to a single user then the occupation table needs a user_id column
if a user can have many occupations and an occupation can have many users then you don't need to add columns to either of those table, but you do need to create a join table occupation_users with columns user_id and occupation_id.

You then do
class User
   has_many :occupation_users
   has_many :occupations, :through => :occupation_users
end
and similarly for Occupation.

Fred