0

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

3
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by djjjozsi
0

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.

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.