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

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_Author

5. Book_Details

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

6. Book_Copies

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

Релации =