Концептуален дизајн - ЕР Дијаграм и податочни побарувања

ER дијарграм

Податочни побарувања

Ентитети

1. Users

• UserID - Primary Key, Numeric
• Username - Mandatory Attribute, Text
• FirstName - Optional Attribute, Text
• LastName - Optional Attribute, Text
• Address - Optional Attribute, Text
• Phone - Optional Attribute, Numeric
• Password - Mandatory Attribute, Text
• Email - Mandatory Attribute, Text
• Role - Mandatory Attribute, Text

2. Member

• MemberID - Primary Key, Numeric
• Membership_Status - Mandatory Attribute, ENUM (Values: 'Active', 'Inactive', 'Suspended')
• Expired_Date - Mandatory Attribute, Date

3. Book

• BookID - Primary Key, Numeric
• ISBN - Mandatory Attribute, Text
• Title - Mandatory Attribute, Text
• Genre - Mandatory Attribute, Text
• PublishedYear - Mandatory Attribute, Numeric
• Description - Optional Attribute, Text
• CoverImage - Optional Attribute, Text
• TotalCopies - Mandatory Attribute, Numeric

4. Book_Details

• Format - Mandatory Attribute, ENUM (Values: 'Hardcover', 'Paperback')
• Language - Mandatory Attribute, Text
• Publisher - Mandatory Attribute, Text
• Pages - Mandatory Attribute, Text

5. Book_Copies

• CopyID - Primary Key, Numeric
• Condition - Mandatory Attribute, ENUM (Values: 'New', 'Good', 'Damaged')

6. Author

• AuthorID - Primary Key, Numeric
• FirstName - Mandatory Attribute, Text
• LastName - Mandatory Attribute, Text
• Nationality - Mandatory Attribute, Text
• DateOfBirth - Mandatory Attribute, Date
• Author_Description - Optional Attribute, Text
• Author_Image - Optional Attribute, Text

7. Book_Author

8. Loan

• LoanID - Primary Key, Numeric
• LoanDate - Mandatory Attribute, Date
• ReturnDate - Optional Attribute, Date
• Status - Mandatory Attribute, Text (Values: 'Active', 'Returned', 'Overdue')

9. Fine

• FineID - Primary Key, Numeric
• FineAmount - Mandatory Attribute, Numeric
• FineDate - Mandatory Attribute, Date
• Status - Mandatory Attribute, Text

Релации =