Page 2 of 2

Posted: Thu Dec 29, 2005 5:34 pm
by Jeroen Oosterlaar
In case of a many-to-many relationship, always use a 'connector'-table. Following your authors and books example, the following design can be suggested:

Code: Select all

Author { _autId_, autName, ... };

Book { _booId_, booTitle, ... };

AuthorBookRule { _autId_, _booId_ };
The AuthorBookRule-table describes single author/book relationships, where an author can have one or more books and a book can have one or more authors.