Changes between Version 33 and Version 34 of normalization

Timestamp:

09/04/25 08:42:26 (41 hours ago)

Author:

221046

Comment:

--

normalization

@@ -59 +59 @@
 
 '''Примарен клуч (на !BaseRelation):'''
-(invoice_line_id, playlist_track_id)
+
+(invoice_line_id, playlist_track_id)→ (track_id, name, album_id, artist_id, media_type_id, genre_id, composer,
+milliseconds, bytes, price_id, value, date,, invoice_id, quantity,
+customer_id, first_name, last_name, company, support_rep_id, personal_info_id, contact_id,
+employee_id, title, reports_to, birth_date, hire_date,
+address_info_id, address, city, state, country, postal_code, phone, fax, email,
+playlist_id, playlist_name)
+
 (секој ред е уникатен по комбинацијата на фактурна линија и песна во плејлиста).
+
+**(invoice_line_id, playlist_track_id)** 
 
 == 4. Втора нормална форма (2NF) ==