Re: business users services

[Dimitris Papageorgiou]

First of all I want to say that you are right,the 3rd table is not redundant as I have adopted a many-to-many relationship.

Now I want to make two important points.
First
Currently the app has one registered business user with 3 services associated with him.
That means that the b_user column of the busers_services table will have the same value for 3 rows,each row indicating with whom b_user a service is associated with.

If for example the above b_user has an ID of 10,this will appear 3 times.
How do you comment this from an efficiency standpoint?Related to the DB of course
Is there a better alternative you think?

Second.
Two different B_users may offer the same service.For example hair salons offering a haircut(something not unusual at all.)
In such a case we might have two or more service_IDs being different but corresponding to the same service.That will occupy unnecessary DB space.
How could I deal with it?

Let us focus on these two for now.