dd wrote: > I am working on sample database application. I want to store book names > and authors. > > 1. Authors: columns(AuthorId_primarykey, Name, SSN) > 2. Books : columns(BookId_primarykey, Title)//Title is unique
Book titles are not unique. > 3. Author_Books: columns(AuthorId_primarykey, BookId_primarykey) > > 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. Why is there a problem when there is an author without any books? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users