Good evening guys, sorry to ask, this is the first database I’m creating, so... I have these 3 related tables, my question is whether I should keep the Customer and Employee Tables weak or leave address as the weak entity.
Which solves the business model in the simplest way ? Client even makes sense to have more than one address , but employee ...
Think the following: address can exist independent of the existence of an employee or a customer? If any address will always be associated with one of the two then it will be a weak entity.
It all depends on how you want to establish the system structure, but think with me. The entity endereçodepends on someone to exist? If your answer is yes, keep it as a weak entity. Otherwise, I advise you to remodel your system.
Which solves the business model in the simplest way ? Client even makes sense to have more than one address , but employee ...
– Motta
Think the following: address can exist independent of the existence of an employee or a customer? If any address will always be associated with one of the two then it will be a weak entity.
– anonimo
It all depends on how you want to establish the system structure, but think with me. The entity
endereço
depends on someone to exist? If your answer is yes, keep it as a weak entity. Otherwise, I advise you to remodel your system.– RXSD