posted 16 years ago
Hi,
Starting with an example, say, a customer can open many account and at the same time an account can be opened by many customer. So it is many to many relationship.
Now how do you design the tables?
What did I do is, three tables: Customer, Account and Opens. Opens is connecting table has two column: cutomerId and accountId.
Hope it is clear.
But then I read somewhere, table name should be noun and not the verb.
What to do in that case?
First of all, is my design correct?
Second, what name I can give for connecting table?
Thanks.