Hi All, I am working on sample database application. I want to store book names and authors.
Tables: 1. Authors: columns(AuthorId_primarykey, Name, SSN) 2. Books : columns(BookId_primarykey, Title)//Title is unique 3. Author_Books: columns(AuthorId_primarykey, BookId_primarykey) Here, I am able to avoid rendandent data (author names). I am facing an issue with deletion of records from Books table. One author may belongs to morethan one book. How to handle this scenario? Is there technique like shared_ptr. Thanks in advance. Regards, d _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
