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
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Federal Taxation 2016 Comprehensive
Authors: Thomas R. Pope, Timothy J. Rupert, Kenneth E. Anderson
29th Edition
134104374, 978-0134104379
