#[SOLVED] Help with database design

2 messages · Page 1 of 1 (latest)

ornate steppe Oct 3, 2025, 7:03 AM

Hi, I am building a library management system to learn c++ and I use sqlite to store data. I have created a Book table but I am not sure what to do with authors since sqlite doesn't have a type to store a list.

ornate steppe Oct 3, 2025, 8:18 AM

Ok, never mind. I just discovered many-to-many relationship in database design. So I should create a join table with author and book