Changes between Version 25 and Version 26 of normalization

Timestamp:

09/02/25 22:29:42 (5 hours ago)

Author:

221046

Comment:

--

normalization

@@ -42 +42 @@
 employee_id → title, reports_to, birth_date, hire_date
 
-'''AddressInfo'''
+'''!AddressInfo'''
 
 address_info_id → address, city, state, country, postal_code, phone, fax, email
@@ -50 +50 @@
 playlist_id → playlist_name
 
-'''PlaylistTrack'''
+'''!PlaylistTrack'''
 
 playlist_track_id → playlist_id, track_id
@@ -120 +120 @@
 
 
-=== 4.9 AddressInfo ===
+=== 4.9 !AddressInfo ===
 
-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)
 PK: address_info_id
 
@@ -132 +132 @@
 
 
-=== 4.11 PlaylistTrack ===
+=== 4.11 !PlaylistTrack ===
 
-PlaylistTrack(playlist_track_id, playlist_id, track_id)
+!PlaylistTrack(playlist_track_id, playlist_id, track_id)
 PK: playlist_track_id
 FK: playlist_id → Playlist(playlist_id)
@@ -146 +146 @@
 support_rep_id → Employee е FK, нема транзитивна зависност во Customer.
 
-Адресата е изнесена во AddressInfo.
+Адресата е изнесена во !AddressInfo.
 
 Сите не-клучни атрибути зависат директно од клучевите.
@@ -171 +171 @@
 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)
 
-PlaylistTrack(playlist_track_id, playlist_id, track_id)
+!PlaylistTrack(playlist_track_id, playlist_id, track_id)