Im trying to create or should i say finish a data model. So i can go a head and create the sql for it. There are a couple of points im stuck with.
The database im creating is for a 'ecommerce' solution as part of a university project. It is not a fully functioning solution, it dosent have shopping cart etc etc. It is more a marketing tool, utilising a product catalog and customer profiles.
Every customer has a profile and within their profile they can enter an interest. When they log in sample products from the product table are shown which are related to their profile.
Ive attatched the model as it stands, any advice is greatley appreciated.