Changes between Initial Version and Version 1 of Normalization002

Timestamp:

09/04/25 11:17:24 (5 days ago)

Author:

201205

Comment:

--

Normalization002

@@ +1 @@
+== Нормализација ==
+
+**Почетна релација:**
+
+R(!UserId, !FirstName, !LastName, Email, Username, Password, City, Neighborhood, Bio, Quote,  !BookId, Title, Author, Language, !ImageURL,  !BookISBNId, ISBN,  !GenreId, Genre,  !InventoryId, Availability, Condition,    !WishId, Priority,  !RequestId, !RequestStatus, !RequestDate,  !TransactionId,  !BorrowDate, !ReturnDate, !BorrowDuration,  !SwapId,  !ReviewId, Rating, !ReviewerComment, !ReviewDate,  !MessageId,  !MsgTime, !MsgDate, !MessageContent,  !FriendshipId,  !DateCreated, !FriendshipStatus,  !ReportId, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity,  !NotificationId, Type, !NotifTime, !NotifDate, !NotificationStatus, !TN_Description, !MN_Description, !FR_Description, !BR_Description)
+
+
+**Функционални зависности:**
+
+
+Email -> !UserId, !FirstName, !LastName, Username, Password, City, Neighborhood, Bio, Quote
+Username -> !UserId, !FirstName, !LastName, Email, Password, City, Neighborhood, Bio, Quote
+
+!BookId -> Title, Author, Language, !ImageURL
+
+!BookISBNId -> !BookId, ISBN
+
+!GenreId -> !BookId, Genre
+
+!InventoryId-> !UserId, Availability, Condition, !BookId
+
+!WishId -> !UserId, Priority, !BookId
+
+!RequestId -> !UserId, !InventoryId, !RequestStatus, !RequestDate
+
+!TransactionId -> !RequestId, !BorrowDate, !ReturnDate, !BorrowDuration
+
+!SwapId -> !TransactionId
+
+!ReviewId -> !TransactionId, !UserId, Rating, !ReviewerComment, !ReviewDate
+
+!MessageId -> !UserId, !MsgTime, !MsgDate, !MessageContent
+
+!FriendshipId -> !UserId, !DateCreated, !FriendshipStatus
+
+!ReportId -> !UserId, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity
+
+!NotificationId -> Type, !NotifTime, !NotifDate, !NotificationStatus
+
+!TransactionId -> !NotificationId, !TN_Description
+
+!MessageId -> !NotificationId, !MN_Description
+
+!FriendshipId -> !NotificationId, !FR_Description
+
+!RequestId -> !NotificationId, !BR_Description
+
+
+
+=== ===
+
+**Лево:** !BookISBNId,!GenreId, !WishId, !SwapId, !ReviewId, !ReportId 
+
+**Десно:** 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
+
+**Од двете страни:** !UserId, Email, Username, !BookId, !InventoryId, !RequestId, !TransactionId, !MessageId, !FriendshipId, !NotificationId, !TransactionId, !MessageId, !FriendRequestId, !BookRequestId 
+
+=== ===
+
+**BookISBNId** += {!BookId, ISBN, Title, Author, Language, !ImageURL}
+        Не ги содржи сите атрибути
+
+**GenreId** += {!BookId, Genre, Title, Author, Language, !ImageURL}
+        Не ги содржи сите атрибути
+
+**WishId** += {!UserId, Priority, !BookId, Title, Author, Language, !ImageURL, FirstName, LastName, Email, Username, Password, City, Neighborhood, Bio, Quote}
+        Не ги содржи сите атрибути
+
+**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}
+        Не ги содржи сите атрибути
+
+**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}
+        Не ги содржи сите атрибути
+
+**ReportId** += {!UserId, !ReportType, !ReportDate, Details, !ReportStatus, !ReportedEntity, !FirstName, !LastName, Email, Username, Password, City, Neighborhood, Bio, Quote}
+        Не ги содржи сите атрибути
+
+
+
+**!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}
+
+**Следува дека е единствен кандидат клуч и го прогласуваме за примарен клуч. **
+
+=== ===
+
+**Декомпозиција**
+
+
+R1 (BookId, Title, Author, Language, ImageURL)
+
+
+R2 (BookId, 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, ISBN, Genre, Priority, ReportType, ReportDate, Details, ReportStatus, ReportedEntity,    MessageId, FriendshipId, RequestId, Type, NotifTime, NotifDate, Description, NotificationStatus, MsgTime, MsgDate, MessageContent, DateCreated, FriendshipStatus,  RequestStatus, RequestDate,  TN_Description, MN_Description, FR_Description, BR_Description)
+
+R21 (BookISBNId, GenreId, BookId, ISBN, Genre)
+
+
+R22 (BookISBNId, GenreId, BookId, 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, 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)
+
+R211(BookId, BookISBNId, ISBN)
+
+
+R212(BookId, GenreId, Genre)
+
+R221(UserId, FirstName, LastName, Email, Username, Password, City, Neighborhood, Bio, Quote)
+
+
+R222(UserId, BookISBNId, GenreId, BookId, ReviewId, BookISBNId, GenreId, WishId, SwapId, ReportId,     NotificationId, TransactionId, Rating, ReviewerComment, ReviewDate, InventoryId, BorrowDate, ReturnDate, BorrowDuration, Availability, Condition, 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)
+
+
+R2221(NotificationId, Type, NotifTime, NotifDate, NotificationStatus)
+
+
+R2222(NotificationId, UserId, BookISBNId, GenreId, BookId, ReviewId, BookISBNId, GenreId, WishId, SwapId, ReportId,     NotificationId, TransactionId, Rating, ReviewerComment, ReviewDate, InventoryId, BorrowDate, ReturnDate, BorrowDuration, Availability, Condition, Priority, ReportType, ReportDate, Details, ReportStatus, ReportedEntity,    MessageId, FriendshipId, RequestId,  MsgTime, MsgDate, MessageContent, DateCreated, FriendshipStatus,  RequestStatus, RequestDate,  TN_Description, MN_Description, FR_Description, BR_Description)
+
+R22221(TransactionId, NotificationId, TN_Description, RequestId, BorrowDate, ReturnDate, BorrowDuration)
+
+
+R22222(TransactionId, NotificationId, UserId, BookISBNId, GenreId, BookId, ReviewId, BookISBNId, GenreId, WishId, SwapId, ReportId,     NotificationId, TransactionId, Rating, ReviewerComment, ReviewDate, InventoryId, BorrowDate, ReturnDate, BorrowDuration, Availability, Condition, Priority, ReportType, ReportDate, Details, ReportStatus, ReportedEntity,    MessageId, FriendshipId, RequestId,  MsgTime, MsgDate, MessageContent, DateCreated, FriendshipStatus,  RequestStatus, RequestDate,  MN_Description, FR_Description, BR_Description)
+
+R222211(TransactionId, NotificationId, TN_Description)
+
+
+R222212(TransactionId, RequestId, BorrowDate, ReturnDate, BorrowDuration)
+
+R222221(MessageId, NotificationId, MN_Description, UserId, MsgTime, MsgDate, MessageContent)
+
+
+R222222(MessageId, TransactionId, NotificationId, UserId, BookISBNId, GenreId, BookId, ReviewId, BookISBNId, GenreId, WishId, SwapId, ReportId,     NotificationId, TransactionId, Rating, ReviewerComment, ReviewDate, InventoryId, BorrowDate, ReturnDate, BorrowDuration, Availability, Condition, Priority, ReportType, ReportDate, Details, ReportStatus, ReportedEntity,     FriendshipId, RequestId,  DateCreated, FriendshipStatus,  RequestStatus, RequestDate,   FR_Description, BR_Description)
+
+R2222211(MessageId, NotificationId, MN_Description)
+
+
+R2222212(MessageId, UserId, MsgTime, MsgDate, MessageContent)
+
+R2222221(FriendshipId,  NotificationId, FR_Description, UserId, DateCreated, FriendshipStatus)
+
+
+R2222222(FriendshipId, MessageId, TransactionId, NotificationId, UserId, BookISBNId, GenreId, BookId, ReviewId, BookISBNId, GenreId, WishId, SwapId, ReportId,     NotificationId, TransactionId, Rating, ReviewerComment, ReviewDate, InventoryId, BorrowDate, ReturnDate, BorrowDuration, Availability, Condition, Priority, ReportType, ReportDate, Details, ReportStatus, ReportedEntity,     RequestId,   RequestStatus, RequestDate,  BR_Description)
+
+
+R22222211(FriendshipId,  NotificationId, FR_Description)
+
+
+R22222212(FriendshipId, UserId, DateCreated, FriendshipStatus)
+
+R22222221(ReportId, UserId, ReportType, ReportDate, Details, ReportStatus, ReportedEntity)
+
+
+R22222222( ReportId, FriendshipId, MessageId, TransactionId, NotificationId, UserId, BookISBNId, GenreId, BookId, ReviewId, BookISBNId, GenreId, WishId, SwapId,    NotificationId, TransactionId, Rating, ReviewerComment, ReviewDate, InventoryId, BorrowDate, ReturnDate, BorrowDuration, Availability, Condition, Priority,   RequestId,   RequestStatus, RequestDate,  BR_Description)
+
+R222222221( ReviewId, TransactionId, UserId, Rating, ReviewerComment, ReviewDate)
+
+
+R222222222( ReviewId, ReportId, FriendshipId, MessageId, TransactionId, NotificationId, UserId, BookISBNId, GenreId, BookId,  BookISBNId, GenreId, WishId, SwapId,    NotificationId, TransactionId, InventoryId, BorrowDate, ReturnDate, BorrowDuration, Availability, Condition, Priority,   RequestId,   RequestStatus, RequestDate,  BR_Description)
+
+
+R2222222221(RequestId, NotificationId, BR_Description,  UserId, InventoryId, RequestStatus, RequestDate)
+
+
+R2222222222( RequestId,  ReportId, FriendshipId, MessageId, TransactionId, NotificationId, UserId, BookISBNId, GenreId, BookId,  BookISBNId, GenreId, WishId, SwapId,    NotificationId, TransactionId, InventoryId, BorrowDate, ReturnDate, BorrowDuration, Availability, Condition, Priority,   RequestId)
+
+
+R22222222211(RequestId, NotificationId, BR_Description)
+
+
+R22222222212(RequestId,  UserId, InventoryId, RequestStatus, RequestDate)
+
+R22222222221(TransactionId, SwapId, RequestId, BorrowDate, ReturnDate, BorrowDuration)
+
+
+R22222222222( TransactionId, SwapId, ReportId, FriendshipId, MessageId, TransactionId, NotificationId, UserId, BookISBNId, GenreId, BookId,  BookISBNId, GenreId, WishId,     NotificationId,  InventoryId, Availability, Condition, Priority,   RequestId)
+
+
+R222222222211(TransactionId, RequestId, BorrowDate, ReturnDate, BorrowDuration)
+
+
+R222222222211(TransactionId, SwapId)
+
+
+R222222222221( InvenotryId, WishId, UserId, Availability, Condition, BookId,  Priority)
+
+
+R222222222222( ReportId, FriendshipId, MessageId, TransactionId, NotificationId, UserId, BookISBNId, GenreId, BookId,  BookISBNId, GenreId, WishId, SwapId,    NotificationId, TransactionId, InventoryId,  RequestId)
+
+R2222222222211( InvenotryId, UserId, Availability, Condition, BookId)
+
+
+R2222222222212( WishId, UserId, Priority, BookId)