Hi there,
If users want to be able to see more than one image for a searched book which would be the best way for the database table to be designed?
Book table :
Isbn, year, title, image_1, image_2, image_3, image_4
or
Book table
Image seperate
Each book will in book table will be unique
Please explain why as well
Thanks
SLK
I'd say keeping the books and images in seperate tables then so that you're not limited to the amount of columns you define.
4 example:
books_table
bookID , year, title
example:
1 , 2008, Example name
book_images
bookID, image
example:
1 1.jpg
1 322.jpg
1 332323.jpg
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.