Changes between Version 2 and Version 3 of Normalization012


Ignore:
Timestamp:
09/04/25 12:33:49 (8 weeks ago)
Author:
201205
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization012

    v2 v3  
    99
    1010!UserId -> !FirstName, !LastName, Email, Username, Password, City, Neighborhood, Bio, Quote
    11 Email -> !UserId, !FirstName, !LastName, Username, Password, City, Neighborhood, Bio, Quote
    12 Username -> !UserId, !FirstName, !LastName, Email, Password, City, Neighborhood, Bio, Quote
    1311
    1412!BookId -> Title, Author, Language, !ImageURL
    … …  
    4644!RequestId -> !NotificationId, !BR_Description
    4745
    48 
    49 
    50 === ===
    51 
    52 **Лево:** !BookISBNId, !GenreId, !WishId, !SwapId, !ReviewId, !ReportId
    53 
    54 **Десно:** !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
    55 
    56 **Од двете страни:** !UserId, Email, Username, !BookId, !InventoryId, !RequestId, !TransactionId, !MessageId, !FriendshipId, !NotificationId, !TransactionId, !MessageId, !FriendRequestId, !BookRequestId
    57 
    58 === ===
    59 
    60 
    61 BookISBNId+={BookId, ISBN, Title, Author, Language, ImageURL}
    62         Не ги содржи сите атрибути
    63 
    64 GenreId+={BookId, Genre, Title, Author, Language, ImageURL}
    65         Не ги содржи сите атрибути
    66 
    67 WishId+={UserId, Priority, BookId, Title, Author, Language, ImageURL, FirstName, LastName, Email, Username, Password, City, Neighborhood, Bio, Quote}
    68         Не ги содржи сите атрибути
    69 
    70 SwapId+={TransactionId, RequestId, UserId, InventoryId, BorrowDate, ReturnDate, BorrowDuration,  BookId, RequestStatus, RequestDate, FirstName, LastName, Email, Username, Password, City, Neighborhood, Bio, Quote, Availability, Condition, Title, Author, Language, ImageURL}
    71         Не ги содржи сите атрибути
    72 
    73 ReviewId+={TransactionId, UserId, Rating, ReviewerComment, ReviewDate,  RequestId, InventoryId, BorrowDate, ReturnDate, BorrowDuration, FirstName, LastName, Email, Username, Password, City, Neighborhood, Bio, Quote, BookId, RequestStatus, RequestDate, Availability, Condition, Title, Author, Language, ImageURL}
    74         Не ги содржи сите атрибути
    75 
    76 ReportId+={UserId, ReportType, ReportDate, Details, ReportStatus, ReportedEntity, FirstName, LastName, Email, Username, Password, City, Neighborhood, Bio, Quote}
    77         Не ги содржи сите атрибути
    78 
    79 
    80 
    81 ReviewId, BookISBNId, GenreId, WishId, SwapId, ReportId = { ReviewId, BookISBNId, GenreId, WishId, SwapId, ReportId,     NotificationId, TransactionId, UserId, Rating, ReviewerComment, ReviewDate, InventoryId, BorrowDate, ReturnDate, BorrowDuration, FirstName, LastName, Email, Username, Password, City, Neighborhood, Bio, Quote, Availability, Condition, BookId, Title, Author, Language, ImageURL, ISBN, Genre, Priority, ReportType, ReportDate, Details, ReportStatus, ReportedEntity,    MessageId, FriendshipId, RequestId, Type, NotifTime, NotifDate, NotificationStatus, MsgTime, MsgDate, MessageContent, DateCreated, FriendshipStatus,  RequestStatus, RequestDate,  TN_Description, MN_Description, FR_Description, BR_Description}
    82 
    83 Следува дека е единствен кандидат клуч и го прогласуваме за примарен клуч.
    84 
    8546=== ===
    8647