Changes between Version 2 and Version 3 of Концептуален дизајн - ЕР Дијаграм и податочни побарувања
- Timestamp:
- 12/04/24 21:07:48 (6 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Концептуален дизајн - ЕР Дијаграм и податочни побарувања
v2 v3 7 7 1. '''Book''' 8 8 * '''BookID''' - Primary Key, Numeric 9 * ISBN - Mandatory Attribute, Text (International Standard Book Number)9 * ISBN - Mandatory Attribute, Text 10 10 * Title - Mandatory Attribute, Text 11 11 * Genre - Mandatory Attribute, Text 12 12 * PublishedYear - Mandatory Attribute, Numeric 13 * Copies - Mandatory Attribute, Numeric (Indicates the number of available copies of the book)13 * Copies - Mandatory Attribute, Numeric 14 14 15 15 2. '''Book_Author''' 16 * '''BookID''' - Foreign Key to Book (N:1 Relationship), Numeric17 * '''AuthorID''' - Foreign Key to Author (N:1 Relationship), Numeric18 16 19 17 3. '''Author''' … … 24 22 4. '''Loan''' 25 23 * '''LoanID''' - Primary Key, Numeric 26 * LoanDate - Mandatory Attribute, Date (Date the book was borrowed) 27 * ReturnDate - Optional Attribute, Date (Date the book was returned) 28 * '''BookID''' - Foreign Key to Book (N:1 Relationship), Numeric 29 * '''UserID''' - Foreign Key to User (N:1 Relationship), Numeric 30 * Status - Mandatory Attribute, Text (e.g., "On Loan", "Returned", "Overdue") 24 * LoanDate - Mandatory Attribute, Date 25 * ReturnDate - Optional Attribute, Date 26 * Status - Mandatory Attribute, Text 31 27 32 28 5. '''Member''' 33 29 * '''MemberID''' - Primary Key, Numeric 34 * '''UserID''' - Foreign Key to User (1:1 Relationship), Numeric35 30 * Address - Mandatory Attribute, Text 36 31 * Phone - Mandatory Attribute, Numeric 37 * MembershipDate - Mandatory Attribute, Date (Date when the member joined)32 * MembershipDate - Mandatory Attribute, Date 38 33 39 34 6. '''User''' … … 42 37 * Password - Mandatory Attribute, Text 43 38 * Email - Mandatory Attribute, Text 44 * Role - Mandatory Attribute, Text (e.g., "Librarian", "Member")39 * Role - Mandatory Attribute, Text 45 40 46 41 7. '''Fine''' 47 42 * '''FineID''' - Primary Key, Numeric 48 * '''LoanID''' - Foreign Key to Loan (N:1 Relationship), Numeric49 43 * FineAmount - Mandatory Attribute, Numeric 50 44 * FineDate - Mandatory Attribute, Date 51 * Status - Mandatory Attribute, Text (e.g., "Paid", "Unpaid")45 * Status - Mandatory Attribute, Text 52 46 53 47 8. '''Fine_Payment''' 54 48 * '''FinePaymentID''' - Primary Key, Numeric 55 * '''FineID''' - Foreign Key to Fine (N:1 Relationship), Numeric56 49 * PaymentDate - Mandatory Attribute, Date 57 50 * PaymentAmount - Mandatory Attribute, Numeric
