Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 10
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Jan
24
awarded  Notable Question
Oct
28
awarded  Popular Question
May
18
awarded  Curious
Mar
30
awarded  Popular Question
Nov
18
awarded  Popular Question
Mar
7
accepted Move into another table or not?
Mar
7
comment Move into another table or not?
So the only gain is the speed and space, and not a fault in design considerations for normalization .. etc
Mar
7
asked Move into another table or not?
Jan
27
comment Db Design of a Room Booking System
You will get a list of the user's bookings, and through that you can tell what booking has what room .. no!?
Jan
27
comment Db Design of a Room Booking System
@AlexKuznetsov I thought one would check that through code before attempting to write to Database. How would you prevent that at the Db level?
Jan
26
comment Db Design of a Room Booking System
The relationship is: "a user can have zero, one, or more bookings for the same or different rooms, as long as time does not overlap."
Jan
26
comment Db Design of a Room Booking System
Either I am going mad, or missing something so obvious that I'll hate myself for it later, but I just can not see how "we are unable to uniquely identify which room a user has booked when he has booked more than 1 room" :/ As far as I can tell, the diagram allows this easily.
Jan
26
comment Db Design of a Room Booking System
Good catch about the end of a booking @JoelBrown. Thanks. As for showing the FK columns ... I use Entity Framework, and it handles it for me, but since this is about Db Design, I have gone ahead and updated my ERD. Thx
Jan
26
revised Db Design of a Room Booking System
updated erd.
Jan
26
comment Db Design of a Room Booking System
@AlexKuznetsov People are allowed to do that (e.g. book Picaso Room for 10:00, then make another booking for Picaso room for 15:00)
Jan
26
comment Db Design of a Room Booking System
@WigglerJtag Can you please elaborate on what you mean? As far as I can tell, people can make a booking for different rooms, as long as time of booking isn't exactly same.
Jan
24
asked Db Design of a Room Booking System
Nov
14
accepted Does my ERD account for my business logic
Nov
14
comment Does my ERD account for my business logic
Ahh I see, that is not what I understood at all! May I ask what program you're using to draw your ERDs?
Nov
13
comment Does my ERD account for my business logic
Hi Joel, I have updated the ER Diagram once more. This what you mean correct? But I have a question, wouldn't this design create many records in the RECIPIENT table that contain mostly similar information in certain columns?