quote:

---

Blue library has required an application to manage their works. This library organizes books with categories and sub categories. So each book belongs to a category. Books are stored with their title, author(s), edition, publication date, ISBN, and Publisher Company. Publisher Information must be stored in the separate table for data integrity. Additionally each book must have information about if it is international edition or not. Books must be searchable by their title, author and their categories.
Also, student information with their department information must be stored. Each student must have std id, name, surname, dept_id, enterance_date. And department table should have dept_id, dept_name columns.

When a student comes to library to reserve a book, the librarian should be able to reserve the requested books to the student. Each student may take at most 3 books. And each book should be returned in a month. The library manager should be able to take the list of books that are not returned on time. Also, library manager should be able to add/delete/update categories. However, other librarians should not be able to perform those tasks. Librarians should add/delete/update the books and reservations. For those functionalities, you should have two user categories that are Library Manager and library operators. Your database should support multiple operators. Unauthorized access to database should be prevented with user passwords. Each operator and Library Manager should have their own passwords. Library manager should have all privileges on library operator accounts. (i.e: retrieving a forgotten password, removing an account, adding a new operator account, etc.) User management process should be done by library manager account.

---