Geek asks and answers

Normalization h / w

enter image description here

It has been said to be included in UNF / 1NF / 2NF / 3NF, is this correct?

Show the given data as a relation in UNF (abnormalized data).

Customer (CustomerID, FirstName, LastName, Address, City, Phone, State, Postcode, Qty, ProductNo, Description, Unit Price, Total, Total, Shipment, Tax Rate, Date, Order No.)

Show data as a ratio / s in 1NF. (Specify any keys.)

Customer (CustomerID, FirstName, LastName, Address, City, State, Phone, State, Postcode) Product (ProductNo, Qty, Description, Unitprice, total, subtotal, shipping, Tax rate (s), CustomerID (FK).) Order ( OrderNo, Date, ProductNo (FK).)

Show data as a ratio / s in 2NF. (Specify any keys.)

(CustomerID, FirstName, LastName, Address, City, Phone, State, Postcode) (ProductNo, Qty, Description, UnitPrice, CustomerID (FK), Total (FK).) (OrderNo, Date, CustomerID (FK), ProductNo (FK).) (, , , , (FK), CustomerID (FK))

/s 3NF. ( .)

(CustomerID, FirstName, LastName, Address, City, Phone, State, Postcode) (ProductNo, , . CustomerID (FK), Total (FK)) (OrderNo, Date, CustomerID (FK).ProductNo(FK)) (, , ProductNo (FK), CustomerID (FK)) (, , (FK), OrderNo (FK)) Qty (QtyID, Qty, ProductNo (FK), OrderNo (FK).)

+5
3

UNF ( ).

(CustomerID, FirstName, LastName, , , , , , -, , , , , , , , , №.))

, . - . . , , "", .

/s 1NF. ( .)

  • (CustomerID, FirstName, LastName, Address, City, state, , , ).
  • (ProductNo, Qty, Description, Unitprice, , , , (-), CustomerID (FK).)
  • (OrderNo, Date, ProductNo (FK).)

. (. .) , - "" "ProductNo". , "CustomerID"?

/s 2NF. ( .)

  • (CustomerID, FirstName, LastName, Address, City, Phone, State, Postcode)
  • (ProductNo, Qty, Description, UnitPrice, CustomerID (FK), Total (FK).)
  • (OrderNo, Date, CustomerID (FK), ProductNo (FK).)
  • (, , , , ProductNo (FK), CustomerID (FK))

2NF . , ""? (: .) ( SQL): "Total" "", , ?

, . , - . , 3NF.

0

, . - , ( , :)).

+4

An interesting thing on invoices .... J Frompton orders a rake today, but for some time in the future the price will change. However, this does not change the price that Fetpton paid today.

Once invoices are executed, they really need to be moved to a table that is 1NF.

0
source

More articles:


All Articles