V
V
Vladimir Golub2015-04-01 05:40:54
MySQL
Vladimir Golub, 2015-04-01 05:40:54

Bringing the price table to 3 normal form?

There is a table in it containing prices for products.
id price - the primary key of the table
id type print - the foreign key
id category - the foreign key
id paper - the foreign key
id format - the foreign key
price - the numeric value of the price
max quantity - the maximum value to order at this price
min quantity - the minimum value to order at this price this price
there is a time for the quantity to order. That is, the price field also depends on them. And it is not part of the primary key.
To create one more table with these intervals or to leave as is?
I read on Habré that 3 NF is not always respected.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alzasr, 2015-04-01
@Alzasr

Data normalization is a spherical horse in a vacuum. In practice, data denormalization is often specifically resorted to to optimize and simplify queries. Here is the link Denormalize Data

A
Artyom Karetnikov, 2015-04-02
@art_karetnikov

Are all fields int and float? There is no need to normalize anything, everything is fine with you. Indexes on the necessary queries and that's it.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question