This project is a mandatory project in NTNU's "Datamodeling and Database Applications" course. The project counts towards the final grade in the subject.
- 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”