Database design colt
Screens that are easy to use, understand and follow by novice staff.
The views of library staff, students and general staff (non-administration) should be different.
The third report shows the details of the books that are borrowed in the last three months.
Staff Requirements
Check for unpaid fines for a student;
Add a new borrowing to the system and;
Manage and run the reports that are created by the system;
Check Student loan details for any overdue books; and
Enter the details of new books to the database system to the library catalog as well as new copies of an existing book;
Change the details of the existing books (e.g. missing books etc.).
Subject;
Check the availability of a particular book;