Changes between Version 17 and Version 18 of Концептуален дизајн - ЕР Дијаграм и податочни побарувања
- Timestamp:
- 12/22/24 21:54:21 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Концептуален дизајн - ЕР Дијаграм и податочни побарувања
v17 v18 31 31 * TotalCopies - Mandatory Attribute, Numeric 32 32 33 4. '''Book_Author''' 34 35 5. '''Book_Details''' 33 4. '''Book_Details''' 36 34 * Format - Mandatory Attribute, ENUM (Values: 'Hardcover', 'Paperback') 37 35 * Language - Mandatory Attribute, Text … … 39 37 * Pages - Mandatory Attribute, Text 40 38 41 6. '''Book_Copies'''39 5. '''Book_Copies''' 42 40 * '''CopyID''' - Primary Key, Numeric 43 41 * Condition - Mandatory Attribute, ENUM (Values: 'New', 'Good', 'Damaged') 44 42 43 6. '''Author''' 44 * '''AuthorID''' - Primary Key, Numeric 45 * FirstName - Mandatory Attribute, Text 46 * LastName - Mandatory Attribute, Text 47 * Nationality - Mandatory Attribute, Text 48 * DateOfBirth - Mandatory Attribute, Date 49 * Author_Description - Optional Attribute, Text 50 * Author_Image - Optional Attribute, Text 51 52 7. '''Book_Author''' 53 54 8. '''Loan''' 55 * '''LoanID''' - Primary Key, Numeric 56 * LoanDate - Mandatory Attribute, Date 57 * ReturnDate - Optional Attribute, Date 58 * Status - Mandatory Attribute, Text (Values: 'Active', 'Returned', 'Overdue') 59 60 9. '''Fine''' 45 61 == Релации === 46 62
