Doubt Basic Relationship

Asked

Viewed 34 times

0

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.inserir a descrição da imagem aqui

  • 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ç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.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.