DB design for Chat program

[mcox05]

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)

[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

 

[Crowley16]

you can combine the users and moderators link table by including a IsModerator field.

the isAdministrator field assumes that if users are administrators, then they are admins across the whole site, rather than admins just on one channel, is this a sensible assumption?

other minor things:
split the name into forename/surname
maybe you'll want a channel nickname as well, short code in case channel names are long

--------------------
Procrastinate Now!

 

[mcox05]

Thanks for the suggestions