Changes between Version 3 and Version 4 of normalization

Timestamp:

08/31/25 17:12:35 (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); 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 (ако композитен клуч)|| 
 ||'''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, address, city, state, country, postal_code, phone, fax, email)'''||customer_id||customer_id → {first_name, last_name, company, support_rep_id, address, city, state, country, postal_code, phone, fax, email}||BCNF||
-||'''Employee(employee_id, first_name, last_name, title, reports_to, birth_date, hire_date, address, city, state, country, postal_code, phone, fax, email)'''||employee_id||employee_id → {first_name, last_name, title, reports_to, birth_date, hire_date, address, city, state, country, postal_code, phone, fax, email}||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||
+||'''Contact(contact_id, phone, fax, email)'''||contact_id||contact_id → {phone, fax, email}||BCNF||
 ||'''Playlist(playlist_id, name)'''||playlist_id||playlist_id → name||BCNF||
 ||'''PlaylistTrack(playlist_track_id, playlist_id, track_id)'''||playlist_track_id (и можен (playlist_id, track_id))||playlist_track_id → {playlist_id, track_id}; (playlist_id, track_id) → playlist_track_id||BCNF||
 
 == Заклучок ==
-  * Сите релации се барем во **3-та нормална форма (3NF)**.
- 
+  * Сите релации се барем во 3-та нормална форма (3NF).
+  * Повеќето се дури во **BCNF**.
+  * Price – нова теабела која ни овозможува чување на историј на цени.  
+  * Новите табели **AddressInfo** и **Contact** овозможуваат отстранување на повторувања на адреси и контакти → уште почиста нормализација.