Answer the question
In order to leave comments, you need to log in
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
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
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 questionAsk a Question
731 491 924 answers to any question