How to map multivariate attributes?

Asked

Viewed 509 times

0

I am trying to map this conceptual model to the logical, but I have doubts about how to map the multivariate attribute "palavra_chave" that will allow the registration of as many keywords as the user wants. Do I have to create another table? How do primary and foreign keys look?

modelo_conceitual

sql database modeling attributes

2 answers

1

For your data model to be in first normal form (1FN) it is necessary that the attributes are atomic, that is, they cannot be multivariate. Note that there are Dbms that allow the use of multivariate attributes but, in this case, analyze very carefully to not have future problems. Follow the tip from Melanie.

0


I would make a new table for these keywords. It would be:

Tabela

note that P is Primary Key, F Foreign Key, the red asterisk is null (mandatory).

Browser other questions tagged sql database modeling attributes

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