-
Oct 23rd, 2018, 04:41 AM
#1
Thread Starter
Junior Member
-
Oct 23rd, 2018, 06:54 AM
#2
Re: Entity relationship diagrams
I'll be honest... something doesn't feel right about it... but I don't know that I can pin point or articulate what it is. Call it gut instinct.
Actually, I think what I'd do is reduce the number of entities...
Member, Booking, Staff ... Member and Staff should be self-evident as to what they are. Booking then would have a Type that would indicate if it's a Class, PT, or Sports Hall .... All bookings should be pretty much the same, they are going to have a title, a start time, end time, 0 or more instructors, and 1 or more members, and maybe a few more bits of information.
Be careful how you actually build your classes though... don't build them in a way that will allow for endless chaining... where you go Member.Bookings(0).Members(0).Bookings(1).Staff(0).Bookings(0)..... and so on... I've seen it done and it will create rabbit holes you really don't want to follow.
-tg
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|