I'm not very proficient at applying OOD logic to Database tables in order to normalize them. Was hoping to get some help with someone more experienced than myself.
Here is what I have so far ( Tables are underlined)
I don't want to try to explain the relationships ... the person that can tell me if I'm on the right track of if there is a better approach won't need me to haha. Thanks
Here is what I have so far ( Tables are underlined)
Code:
[u][COLOR=red]User[/color][/u]
[COLOR=blue]AutoNumber[/color] userID
[COLOR=blue]Text[/color] userName
[COLOR=blue]Text[/color] password
[COLOR=blue]Text[/color] nickname
[COLOR=blue]Yes/No[/color] isAdministrator
[u][COLOR=red]Channel[/color][/u]
[COLOR=blue]AutoNumber[/color] channelID
[COLOR=blue]Text[/color] channelName
[COLOR=blue]Text[/color] password
[COLOR=blue]Yes/No[/color] requiresPassword
[u][COLOR=red]Moderators[/color][/u]
[COLOR=blue]Number[/color] channelID
[COLOR=blue]Number[/color] userID
[u][COLOR=red]Users[/color][/u]
[COLOR=blue]Number[/color] channelID
[COLOR=blue]Number[/color] userID
I don't want to try to explain the relationships ... the person that can tell me if I'm on the right track of if there is a better approach won't need me to haha. Thanks