= Концептуален дизајн - ЕР Дијаграм и податочни побарувања =
== ER дијарграм == 
[[Image(BER.png)]]

== Податочни побарувања ==
=== Ентитети ===
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'''
== Релации ===