Changes between Version 9 and Version 10 of normalization

Timestamp:

08/31/25 17:38:30 (2 days ago)

Author:

221046

Comment:

--

normalization

@@ -9 +9 @@
 ||'''Genre(genre_id, name)'''||genre_id||genre_id → name||BCNF||
 ||'''!MediaType(media_type_id, name)'''||media_type_id||media_type_id → name||BCNF||
-||'''Price(price_id, value, date, track_id)'''||price_id||price_id → {value, date, track_id}||BCNF (ако price_id е surrogate); 3NF ако клуч е (track_id, date)|| 
-||'''!InvoiceLine(invoice_line_id, invoice_id, track_id, quantity)'''||invoice_line_id (и можен (invoice_id, track_id))||(invoice_line_id → {invoice_id, track_id, quantity}); (invoice_id, track_id) → quantity||BCNF (со surrogate); 3NF (ако композитен клуч)|| 
+||'''Price(price_id, value, date, track_id)'''||price_id||price_id → {value, date, track_id}||BCNF (ако price_id е surrogate key)|| 
+||'''!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|| 
 ||'''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||
 ||'''Customer(customer_id, first_name, last_name, company, support_rep_id, personal_info_id, contact_id)'''||customer_id||customer_id → {first_name, last_name, company, support_rep_id, personal_info_id, contact_id}||BCNF||