Avoiding duplications in tables

Hi All,
                I have the following tables.

(1)     tablename : versions

            versionnumber - string

(2)    tablename : applications

            applicationnumber - integer
            other details

(3)    tablename : applicationnumber

          versionnumber  - string
          applicationnumber - integer

(4)    tablename : profilemanager

          versionnumber - string
          profilename       - string
          applicationnumber - integer
           other details

(5)    tablename : profiles

          versionnumber - string
           profilename      - string

Primary key :
---------------

(1)    versions : versionnumber
(2)    applicationmanager : versionnumber, applicationnumber
(3)    applications : applicationnumber
(4)    profilemanager : veriosnnumber, profilename, applicationnumber
(5)    profiles : versionnumber, profilename

Relations :
-----------

(1)    versionnumber of 'applicationmanager' referes to versionnumber of

          'versions' table.
(2)    applicationnumber of 'applicationmanager' referes to
          applicationnumber of 'applications' table.
(3)    versionnumber and applicationnumber of 'profilemanager' referes
          to versionnumber and applicationnumber of
'applicationmanager'.
(4)    versionnumber and profilename of 'profilemanager' referes ot
          versionnumber and profilename of 'profiles'.
(5)    versionnumber of 'profiles' referes to versionnumber of
           'versions'.

In the above design I can able to see duplication of data in all the
tables. If I take out a id out of all these tables to make reference, is

that problem will solve. Is that is
a correct approach.

Can any one help me.

regards,
Deepa  K