
π Student Projects (College Reports) Β· Sequence
The steps when a member borrows a book: checks, loan record and the copy status update.
Drawing diagramβ¦
Sequence diagram for issuing a book in a library system: the member asks the librarian for a book; the librarian scans the member card; the system checks the member has no overdue loans and is under the borrow limit; if not eligible it shows the reason; otherwise it creates a loan with a due date 14 days away, marks the copy as issued and prints a due-date slip.
sequenceDiagram
actor M as Member
actor L as Librarian
participant S as Library System
participant DB as Database
M->>L: Request book
L->>S: Scan member card and book copy
S->>DB: Get member loans and fines
DB-->>S: Loans and fines
alt Overdue loans or limit reached
S-->>L: Not eligible, show reason
L-->>M: Explain why the book cannot be issued
else Eligible
S->>DB: Create loan (due in 14 days)
S->>DB: Mark copy as issued
DB-->>S: Saved
S-->>L: Print due-date slip
L-->>M: Hand over book and slip
endWho uses a college library system and what each of them can do: members, the librarian and the system administrator.
The database of a library system: books and their copies, authors, members, loans, reservations and fines, with keys and cardinality.
How data moves through a library system: members and the librarian, the main processes, and the data stores they read and write.
The main classes of a library system with attributes, methods and UML relationships.
What students, examiners and the administrator do in an online examination system.
Database design for online exams: courses, exams, questions and options, attempts, answers and results.