CD WOW based College Project

[Mikebyrne]

I'm currently doing a project that has a web based front end to a database.

I've decided to do a online retail store ie www.cdwow.ie

At the moment I've 4 tables (Games, DVD, CD, Users) but im not sure what relationships to set between them.

My second issue is how to record user orders??

I've attached the work i've done so far.

I'd be grateful for any help or a point in the right direction