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

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

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)