Multiple Images per product through the database

A new client needs multiple images for each product. So I wanted to check with Webassist first to see what is the best way to do this.

I just bought the MySQLi.
Own: Design Extender and Data Bridge
Running DW CC2015
Windows 10

I am looking for guidance in adding multiple images for each product.

1. Do I have to have a separate column in the record for each picture?
2. What would be the path for each picture? images/product1.jpg, etc?
3. Does Webassist have a method to be able to show "more images" for each product and have them come up in a pop-up type window or is there some way to make thumbnails that pop-up to full-size images?

Appreciate any guidance to get me going.