Changes between Version 14 and Version 15 of Normalization
- Timestamp:
- 01/15/26 06:39:27 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v14 v15 519 519 || '''R1''' (Product) || productId, product_name, product_description, product_sku, product_unit_price, product_reorder_level, categoryId, supplierId || productId || 520 520 || '''R2''' (Sale) || saleId, sale_date_time, sale_total_amount, userId, customerId, warehouseId || saleId || 521 || '''R3''' ( PurchaseOrder) || poId, po_order_date, po_expected_delivery_date, po_status, supplierId, warehouseId || poId ||522 || '''R4''' ( SaleItem) || saleId, productId, saleitem_quantity, saleitem_unit_price_at_sale || {saleId, productId} ||523 || '''R5''' ( PurchaseOrderItem) || poId, productId, poitem_quantity, poitem_unit_cost || {poId, productId} ||521 || '''R3''' (!PurchaseOrder) || poId, po_order_date, po_expected_delivery_date, po_status, supplierId, warehouseId || poId || 522 || '''R4''' (!SaleItem) || saleId, productId, saleitem_quantity, saleitem_unit_price_at_sale || {saleId, productId} || 523 || '''R5''' (!PurchaseOrderItem) || poId, productId, poitem_quantity, poitem_unit_cost || {poId, productId} || 524 524 || '''R6''' (User) || userId, user_username, user_password, user_full_name, user_email, user_role, user_is_active || userId || 525 525 || '''R7''' (Customer) || customerId, customer_name, customer_email, customer_phone, customer_address || customerId || … … 527 527 || '''R9''' (Supplier) || supplierId, supplier_name, supplier_contact_person, supplier_phone, supplier_email, supplier_address || supplierId || 528 528 || '''R10''' (Warehouse) || warehouseId, warehouse_name, warehouse_location, warehouse_capacity || warehouseId || 529 || '''R11''' ( WarehouseStock) || warehouseId, productId, stock_quantity_on_hand, stock_last_updated || {warehouseId, productId} ||529 || '''R11''' (!WarehouseStock) || warehouseId, productId, stock_quantity_on_hand, stock_last_updated || {warehouseId, productId} || 530 530 531 531 ---- … … 552 552 '''R2 е во BCNF''' ✓ 553 553 554 ==== R3 ( PurchaseOrder) ====554 ==== R3 (!PurchaseOrder) ==== 555 555 556 556 ||= FD =||= Детерминант =||= Суперклуч? =|| … … 559 559 '''R3 е во BCNF''' ✓ 560 560 561 ==== R4 ( SaleItem) ====561 ==== R4 (!SaleItem) ==== 562 562 563 563 ||= FD =||= Детерминант =||= Суперклуч? =|| … … 566 566 '''R4 е во BCNF''' ✓ 567 567 568 ==== R5 ( PurchaseOrderItem) ====568 ==== R5 (!PurchaseOrderItem) ==== 569 569 570 570 ||= FD =||= Детерминант =||= Суперклуч? =|| … … 610 610 '''R10 е во BCNF''' ✓ 611 611 612 ==== R11 ( WarehouseStock) ====612 ==== R11 (!WarehouseStock) ==== 613 613 614 614 ||= FD =||= Детерминант =||= Суперклуч? =||
