147 reputation
7
bio website ciwan.info
location Eustis, FL
age 28
visits member for 1 year, 10 months
seen Nov 27 at 13:31

Love Web Development on MVC, but don't know jack ... Yet !


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?
Nov
13
revised Does my ERD account for my business logic
Another update to ER Diagram.
Nov
12
comment Does my ERD account for my business logic
For the CC, BCC and TO lists, what do you suggest? a separate table for each? Wouldn't that be too much?
Nov
12
comment Does my ERD account for my business logic
Thanks Joel, I get it now, and have updated my ERD accordingly. As for the list of available fields, I'll have a list showing all the fields, so that the admin doing the CRUD operations on the emails can see what is available to him or her.
Nov
12
revised Does my ERD account for my business logic
Updated ERD to reflect latest understanding.