Changes between Version 27 and Version 28 of normalization

Timestamp:

09/02/25 22:34:08 (5 hours ago)

Author:

221046

Comment:

--

normalization

@@ -26 +26 @@
 album_id → artist_id
 
-'''InvoiceLine'''
+'''!InvoiceLine'''
 
 invoice_line_id → invoice_id, track_id, quantity
@@ -92 +92 @@
 
 
-=== 4.5 InvoiceLine ===
+=== 4.5 !InvoiceLine ===
 
-InvoiceLine(invoice_line_id, invoice_id, track_id, quantity)
+!InvoiceLine(invoice_line_id, invoice_id, track_id, quantity)
 PK: invoice_line_id
 FK: invoice_id → Invoice(invoice_id)
@@ -155 +155 @@
 
 
-Track(track_id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes)
+**Track**(track_id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes)
 
-Price(price_id, value, date, track_id)
+**Price**(price_id, value, date, track_id)
 
-Album(album_id, artist_id)
+**Album**(album_id, artist_id)
 
-Artist(artist_id, artist_name)
+**Artist**(artist_id, artist_name)
 
-InvoiceLine(invoice_line_id, invoice_id, track_id, quantity)
+**!InvoiceLine**(invoice_line_id, invoice_id, track_id, quantity)
 
-Invoice(invoice_id, customer_id)
+**Invoice**(invoice_id, customer_id)
 
-Customer(customer_id, first_name, last_name, company, support_rep_id, personal_info_id, contact_id)
+**Customer**(customer_id, first_name, last_name, company, support_rep_id, personal_info_id, contact_id)
 
-Employee(employee_id, title, reports_to, birth_date, hire_date)
+**Employee**(employee_id, title, reports_to, birth_date, hire_date)
 
-!AddressInfo(address_info_id, address, city, state, country, postal_code, phone, fax, email)
+**!AddressInfo**(address_info_id, address, city, state, country, postal_code, phone, fax, email)
 
-Playlist(playlist_id, playlist_name)
+**Playlist**(playlist_id, playlist_name)
 
-!PlaylistTrack(playlist_track_id, playlist_id, track_id)
+**!PlaylistTrack**(playlist_track_id, playlist_id, track_id)
 
 == Финален ЕР Дијаграм ==