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.

3. 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;