It minimizes data redundancy by storing each book's author and title only once in the Book table, referencing them in the Loan table via the foreign key BookID, which also prevents potential data inconsistencies during updates.

It improves update speed because if a librarian's name changes, the DBMS requires the operator to manually find and update every corresponding row in both the Librarian and Loan tables.

It simplifies database administration by storing all attributes of librarians, books, and loans in a single flat table, removing the need for relational constraints.

It increases query performance by automatically duplicating the StaffID primary key as an attribute inside the Book table to link librarians directly to book titles.