Posted: Thu Dec 29, 2005 5:34 pm
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:
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.
Code: Select all
Author { _autId_, autName, ... };
Book { _booId_, booTitle, ... };
AuthorBookRule { _autId_, _booId_ };