Changes between Version 11 and Version 12 of normalization


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

--

Legend:

Unmodified
Added
Removed
Modified

  • normalization

    v11 v12  
    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||
     11||'''Price(price_id, value, date, track_id)'''||price_id (и можен (date, track_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||