Posted by Alex Kuznetsov on 01/16/07 22:35

Blast wrote:
> I need help modeling schema for a particular issue that i've never run
> across before. And for the life of me, I cannot figure out how to model
> it - at least in a way that feels correct. Please let me know if I need
> to post this else where.
>
> Here are the tables:
>
> Reservation <------------> Customer_Reservation <--------->Customers
>
>
>
> GolfCourses <--------------Customer_Golfing
>
>
> TeeTimes <------------------Customer_TeeTime
>
>
> Ok so here is the business rules. A reservation will be assigned one or
> more customers. A reservation has one or more golfcourses. Golfcourses
> will be assigned people. These people can only come from those people
> assigned to the reservation that the golfcourse belongs to. GolfCourses
> have one or more teetimes. TeeTimes will be assigned people. Those
> people can come from only the people assigned to the golfcourse that
> the teetime belongs to.
>
> Basically, how can I setup the schema to enforce the business rules? I
> can see only to do this at the application level. Maybe I have modeled
> this incorrectly?

You might get more help after you have posted your CREATE TABLE
statements. Make sure your constraints are included.

-----------------------
Alex Kuznetsov
http://sqlserver-tips.blogspot.com/
http://sqlserver-puzzles.blogspot.com/

[Back to original message]