|
-
Nov 4th, 2006, 03:39 PM
#1
Thread Starter
Addicted Member
Database desigining confusion {please help}
Please suggest me best way of designing database in this situation.
There are only two database tables.
Table1 : Country
Table2 : Person
In table name Country there are only two fields
Field1 : ID
Field2 : Name {country name}
And problem is on designing table name Person...
I want to record countries every person has visited.
So two fields are confirm in my mind that are
Field1 : ID
Field2 : Name {person name}
but what is the best way to record persons who have visited multiple countries ?
If i put 3rd field as
Field3 : CountriesID
and record countries id for every country visited by every person then i will need to create multiple records like
suppose
person id = 3
person name = Jeff
countries he has visted are 3 with country codes as = 1,2,3
now i need to create three records in table name person as
3,Jeff,1
3,Jeff,2
3,Jeff,3
I am confused whether it would be right to create single record like this
3,Jeff,{1,2,3} ?
Or what is best way in this situation to design database for optimum results ?
Hopefully my question is clear to you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|