106 reputation
2
bio website laminsanneh.com
location Manchester, United Kingdom
age 24
visits member for 1 year, 8 months
seen Jan 23 '13 at 8:29

I love programming problems. And to solve them of-course!


Nov
18
awarded  Student
Nov
17
comment Can someone please give me hints on normalizing this database and any other helpful hints
@GertArnold. The issue is, I have no id column for tables tblChatSessionStarters and tblSessionsTalkers and entity framework model diagram is creating two distinct many-to-many retaionships between tblChatSessions and tblTalkers
Nov
17
comment Can someone please give me hints on normalizing this database and any other helpful hints
@GertArnold. Yes a chatter can only enter one room at a time. He can have many sessions regardless of whether he is in a room or not. Sessions are not related to rooms in anyway. A session can have may chatters and a chatter can have may active sessions. And yes to your other question, once a starter quits, a session is over for now(Not sure why I have that but any recommendations on that would be welcomed). Also as for history of visited chat rooms, I removed that from my logic for simplicity's sake. I am trying to get a basic chat app running for the moment and then add those features.
Nov
17
comment Can someone please give me hints on normalizing this database and any other helpful hints
@JohnSaunders, does that help?
Nov
17
comment Can someone please give me hints on normalizing this database and any other helpful hints
@JohnSaunders, I will post the ddl shortly
Nov
17
comment Can someone please give me hints on normalizing this database and any other helpful hints
@Richard, reposted Picture, is it clearer now.
Nov
17
comment Can someone please give me hints on normalizing this database and any other helpful hints
@John.I have a wcf data contract also called ChatRoom which I dont want conflicts with.
Nov
17
comment Can someone please give me hints on normalizing this database and any other helpful hints
Ok thanks, Richard, I'm on it.
Nov
17
asked Can someone please give me hints on normalizing this database and any other helpful hints
Aug
13
awarded  Autobiographer