Member Avatar for nonshatter

Hi guys,

Basically I'm making an auction website (kinda like eBay), and am trying to make my database 2NF compliant (and eventually 3NF compliant). Here is an outline of my tables/fields:


I know I need to split the tables up into additional tables so that data isn't repeated, but I am struggling to grasp how this is done without messing it up. I was hoping one of you experts could help me!

Many thanks

2nf.jpeg 33.28 KB
  • 3 Contributors
  • 4 Replies
  • 119 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by nonshatter
Member Avatar for nonshatter

Thanks, I think I've done it now : D

Member Avatar for drjohn

If you've done it, tell us what you did and we can tell you if you are right or wrong (your original post has errors)

Member Avatar for nonshatter
If you've done it, tell us what you did and we can tell you if you are right or wrong (your original post has errors)

Sure... I know for a fact that I have some errors here, but this is the result of my first attempt so please be kind!


Thanks,
nonshatter

3nf.jpg 45.28 KB
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.