Changes between Version 34 and Version 35 of Нормализација и подобрувања на дизајнот


Ignore:
Timestamp:
09/15/25 12:40:07 (4 days ago)
Author:
201205
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Нормализација и подобрувања на дизајнот

    v34 v35  
    2828!TransactionId  -> !RequestId, !BorrowerId, !LenderId, !InventoryId, !BorrowDate, !ReturnDate, !BorrowDuration
    2929
    30 !SwapId -> !TransactionId1, !TransactionId2
     30!SwapId -> TransactionId1, TransactionId2
    3131
    3232!ReviewId -> !TransactionId, !ReceiverId, !GiverId, Rating, !ReviewerComment, !ReviewDate
    … …  
    4545**Лево**: BookISBNId, !GenreId, !WishId, !SwapId, !ReviewId, !ReportId, !NotificationId
    4646
    47 **Десно**: !FirstName, !LastName, Password, City, Neighborhood, Bio, Quote, Title, Author, Language, !ImageURL, ISBN, Genre, Availability, Condition, Priority, !RequestStatus, !RequestDate, !BorrowDate, !ReturnDate, !BorrowDuration, Rating, !ReviewerComment, !ReviewDate, !MsgTime, !MsgDate, !MessageContent ,!DateCreated, !FriendshipStatus, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity, Type, !NotifTime, !NotifDate, Description, !NotificationStatus, !RequesterId, !OwnerId, !BorrowerId, !LenderId, !TransactionId1, !TransactionId2, !ReceiverId, !GiverId, !MsgSenderId, !MsgReceiverId, !FriendshipSenderId, !FriendshipReceiverId, !ReportedUserId, !ReportingUserId
     47**Десно**: !FirstName, !LastName, Password, City, Neighborhood, Bio, Quote, Title, Author, Language, ImageURL, ISBN, Genre, Availability, Condition, Priority, !RequestStatus, !RequestDate, !BorrowDate, !ReturnDate, !BorrowDuration, Rating, !ReviewerComment, !ReviewDate, !MsgTime, !MsgDate, !MessageContent ,!DateCreated, !FriendshipStatus, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity, Type, !NotifTime, !NotifDate, Description, !NotificationStatus, !RequesterId, !OwnerId, !BorrowerId, !LenderId, TransactionId1, TransactionId2, !ReceiverId, !GiverId, !MsgSenderId, !MsgReceiverId, !FriendshipSenderId, !FriendshipReceiverId, !ReportedUserId, !ReportingUserId
    4848
    4949**Од двете страни**: !UserId, Email, Username, !BookId, !InventoryId, !RequestId, !TransactionId, !MessageId, !FriendshipId
    … …  
    5353
    5454
    55 BookISBNId += {!BookId, ISBN, Title, Author, Language, !ImageURL}
    56 
    57 Не ги содржи сите атрибути
    58 
    59 !GenreId += {!BookId, Genre, Title, Author, Language, !ImageURL}
     55BookISBNId += {!BookId, ISBN, Title, Author, Language, ImageURL}
     56
     57Не ги содржи сите атрибути
     58
     59!GenreId += {!BookId, Genre, Title, Author, Language, ImageURL}
    6060
    6161Не ги содржи сите атрибути
    … …  
    6565Не ги содржи сите атрибути
    6666
    67 !SwapId += {!TransactionId1, !TransactionId2, !RequestId, !BorrowerId, !LenderId, !InventoryId, !BorrowDate, !ReturnDate, !BorrowDuration, !FirstName, !LastName, Email, Username, Password, City, Neighborhood, Bio, Quote, Availability, Condition, !BookId, Title, Author, Language, !ImageURL}
     67!SwapId += {TransactionId1, TransactionId2, !RequestId, !BorrowerId, !LenderId, !InventoryId, !BorrowDate, !ReturnDate, !BorrowDuration, !FirstName, !LastName, Email, Username, Password, City, Neighborhood, Bio, Quote, Availability, Condition, !BookId, Title, Author, Language, !ImageURL}
    6868
    6969Не ги содржи сите атрибути
    … …  
    9090                !FirstName, !LastName, Email, Username, Password, City, Neighborhood, Bio, Quote,
    9191                 !UserId, Availability, Condition,
    92                  Title, Author, Language, !ImageURL}
     92                 Title, Author, Language, ImageURL}
    9393               
    9494Не ги содржи сите атрибути
    … …  
    138138        !RequesterId, !OwnerId, **!BookId**, !RequestStatus, !RequestDate,
    139139        Availability, Condition,
    140         ISBN, Genre, !UserId, Priority, !TransactionId1, !TransactionId2,
     140        ISBN, Genre, !UserId, Priority, TransactionId1, TransactionId2,
    141141        !ReportedUserId, !ReportingUserId, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity, 
    142142         !MessageId, !FriendshipId, Type, !NotifTime, !NotifDate, Description, !NotificationStatus,
    … …  
    144144         !FriendshipSenderId, !FriendshipReceiverId, !DateCreated, !FriendshipStatus}
    145145
    146 R2 е се уште во 2НФ поради останатите парцијални зависности. Една од нив е !UserId -> FirstName. За да го решиме ова, ќе го ставиме !UserId во посебна релација R3, заедно со сите атрибути поврзани со него, а сите останати атрибути ги пренесуваме во R4, заедно со !UserId како заеднички атрибут.
     146R2 е се уште во 2НФ поради останатите парцијални зависности. Една од нив е !UserId -> !FirstName. За да го решиме ова, ќе го ставиме !UserId во посебна релација R3, заедно со сите атрибути поврзани со него, а сите останати атрибути ги пренесуваме во R4, заедно со !UserId како заеднички атрибут.
    147147
    148148----
    … …  
    163163        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    164164        Availability, Condition,
    165         ISBN, Genre, **!UserId**, Priority, !TransactionId1, !TransactionId2,
     165        ISBN, Genre, **!UserId**, Priority, TransactionId1, TransactionId2,
    166166        !ReportedUserId, !ReportingUserId, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity, 
    167167         !MessageId, !FriendshipId, Type, !NotifTime, !NotifDate, Description, !NotificationStatus,
    … …  
    181181        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    182182        Availability, Condition,
    183         Genre, !UserId, Priority, !TransactionId1, !TransactionId2,
     183        Genre, !UserId, Priority, TransactionId1, TransactionId2,
    184184        !ReportedUserId, !ReportingUserId, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity, 
    185185         !MessageId, !FriendshipId, Type, !NotifTime, !NotifDate, Description, !NotificationStatus,
    … …  
    199199        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    200200        Availability, Condition,
    201         !UserId, Priority, !TransactionId1, !TransactionId2,
     201        !UserId, Priority, TransactionId1, TransactionId2,
    202202        !ReportedUserId, !ReportingUserId, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity, 
    203203         !MessageId, !FriendshipId, Type, !NotifTime, !NotifDate, Description, !NotificationStatus,
    … …  
    215215        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    216216        Availability, Condition,
    217         !UserId, Priority, !TransactionId1, !TransactionId2,
     217        !UserId, Priority, TransactionId1, TransactionId2,
    218218        !ReportedUserId, !ReportingUserId, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity, 
    219219         !MessageId, !FriendshipId, Type, !NotifTime, !NotifDate, Description, !NotificationStatus,
    … …  
    231231        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    232232        Availability, Condition,
    233         !UserId, Priority, !TransactionId1, !TransactionId2,
     233        !UserId, Priority, TransactionId1, TransactionId2,
    234234         !MessageId, !FriendshipId, Type, !NotifTime, !NotifDate, Description, !NotificationStatus,
    235235        !MsgSenderId, !MsgReceiverId, !MsgTime, !MsgDate, !MessageContent,
    … …  
    246246        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    247247        Availability, Condition,
    248         !UserId, Priority, !TransactionId1, !TransactionId2,
     248        !UserId, Priority, TransactionId1, TransactionId2,
    249249         !MessageId, !FriendshipId,
    250250        !MsgSenderId, !MsgReceiverId, !MsgTime, !MsgDate, !MessageContent,
    … …  
    261261        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    262262        Availability, Condition,
    263         !UserId, Priority, !TransactionId1, !TransactionId2,
     263        !UserId, Priority, TransactionId1, TransactionId2,
    264264         !MessageId, !FriendshipId,
    265265        !MsgSenderId, !MsgReceiverId, !MsgTime, !MsgDate, !MessageContent,
    … …  
    275275        !RequestId,  **!InventoryId**,
    276276        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    277         !UserId, Priority, !TransactionId1, !TransactionId2,
     277        !UserId, Priority, TransactionId1, TransactionId2,
    278278         !MessageId, !FriendshipId,
    279279        !MsgSenderId, !MsgReceiverId, !MsgTime, !MsgDate, !MessageContent,
    … …  
    289289        !RequestId,  !InventoryId,
    290290        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    291         !UserId, !TransactionId1, !TransactionId2,
     291        !UserId, TransactionId1, TransactionId2,
    292292         !MessageId, !FriendshipId,
    293293        !MsgSenderId, !MsgReceiverId, !MsgTime, !MsgDate, !MessageContent,
    … …  
    303303        !RequestId,  !InventoryId,
    304304        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    305         !UserId, !TransactionId1, !TransactionId2,
     305        !UserId, TransactionId1, TransactionId2,
    306306         **!MessageId**, !FriendshipId,
    307307         !FriendshipSenderId, !FriendshipReceiverId, !DateCreated, !FriendshipStatus}
    … …  
    316316        !RequestId,  !InventoryId,
    317317        !RequesterId, !OwnerId, !BookId, !RequestStatus, !RequestDate,
    318         !UserId, !TransactionId1, !TransactionId2,
     318        !UserId, TransactionId1, TransactionId2,
    319319         !MessageId, **!FriendshipId**}
    320320
    321321----
    322322
    323 R25 = {**!RequestId**, !RequesterId, !OwnerId,, !RequestStatus, !RequestDate}
     323R25 = {**!RequestId**, !RequesterId, !OwnerId, !RequestStatus, !RequestDate}
    324324
    325325----
    … …  
    328328        **!RequestId**,  !InventoryId,
    329329         !BookId,
    330         !UserId, !TransactionId1, !TransactionId2,
     330        !UserId, TransactionId1, TransactionId2,
    331331         !MessageId, !FriendshipId}
    332332
    333333----
    334334
    335 R27 = { **!SwapId**, !TransactionId1, !TransactionId2 }
     335R27 = { **!SwapId**, TransactionId1, TransactionId2 }
    336336
    337337----
    … …  
    463463**Genre**
    464464
    465 R7 = {**__!GenreId__**, **Genre**}
     465R7 = {**__GenreId__**, **Genre**}
    466466
    467467
    468468**Review**
    469469
    470 R9 = {**__!ReviewId__**, **__!ReceiverId*__**, **__!GiverId*__**, **Rating**, !ReviewerComment, **!ReviewDate**}
     470R9 = {**__ReviewId__**, **__!ReceiverId*__**, **__!GiverId*__**, **Rating**, !ReviewerComment, **!ReviewDate**}
    471471    • !ReceiverId референцира кон !AppUser(!UserId)
    472472    • !GiverId референцира кон !AppUser(!UserId)
    … …  
    494494**!LibraryBook**
    495495
    496 R17 = {**__!InventoryId__**, **Availability**, **Condition**}
     496R17 = {**__InventoryId__**, **Availability**, **Condition**}
    497497
    498498
    499499**!WishlistBook**
    500500
    501 R19 = {**__!WishId__**, Priority}
     501R19 = {**__WishId__**, Priority}
    502502
    503503
    504504**Message**
    505505
    506 R21 = {**__!MessageId__**, **__!MsgSenderId*__**, **__!MsgReceiverId*__**, **!MsgTime**, **!MsgDate**, **!MessageContent**}
     506R21 = {**__MessageId__**, **__!MsgSenderId*__**, **__!MsgReceiverId*__**, **!MsgTime**, **!MsgDate**, **!MessageContent**}
    507507    • !MsgSenderId референцира кон !AppUser(!UserId)
    508508    • !MsgReceiverId референцира кон !AppUser(!UserId)
    … …  
    511511**!FriendRequest**
    512512
    513 R23 = {**__!FriendshipId__**, **__!FriendshipSenderId*__**, **__!FriendshipReceiverId*__**, **!DateCreated**, **!FriendshipStatus**}
     513R23 = {**__FriendshipId__**, **__!FriendshipSenderId*__**, **__!FriendshipReceiverId*__**, **!DateCreated**, **!FriendshipStatus**}
    514514    • !FriendshipSenderId референцира кон !AppUser(!UserId)
    515515    • !FriendshipReceiverId референцира кон !AppUser(!UserId)
    … …  
    517517**!BookRequest**
    518518
    519 R25 = {**__!RequestId__**, **__!RequesterId*__**, **__!OwnerId*__**, **!RequestStatus**, **!RequestDate**}
     519R25 = {**__RequestId__**, **__!RequesterId*__**, **__!OwnerId*__**, **!RequestStatus**, **!RequestDate**}
    520520    • !RequesterId референцира кон !AppUser(!UserId)
    521521    • !OwnerId референцира кон !AppUser(!UserId)
    … …  
    531531R301 = {!BookId*, !GenreId*}
    532532
    533 **!ISBNLink**
     533**ISBNLink**
    534534
    535535R302 = {!BookId*, BookISBNId*}