Thank you so very much Ryhan. I didn't expect so detailed and friendly reply. Sorry for delaying mine.

I think I would go for separate tables too. I thought about your suggestion for moving the...

Ok. Thank you very much again.

Thank you very much peter_budo.

One more question. What if the database is used by a lot of people and it happen that 2 or more users whant to insert a record in the tables at the same time....

Hi.

I have tables like these:

table1 (table1_id, table1_attribute1, table1_attribute2)
table2 (table2_id, table1_id*, table2_attribute1, table2_attribute2)

The primary key of the first...

Hi.

I'd like to ask you another question. I read a lot of articles about the topic but I'm still not very sure how to deal with the following problem.

I want to design a database that contains...

Thank you again aniseed. While designing the database for this project I'm working on I often considered some of your advices. Highly apprecieate your help.

Great reply aniseed. Thank you a lot for the time you spend to answer my questions.

I thought about the approach with a table like city_district (cityId, districtId). The thing is - if I use such...

Thank you aniseed for the detailed reply. I read some articles about database design these days. Now I can clearly agree the first approach is the logical thing for a database design. I have a...

Hi.

This is the first Topic I've posted at (the cool) daniweb site so go easy on me.

I want to put the cities of England with all their districts in a database. I can think of the following...