In order to provide some examples, a fictitious Library Database will be used.
Some basics of the Library System
The Staff are a mixture of Full time and part time. Some staff will manage other staff.
A roster for part-time staff is created and each roster item is confirmed and becomes part of a timesheet.
The library contains a collection of books that can be borrowed. Books must be entered into the system before they can be borrowed.
Borrowers are entered into the system before they can borrow a book.
Books may or may not be borrowed.
Borrowers may or may not borrow a book (They may come into the library to use the facilities e.g., read newspapers, use the Internet).