Basic Database Design Question

[EzehM]

I am a complete novice when it comes to database designs. I will like to design a database that contains in each row – the name of a country, The address of the country’s foreign ministry and the addresses of their embassies abroad

Will it make sense to have all this information in one table

e.g.

ID|Country| ForeignMinistry|EmbAlbania|EmbAlgeria etc

Considering that the number of columns might grow to more than 200!

Is there a better way to break this information down into more tables?

Thanks

 

[Remou]

I can see two tables at a quick glance.


[tt]Embassies Table
EmbassyID -> Primarykey
Embassy_Of_Country ->CountryID
Embassy_To_Country ->CountryID
Ambassador
<etc>

Countries Table
CountryID
CountryName
<etc>[/tt]

Which database you intend to use?

 

[EzehM]

Remou,

Thanks. I intend to use MySQL.

How will these tables link with each other?

 

[Remou]

This should help:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins/

 

[Remou]

This too:

http://en.wikipedia.org/wiki/Relational_database

 

[EzehM]

Thanks for your help. I have also been reading up on databases. Thanks

 

[ceh4702]

So what do you plan on doing with Embassador? Is that a name or like a person ID? You might find a person ID with a separate File like an employee file might be nice. Might need contact info or something. Names are too ambiguous. You could esily get two people with a similar or the same name.

If you do not like my post feel free to point out your opinion or my errors.