Changes between Version 16 and Version 17 of Normalization

Timestamp:

01/15/26 07:47:18 (12 days ago)

Author:

221181

Comment:

--

Normalization

@@ -231 +231 @@
 
 U1 = U - {product_name, product_description, product_sku, product_unit_price, product_reorder_level}
+
+U1(saleId, poId, productId, userId, user_username, user_password, user_full_name, user_email, user_role, user_is_active, customerId, customer_name, customer_email, customer_phone, customer_address, categoryId, category_name, category_description, supplierId, supplier_name, supplier_contact_person, supplier_phone, supplier_email, supplier_address, warehouseId, warehouse_name, warehouse_location, warehouse_capacity, sale_date_time, sale_total_amount, po_order_date, po_expected_delivery_date, po_status, saleitem_quantity, saleitem_unit_price_at_sale, poitem_quantity, poitem_unit_cost, stock_quantity_on_hand, stock_last_updated)
 }}}
 
@@ -251 +253 @@
 
 U2 = U1 - {sale_date_time, sale_total_amount}
+
+U2(saleId, poId, productId, userId, user_username, user_password, user_full_name, user_email, user_role, user_is_active, customerId, customer_name, customer_email, customer_phone, customer_address, categoryId, category_name, category_description, supplierId, supplier_name, supplier_contact_person, supplier_phone, supplier_email, supplier_address, warehouseId, warehouse_name, warehouse_location, warehouse_capacity, po_order_date, po_expected_delivery_date, po_status, saleitem_quantity, saleitem_unit_price_at_sale, poitem_quantity, poitem_unit_cost, stock_quantity_on_hand, stock_last_updated)
 }}}
 
@@ -269 +273 @@
 
 U3 = U2 - {po_order_date, po_expected_delivery_date, po_status}
+
+U3(saleId, poId, productId, userId, user_username, user_password, user_full_name, user_email, user_role, user_is_active, customerId, customer_name, customer_email, customer_phone, customer_address, categoryId, category_name, category_description, supplierId, supplier_name, supplier_contact_person, supplier_phone, supplier_email, supplier_address, warehouseId, warehouse_name, warehouse_location, warehouse_capacity, saleitem_quantity, saleitem_unit_price_at_sale, poitem_quantity, poitem_unit_cost, stock_quantity_on_hand, stock_last_updated)
 }}}
 
@@ -305 +311 @@
 
 U5 = U4 - {poitem_quantity, poitem_unit_cost}
+
+U5(saleId, poId, productId, userId, user_username, user_password, user_full_name, user_email, user_role, user_is_active, customerId, customer_name, customer_email, customer_phone, customer_address, categoryId, category_name, category_description, supplierId, supplier_name, supplier_contact_person, supplier_phone, supplier_email, supplier_address, warehouseId, warehouse_name, warehouse_location, warehouse_capacity, stock_quantity_on_hand, stock_last_updated)
 }}}
 
@@ -474 +482 @@
 
 U10 = U9 - {warehouse_name, warehouse_location, warehouse_capacity}
+
+U10(saleId, poId, productId, userId, customerId, categoryId, supplierId, warehouseId, stock_quantity_on_hand, stock_last_updated)
 }}}
 
@@ -488 +498 @@
 
 U11 = U10 - {stock_quantity_on_hand, stock_last_updated}
+
+U11(saleId, poId, productId, userId, customerId, categoryId, supplierId, warehouseId)
 }}}