Changes between Version 3 and Version 4 of Нормализација и подобрувања на дизајнот на базата
- Timestamp:
- 04/28/25 15:22:41 (3 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Нормализација и подобрувања на дизајнот на базата
v3 v4 3 3 '''Functional Dependencies:''' 4 4 5 UserID Name Surename Email Password PhoneNumber DataJoined 6 1 Stefani Jovanoska Sjovanoska@gmail.com Sjovanoska123! 078123123 27.4.2025 7 2 Stefani Jovanoska Sjovanoska123@gmail.com Sjovanoska123!!! 078123321 27.4.2025 5 || UserID || Name || Surname || Email || Password || PhoneNumber || DataJoined || 6 || 1 || Stefani Jovanoska || Sjovanoska@gmail.com || Sjovanoska123! || 078123123 || 27.4.2025 || 7 || 2 || Stefani Jovanoska || Sjovanoska123@gmail.com || Sjovanoska123!!! || 078123321 || 27.4.2025 || 8 8 9 9 R = { UserID, Name, Surname, Email, Password, PhoneNumber, DateJoined } … … 38 38 39 39 40 DestinationID Name Country Description PopularAttraction BestTimeToVisit 41 1 Skopje Macedonia Short flight Old town Spring 42 2 Ohrid Macedonia Short flight The Lake Summer 40 || DestinationID || Name || Country || Description || PopularAttraction || BestTimeToVisit || 41 || 1 || Skopje || Macedonia || Short flight || Old town || Spring || 42 || 2 || Ohrid || Macedonia || Short flight || The Lake || Summer || 43 43 44 44 … … 62 62 63 63 64 AirportId Name City Country Code 65 1 Aleksandar Veliki Skopje MAcedonia 1234 66 1 Apostol Pavle Ohrid Macedonia 2345 64 || AirportId || Name || City || Country || Code || 65 || 1 || Aleksandar Veliki || Skopje || Macedonia || 1234 || 66 || 1 || Apostol Pavle || Ohrid || Macedonia || 2345 || 67 67 68 68 … … 93 93 94 94 95 BookingID UserID FlightID BookingDate PaymentStatus TotalCost SeatNumber 96 1 1 1 1.1.2025 Ok 10000 1 97 2 2 2 1.2.2025 Ok 100 2 95 || BookingID || UserID || FlightID || BookingDate || PaymentStatus || TotalCost || SeatNumber || 96 || 1 || 1 || 1 || 1.1.2025 || Ok || 10000 || 1 || 97 || 2 || 2 || 2 || 1.2.2025 || Ok || 100 || 2|| 98 98 99 R = { BookingID, UserID, FlightID, BookingDate, PaymentStatus, TotalCost, SeatNumber } 99 100 Функциски зависности: … … 109 110 110 111 111 ReviewID UserID TargetID ReviewComment Rating Date 112 1 1 1 ок 5 1.1.2025 113 2 2 2 ок 5 1.2.2025 114 112 || ReviewID || UserID || TargetID || ReviewComment || Rating || Date || 113 || 1 || 1 || 1 || ок || 5 || 1.1.2025 || 114 || 2 || 2 || 2 || ок || 5 || 1.2.2025 || 115 115 116 116 R = { ReviewID, UserID, TargetID, ReviewComment, Rating, Date } … … 127 127 Payment Нормализација : 128 128 129 PaymentID BookingID UserID PaymentMethod Amount TransactionDate PaymentStatus 130 1 1 1 card 10000 1.2.2025 ok 131 2 2 2 card 100 1.2.2025 ok 132 129 || PaymentID || BookingID || UserID || PaymentMethod || Amount || TransactionDate || PaymentStatus || 130 || 1 || 1 || 1 || card || 10000 || 1.2.2025 || ok || 131 || 2 || 2 || 2 || card || 100 || 1.2.2025 || ok || 133 132 134 133 … … 146 145 147 146 148 NotificationID UserID Message Type DateSent 149 1 1 ok 1 2.2.2015 150 2 2 ok 2 2.2.2015 147 || NotificationID || UserID || Message || Type|| DateSent || 148 || 1 || 1 || ok || 1 || 2.2.2015 || 149 || 2 || 2 || ok || 2 || 2.2.2015|| 151 150 152 151 … … 163 162 164 163 165 WishlistID UserID TargetID DateAdded 166 1 1 1 2.2.2025 167 2 2 2 2.2.2025 164 || WishlistID || UserID || TargetID || DateAdded || 165 || 1 || 1 || 1 || 2.2.2025 || 166 || 2 || 2 || 2 || 2.2.2025 || 168 167 169 168 … … 181 180 Administrator Нормализација : 182 181 183 AdminID Email 184 1 stefanijovanoska@gmail.com 185 2 Stefani123@gmail.com 182 || AdminID || Email || 183 || 1 || stefanijovanoska@gmail.com || 184 || 2 || Stefani123@gmail.com || 186 185 187 186 … … 198 197 SupportTicket Нормализација: 199 198 200 TicketID UserID Subject Description Status DateCreated DateResolved AssignedTo 201 1 1 Wrong id on the card Need changes waiting 1.2.2015 1.2.2015 Stefani 202 2 2 Wrong id on the card Need changes waiting 1.2.2015 1.2.2015 Stefani 199 || TicketID || UserID || Subject || Description || Status || DateCreated || DateResolved || AssignedTo || 200 || 1 || 1 || Wrong id on the card || Need changes || waiting || 1.2.2015 || 1.2.2015 || Stefani || 201 || 2 || 2 || Wrong id on the card || Need changes || waiting || 1.2.2015 || 1.2.2015 || Stefani || 203 202 204 203 … … 214 213 Табелата SupportTicket е во 1NF, 2NF, 3NF и BCNF. 215 214 215 216
