
π Student Projects (College Reports) Β· Data Flow
How data moves through a library system: members and the librarian, the main processes, and the data stores they read and write.
Drawing diagramβ¦
Level 1 data flow diagram for a library management system: members send search requests and borrow/return requests; the librarian registers members and adds books. Processes: manage catalogue, search books, issue book, return book and calculate fine, manage members. Data stores: books, members, loans and fines. Overdue notices go back to members.
flowchart LR
subgraph EXT ["π External Entities"]
M["Member"]
LB["Librarian"]
end
subgraph PROC ["βοΈ Core Processes"]
P1["1.0 Manage catalogue"]
P2["2.0 Search books"]
P3["3.0 Issue book"]
P4["4.0 Return book and calculate fine"]
P5["5.0 Manage members"]
end
subgraph STORE ["ποΈ Data Stores"]
D1[("D1 Books")]
D2[("D2 Members")]
D3[("D3 Loans")]
D4[("D4 Fines")]
end
LB -->|"1. New book details"| P1
P1 -->|"2. Book record"| D1
M -->|"3. Search query"| P2
D1 -->|"4. Matching books"| P2
P2 -->|"5. Search results"| M
M -->|"6. Borrow request"| P3
D2 -->|"7. Member status"| P3
P3 -->|"8. Loan record"| D3
M -->|"9. Returned book"| P4
D3 -->|"10. Due date"| P4
P4 -->|"11. Fine record"| D4
P4 -->|"12. Fine notice"| M
LB -->|"13. Member details"| P5
P5 -->|"14. Member record"| D2Who 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.
The main classes of a library system with attributes, methods and UML relationships.
The steps when a member borrows a book: checks, loan record and the copy status update.
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.