Changes between Version 14 and Version 15 of Концептуален дизајн - ЕР Дијаграм и податочни побарувања


Ignore:
Timestamp:
12/22/24 21:49:27 (3 weeks ago)
Author:
222039
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

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

    v14 v15  
    55== Податочни побарувања ==
    66=== Ентитети ===
    7 1. '''Book'''
    8 * '''BookID''' - Primary Key, Numeric
    9 * ISBN - Mandatory Attribute, Text
    10 * Title - Mandatory Attribute, Text
    11 * Genre - Mandatory Attribute, Text
    12 * PublishedYear - Mandatory Attribute, Numeric
    13 * TotalCopies - Mandatory Attribute, Numeric
    14 2. '''Book_Copies'''
    15 * '''CopyID''' - Primary Key, Numeric
    16 * Condition - Mandatory Attribute, ENUM (Values: 'New', 'Good', 'Damaged')
     71. '''Users'''
     8* '''UserID''' - Primary Key, Numeric'''
     9* Username - Mandatory Attribute, Text
     10* FirstName - Optional Attribute, Text
     11* LastName - Optional Attribute, Text
     12* Address - Optional Attribute, Text
     13* Phone - Optional Attribute, Numeric
     14* Password - Mandatory Attribute, Text
     15* Email - Mandatory Attribute, Text
     16* Role - Mandatory Attribute, Text
     17
     182. '''Member'''
     19* '''MemberID ''' - Primary Key, Numeric
     20* Membership_Status - Mandatory Attribute, ENUM (Values: 'Active', 'Inactive', 'Suspended')
     21* Expired_Date - Mandatory Attribute, Date
     22
     23
     24
     25
    17263. '''Book_Author'''
    18274. '''Author'''
    … …  
    2736* ReturnDate - Optional Attribute, Date
    2837* Status - Mandatory Attribute, Text (Values: 'Active', 'Returned', 'Overdue')
    29 6. '''Member'''
    30 * '''MemberID''' - Primary Key, Numeric
    31 * Address - Mandatory Attribute, Text
    32 * Phone - Mandatory Attribute, Numeric
    33 * Membership_Status - Mandatory Attribute, ENUM
    34 7. '''User'''
    35 * '''UserID''' - Primary Key, Numeric
    36 * Username - Mandatory Attribute, Text
    37 * Password - Mandatory Attribute, Text
    38 * Email - Mandatory Attribute, Text
    39 * Role - Mandatory Attribute, Text
    40388. '''Fine'''
    4139* '''FineID''' - Primary Key, Numeric