12-12-2007, 06:43 PM
|
#16 (permalink)
|
|
The Frequenter
Join Date: Sep 2007
Posts: 360
Thanks: 24
|
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
|
|
|
|