== Нормализација ==

**Почетна релација:**

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)


**Функционални зависности:**

!UserId -> !FirstName, !LastName, Email, Username, Password, City, Neighborhood, Bio, Quote
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)