I would tend to agree with you, but you really only need the two tables if the assumption is a one to many relationship.

But assuming a many to many relationship your schema is nicer, and certainly if you expand the scope, having an id on both the ip address and name is a good thing (most probably a necessary thing).

One minor point though, you can still do reverse lookups on my schema:

$sql_statement = qq|select tbl_names.str_name
           from tbl_ipaddresses, tbl_names
           where tbl_ipaddresses.str_ipaddress = '201.2.23.2'
           and tbl_names.id_name = tbl_ipaddresses.id_name|;
       $sth = $dbh->prepare($sql_statement);
       $rv = $sth->execute;

       while (    ($str_name) = $sth->fetchrow_array ){
           # do whatever
       }
[download]

But thanks for pointing out a nicer way of doing it than I did.

Thanks,

EEjack