Changes between Version 29 and Version 30 of normalization
- Timestamp:
- 09/02/25 22:36:53 (5 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
normalization
v29 v30 42 42 employee_id → title, reports_to, birth_date, hire_date 43 43 44 '''! AddressInfo'''44 '''!PersonalInfo''' 45 45 46 address_info_id → address, city, state, country, postal_code, phone, fax, email46 personal_info_id → address, city, state, country, postal_code, phone, fax, email 47 47 48 48 '''Playlist''' … … 120 120 121 121 122 === 4.9 ! AddressInfo ===122 === 4.9 !PersonalInfo === 123 123 124 ! AddressInfo(address_info_id, address, city, state, country, postal_code, phone, fax, email)125 PK: address_info_id124 !PersonalInfo(personal_info_id, address, city, state, country, postal_code, phone, fax, email) 125 PK: personal_info_id 126 126 127 127 … … 146 146 support_rep_id → Employee е FK, нема транзитивна зависност во Customer. 147 147 148 Адресата е изнесена во ! AddressInfo.148 Адресата е изнесена во !PersonalInfo. 149 149 150 150 Сите не-клучни атрибути зависат директно од клучевите.
