Changes between Version 5 and Version 6 of normalization

Timestamp:

08/31/25 17:15:35 (2 days ago)

Author:

221046

Comment:

--

normalization

@@ -8 +8 @@
 ||'''Artist(artist_id, name)'''||artist_id||artist_id → name||BCNF||
 ||'''Genre(genre_id, name)'''||genre_id||genre_id → name||BCNF||
-||'''MediaType(media_type_id, name)'''||media_type_id||media_type_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 (ако композитен клуч)|| 
+||'''!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 (ако композитен клуч)|| 
 ||'''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||
 ||'''Employee(employee_id, first_name, last_name, title, reports_to, birth_date, hire_date, personal_info_id, contact_id)'''||employee_id||employee_id → {first_name, last_name, title, reports_to, birth_date, hire_date, personal_info_id, contact_id}||BCNF||
-||'''AddressInfo(address_info_id, address, city, state, country, postal_code)'''||address_info_id||address_info_id → {address, city, state, country, postal_code}||BCNF||
+||'''!AddressInfo(address_info_id, address, city, state, country, postal_code)'''||address_info_id||address_info_id → {address, city, state, country, postal_code}||BCNF||
 ||'''Contact(contact_id, phone, fax, email)'''||contact_id||contact_id → {phone, fax, email}||BCNF||
 ||'''Playlist(playlist_id, name)'''||playlist_id||playlist_id → name||BCNF||