Changes between Version 10 and Version 11 of normalization


Ignore:
Timestamp:
08/31/25 17:38:44 (2 days ago)
Author:
221046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • normalization

    v10 v11  
    99||'''Genre(genre_id, name)'''||genre_id||genre_id → name||BCNF||
    1010||'''!MediaType(media_type_id, name)'''||media_type_id||media_type_id → name||BCNF||
    11 ||'''Price(price_id, value, date, track_id)'''||price_id||price_id → {value, date, track_id}||BCNF (ако price_id е surrogate key)||
     11||'''Price(price_id, value, date, track_id)'''||price_id||price_id → {value, date, track_id}||BCNF||
    1212||'''!InvoiceLine(invoice_line_id, invoice_id, track_id, quantity)'''||invoice_line_id (и можен (invoice_id, track_id))||(invoice_line_id → {invoice_id, track_id, quantity})||BCNF||
    1313||'''Invoice(invoice_id, customer_id, invoice_date, billing_address, billing_city, billing_state, billing_country, billing_postal_code, total)'''||invoice_id||invoice_id → {customer_id, invoice_date, billing_address, billing_city, billing_state, billing_country, billing_postal_code, total}||BCNF||