Dear friends we have a problem here.
We have 3 tables - table language (id int not null auto_increment primarykey, languageName tinytext) - table country (id int not null auto_increment primarykey, defaultName tinytext, defaultLanguage tinytext) - table countryToLanguage ((languageID int, countryID int) primary key, countryNameInLanguage tinytext) in the table countryToLanguage, the column languageID is a foreign key referencing language (id) in the table countryToLanguage, the column countryID is a foreign key referencing country(id) in the table country, the column defaultLanguage is a foreign key referencing language(id) In order for the database to be perfectly normalised, we think it the column defaultName in the table country should be a foreign key referencing back countryToLanguage ((languageID int, countryID int)). What do you think? If you do that then there are lot of problems in updating the tables. -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
