Library DB project

This project is a mandatory project in NTNU's "Datamodeling and Database Applications" course. The project counts towards the final grade in the subject.

Task requirements:

• Information of books, branches of the library, borrowers and book loans is stored in the database
• The relationships of books, branches of the library, borrowers and book loans are stored in the database
• When one copy of a book is loaned out from a branch, the due date needs to be stored
• A book has one title, one publisher, and one or more authors. There can be several copies in each branch of the library
• The library has several branches which are located on different addresses. Each branch has it's own name and addresses. Two different branches may have the same name
• Borrowers have a name, address and contact info
• Borrowers, as the database's users, have the right to query the book information, but not borrower’s information
• A book can only be loaned to one borrower at a time
• Use the SQLite “dialect”