Consider a library wanted to normalize their database. They need to hold the following information for books,
Question:
Consider a library wanted to normalize their database. They need to hold the following information for books, borrowers, and branches. Help them to normalize the database and show your steps for 1NF, 2NF, and 3NF. Note: BookID, BranchID, BorrowerID are unique. See the un-normalized attributes below.
LibraryDB (BookID, Title, Publishers, AuthorName, BranchID, BranchName, BranchAddress, BorrowerID, BorrowerName, BorrowerAddress, BorrowerPhones (multiple phones), BorrowDateOut, BorrowDueDate, NumberofCopiesofBookinBranch)
After working through the normalization steps about how many entities (tables) did you come up with after getting to 3rd Normal Form?
Federal Taxation 2016 Comprehensive
ISBN: 9780134104379
29th Edition
Authors: Thomas R. Pope, Timothy J. Rupert, Kenneth E. Anderson