- • Library card
- o card number
- o email
- o name
- o on loan number
- o credit score
- o arrears
- O is active
-
- book
- o title
- o number
- o Storage Time
- o number of debits
- o status (whether it is on loan, scheduled, or lost)
- o purchase price
- • Borrow information
- o Library card number
- o book number
- o loan time
- o time
- • Reservation
- o Borrow Book Number
- o book number
- o scheduled time (first come first served)
- • Book book
- o Sponsor Library card number
- o bibliography
- o Book introduction
- o Other specific description
- o seconded by card number list, split
- • New card request
- o email
o name
- o employee number
- o status (application, approval)
- • Warning History
- o card number
- o warning Cause
- • Configuration table
- o Maximum number of debits (constant 5)
- o maximum available time (constant 7)
- o Max warning Count (3)
- o
This is a draft .... I don't know how to design because I ooad very unfamiliar.
Database Modeling Library (2) Specific data sheet settings,