View Single Post
Old 12-12-2007, 06:43 PM   #16 (permalink)
Haris
The Frequenter
Prolific Welcomer Upcoming Programmer 
 
Join Date: Sep 2007
Posts: 360
Thanks: 24
Haris is on a distinguished road
Default

Tried 10 times with DBdesigner to create a proper user model that has its status, rank and 'tutorials completed' table normalized. No such luck. .

That's the best I could come up with.

Users table description:
  • Every user can have only one status.
  • Every user can have only one rank
  • A user can have many tutorials completed

Linked table description:
  • Many users can have same rank. writer, editor, member
  • Many users can have same status. 0 banned - 1 active
  • Many users can complete same tutorials.

I was soo confused that I could only develop model between users, ranks and status only.

http://www.imgsync.com/data/img/4859350db-users.png
__________________
Necessity is the mother of invention.

My blog
Haris is offline  
Reply With Quote