The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Help with a Database Model

Hi Guys,

Hope everyone is well.

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.