Re: business users services
Posted by: Dimitris Papageorgiou
Date: August 04, 2014 09:49AM

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?

Options: ReplyQuote


Subject
Written By
Posted
August 02, 2014 01:02PM
August 03, 2014 04:01PM
Re: business users services
August 04, 2014 09:49AM
August 31, 2014 05:56PM
September 05, 2014 01:22PM
September 25, 2014 04:07PM
August 04, 2014 10:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.