Changes between Version 24 and Version 25 of normalization
- Timestamp:
- 09/02/25 22:28:15 (5 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
normalization
v24 v25 3 3 4 4 5 ** BaseRelation**(track_id, name, album_id, artist_id, media_type_id, genre_id, composer,5 **!BaseRelation**(track_id, name, album_id, artist_id, media_type_id, genre_id, composer, 6 6 milliseconds, bytes, price_id, value, date, 7 7 invoice_line_id, invoice_id, quantity, … … 58 58 Сите атрибути се атомични → релацијата е во 1NF. 59 59 60 '''Примарен клуч (на Full):'''60 '''Примарен клуч (на !BaseRelation):''' 61 61 (invoice_line_id, playlist_track_id) 62 62 (секој ред е уникатен по комбинацијата на фактурна линија и песна во плејлиста). … … 67 67 68 68 === 4.1 Track === 69 {{{ 69 70 70 Track(track_id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes) 71 71 PK: track_id 72 }}} 72 73 73 74 74 === 4.2 Price === 75 {{{ 75 76 76 Price(price_id, value, date, track_id) 77 77 PK: price_id 78 78 FK: track_id → Track(track_id) 79 }}} 79 80 80 81 81 === 4.3 Album === 82 {{{ 82 83 83 Album(album_id, artist_id) 84 84 PK: album_id 85 85 FK: artist_id → Artist(artist_id) 86 }}} 86 87 87 88 88 === 4.4 Artist === 89 {{{ 89 90 90 Artist(artist_id, artist_name) 91 91 PK: artist_id 92 }}} 92 93 93 94 94 === 4.5 InvoiceLine === 95 {{{ 95 96 96 InvoiceLine(invoice_line_id, invoice_id, track_id, quantity) 97 97 PK: invoice_line_id 98 98 FK: invoice_id → Invoice(invoice_id) 99 99 FK: track_id → Track(track_id) 100 }}} 100 101 101 102 102 === 4.6 Invoice === 103 {{{ 103 104 104 Invoice(invoice_id, customer_id) 105 105 PK: invoice_id 106 106 FK: customer_id → Customer(customer_id) 107 }}} 107 108 108 109 109 === 4.7 Customer === 110 {{{ 110 111 111 Customer(customer_id, first_name, last_name, company, support_rep_id, personal_info_id, contact_id) 112 112 PK: customer_id 113 113 FK: support_rep_id → Employee(employee_id) 114 }}} 114 115 115 116 116 === 4.8 Employee === 117 {{{ 117 118 118 Employee(employee_id, title, reports_to, birth_date, hire_date) 119 119 PK: employee_id 120 }}} 120 121 121 122 122 === 4.9 AddressInfo === 123 {{{ 123 124 124 AddressInfo(address_info_id, address, city, state, country, postal_code, phone, fax, email) 125 125 PK: address_info_id 126 }}} 126 127 127 128 128 === 4.10 Playlist === 129 {{{ 129 130 130 Playlist(playlist_id, playlist_name) 131 131 PK: playlist_id 132 }}} 132 133 133 134 134 === 4.11 PlaylistTrack === 135 {{{ 135 136 136 PlaylistTrack(playlist_track_id, playlist_id, track_id) 137 137 PK: playlist_track_id 138 138 FK: playlist_id → Playlist(playlist_id) 139 139 FK: track_id → Track(track_id) 140 }}} 140 141 141 142 142 == 5. Трета нормална форма (3NF) == … … 150 150 Сите не-клучни атрибути зависат директно од клучевите. 151 151 152 ✅ Сега сите релации се во 3NF.152 Сите релации се во 3NF. 153 153 154 154 == Финален нормализиран модел (3NF) == 155 155 156 {{{ 156 157 157 Track(track_id, name, album_id, media_type_id, genre_id, composer, milliseconds, bytes) 158 158 … … 176 176 177 177 PlaylistTrack(playlist_track_id, playlist_id, track_id) 178 }}} 178 179 179 180 180 ** ← [wiki: Назад на почетна] **
