Re: business users services

[Dimitris Papageorgiou]

Peter Brawley Wrote:
-------------------------------------------------------
> > the b_user column of the busers_services table
> will have the same value for 3 rows
>
> The relational model tries to minimise redundant
> representation, not recurring real world data.
> What you describe is the latter, not the former.
> Not an issue.
>
I got that.

> > Two different B_users may offer the same
> service
>
> Again, if you analyse such issues from Codd's
> relational the point of view, the most efficient
> way to represent such facts is to store keys that
> point to the data that recurs, which is what
> bridge tables like busers_services so efficiently
> do.

Regarding the above there are two issues that must be addressed...which come in contrast with what you say above-partly,cause a bridge table is still going to be needed.
The user is asked to enter his service.There is a case where the same service can be written differently,that means that the ServiceID can correspond only to one service plus that very service is priced differently from every Business user.
So despite 2 hair salons offering a haircut(same service) this must point to a different ServiceID.

Let us focus on this for now.Do you agree that every service must point to a unique serviceID even if the services provided are the same?