Please do not bid on this project if you cannot code in php and deal with MySQL. No admins this time.
Please get familiar with the features in Zen Cart admin called OPTIONS and ATTRIBUTES.
Technically the options are groups of attributes. 5 screens in Zen have virtually all possible or needed queries. However ... it's really hard to understand and use them. I am providing you several screens (Moc-Up) and 1 html/javascript of the item page. You will need to build the screens and re-write the some functions/queries.