Determination and decomposition of Paradigm

Project No., material no., start date, completion date, price P1 11 4 9805 9902 250 P1 12 6 9805 9902 300 P1 13 15 9805 9902 180 P2 11 6 9811 9912 250 P2 1418 9811 9912 350 For example, the relational r is the nth paradigm? Is there an operation exception? If yes , Then it is divided into high-level paradigm. Is it possible to break down the completed high-level paradigm? Avoid operation exceptions in the relationship before decomposition?

 

No keyword is written. Let's just think that the keyword is a project number + material number.
Let me try to answer:

1nf is satisfied, and 2nf is not satisfied: non-primary keywords are not partially dependent on primary keywords.
The operation exception is insert exception and delete exception.

Break down to 2nf (the keyword in brackets ):

(Project No.) Commencement Date completion date
P1 9805 9902
P2 9811 9912

(Project No., material no.) quantity and price
P1 11 4 250
P1 12 6 300
P1 13 15 180
P2 11 6 250
P2 14 18 350

The above does not meet the 3nf definition: "non-primary keywords do not pass dependencies"
Decomposed into 3nf (the keyword in brackets ):

(Project No.) Commencement Date completion date
P1 9805 9902
P2 9811 9912

(Project No., material no.) Quantity
P1 11 4
P1 12 6
P1 13 15
P2 11 6
P2 14 18

(Quantity of material numbers) price
11 4 250
12 6 300
13 15 180
11 6 250
14 18 350