you would use Data Assist to Create pages for managing the different tables in the database
Run the wizard to create pages for managing the products table.
and again to create set of pages to manage the categories table.
The eCommerce database structure is created in a way that allows a One to many relation between products and categories, meaning that a product can belong to only one category.
another set of pages would be needed to create options groups (color or size for example)
and another set to create options and assign them to the groups.
On the products pages, you would use the manage relational table behavior to update the productoptions linking table that is used to create the many to many relationship between the options and products tables.