Changes between Version 1 and Version 2 of Normalization


Ignore:
Timestamp:
07/17/25 10:17:08 (15 hours ago)
Author:
226030
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v1 v2  
    164164
    165165  R10 = {pr_id, pr_description, tax_class, pr_price, pr_name, manage_inventory, ca_id, ca_name, ca_is_available, i_quantity, i_restock_level}
    166   R11 = { order_id, oi_id, oi_timestamp, oi_is_processed, oi_price, oi_quantity, pr_id} – OrderItems
     166  R11 = { order_id, oi_id, oi_timestamp, oi_is_processed, oi_price, oi_quantity, pr_id}
    167167Step 5: Decompose R10 by ca_id
    168168  {ca_id}* = {ca_id, ca_name, ca_is_available}