>>Book titles are not unique.
I agree. 2. Books : columns(BookId_primarykey,
Book_id_in_string_format_like_guid)
>>Why is there a problem when there is an author without any books?
No problem. But, my app need to delete author record from author
table when author doesn't have any books. How to handle this? (I can verify
in author table, whether this author belongs to any other book when book
deletion. If no, delete from author table. I am not happy with this
solution )
On Wed, Jun 12, 2013 at 12:37 PM, Clemens Ladisch <clem...@ladisch.de>wrote:
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
