Relationship in tables in the database

Question

Relationship in tables in the database

Asked 6 years, 8 months ago

Viewed 67 times

0

I have a table in the database called Veiculo and it has the following fields: placa, renavam, marca, cor and categoria.

To the placa and renavam is all right, since the data are unique.

My question is about the columns marca, cor and categoria. Today save everything on the table Veiculo and do not relate to other tables. It is necessary and/or recommended, through "good practices", to create a table for marca, another to cor and another to categoria and only refer to the respective ID on the table Veiculo?

The database behaves better this way, avoiding repeated information?

2

Possible duplicate of What is database normalization?

– Ismael

2017/10/24 at 16:35
2

And one here It can be considered a bad modeling practice to store all people (customers, employees, suppliers) in the same table?

– Ismael

2017/10/24 at 16:37
1

Or even this one: https://answall.com/questions/22069/quando%C3%A9-interesting-denormalize-the-database

– perozzo

2017/10/24 at 16:45
Possible duplicate of When it is interesting to denormalize the database?

– perozzo

2017/10/24 at 16:47

1 answer

Browser other questions tagged sql database sql-server

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

by rbz • **9,949** points · Answer 1 · 2017-10-24T16:33:28+00:00

Yes, better relate tables by agilidade and mainly economia de espaço.

For example: All registro of a car "black" you will have 5 caracteres correct ?

If you have a tabela relacionada, would only be the chave (I believe 99 colors is muuuuuita color, so only 99 = 2 characters).

Also at the time of consulta, the more data the greater the processamento.

Basically that’s it.