Changes between Version 7 and Version 8 of Концептуален дизајн - ЕР Дијаграм и податочни побарувања
- Timestamp:
- 12/18/24 17:04:11 (4 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Концептуален дизајн - ЕР Дијаграм и податочни побарувања
v7 v8 7 7 1. '''Book''' 8 8 * '''BookID''' - Primary Key, Numeric 9 * ISBN - Mandatory Attribute, Text 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 14 * Condition - Mandatory Attribute, ENUM 13 * TotalCopies - Mandatory Attribute, Numeric 15 14 16 2. '''Book_Author''' 15 2. '''Book_Copies''' 16 * '''CopyID''' - Primary Key, Numeric 17 * Condition - Mandatory Attribute, ENUM (Values: 'New', 'Good', 'Damaged') 17 18 18 3. '''Author''' 19 20 3. '''Book_Author''' 21 22 4. '''Author''' 19 23 * '''AuthorID''' - Primary Key, Numeric 20 24 * FirstName - Mandatory Attribute, Text … … 23 27 * DateOfBirth - Mandatory Attribute, Date 24 28 25 4. '''Loan'''29 5. '''Loan''' 26 30 * '''LoanID''' - Primary Key, Numeric 27 31 * LoanDate - Mandatory Attribute, Date 28 32 * ReturnDate - Optional Attribute, Date 29 * Status - Mandatory Attribute, Text 33 * Status - Mandatory Attribute, Text (Values: 'Active', 'Returned', 'Overdue') 30 34 31 5. '''Member'''35 6. '''Member''' 32 36 * '''MemberID''' - Primary Key, Numeric 33 37 * Address - Mandatory Attribute, Text … … 35 39 * Membership_Status - Mandatory Attribute, ENUM 36 40 37 6. '''User'''41 7. '''User''' 38 42 * '''UserID''' - Primary Key, Numeric 39 43 * Username - Mandatory Attribute, Text … … 42 46 * Role - Mandatory Attribute, Text 43 47 44 7. '''Fine'''48 8. '''Fine''' 45 49 * '''FineID''' - Primary Key, Numeric 46 50 * FineAmount - Mandatory Attribute, Numeric … … 48 52 * Status - Mandatory Attribute, Text 49 53 50 8. '''Fine_Payment'''54 9. '''Fine_Payment''' 51 55 * '''FinePaymentID''' - Primary Key, Numeric 52 56 * PaymentDate - Mandatory Attribute, Date
