Changes between Version 3 and Version 4 of Normalization


Ignore:
Timestamp:
08/13/25 20:58:33 (3 days ago)
Author:
226030
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v3 v4  
    155155
    156156  order_id -> employee_id, o_timestamp, o_status, table_number, delivery_address, customer_id
     157
    157158  table_number -> seat_capacity
    158159
    159160  R1 is not in BCNF because of transitive dependencies
     161
    160162  {order_id}+ = {order_id, employee_id, o_timestamp, o_status, table_number, delivery_address, customer_id, seat_capacity}
    161163
    … …  
    167169 
    168170  order_id -> employee_id, o_timestamp, o_status, table_number, delivery_address, customer_id
     171
    169172  table_number -> seat_capacity
    170173