Database Concepts: Answers to Questions 1-4

Running head: DATABASE CONCEPTS
Database concepts
Name of the Student:
Name of the University:
Author Note

1
DATABASE CONCEPTS
Answer to question number 1
1.1)
{LoanID}+ = {memberID, BookID}
1.2)
MemberID -> MemberFirstName, MemberLastName, Address, PostCode
Address  PostCode
LoanID  MemberID, BookID, LoanDate, ReturnDate
MemberID, BookID  LoanID, LoanDate, ReturnDate
BookID  Title, Year, PublisherID
PublisherID  PublisherName
AuthorID  AuthorFirstName, AuthorLastName
PublisherID, Title  Year
Therefore MemberID -> Address, PostCode
Therefore, MemberID is the candidate key.
LoanID  MemberID, BookID,
Therefore, LoanID is the candidate key.
BookID  PublisherID
Therefore, BookID is the candidate key.
AuthorID  AuthorFirstName, AuthorLastName
Therefore AuthorID is the candidate key.

2
DATABASE CONCEPTS
PublisherID, Title  Year
Therefore publisherID is the candidate key.
1.3)
BookID -> PublisherID
Loan ID -> BookID, memberID
The minimal basis for the functional dependencies are
{LoanID, AuthorID}
1.4)
The Relation is in BCNF as the database provides the extended transitive
dependency as per the description shown below:
Loan ID -> BookID, memberID
BookID -> PublisherID
MemberID -> MemberFirstName, MemberLastName, Address, PostCode
Address -> PostCode
LoanID -> MemberID, BookID, LoanDate, ReturnDate
MemberID, BookID -> LoanID, LoanDate, ReturnDate
BookID -> Title, Year, PublisherID
PublisherID -> PublisherName
AuthorID -> AuthorFirstName, AuthorLastName
PublisherID, Title -> Year