Changes between Version 17 and Version 18 of Логички и физички дизајн - Креирање база податоци (со SQL DDL)


Ignore:
Timestamp:
12/18/24 17:52:16 (4 weeks ago)
Author:
222039
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Логички и физички дизајн - Креирање база податоци (со SQL DDL)

    v17 v18  
    22'''Users'''
    33* (UserID, Username, Password, Email, Role)
    4 
    54'''Member'''
    65* (MemberID, Address, Phone, Membership_Status, UserID*(Users))
    7 
    86'''Book'''
    97* (BookID, ISBN, Title, Genre, PublishedYear, TotalCopies)
    10 
    118'''Book_Copies'''
    129* (CopyID, BookID*(Book), Condition)
    13 
    1410'''Author'''
    1511* (AuthorID, FirstName, LastName, Nationality, DateOfBirth)
    16 
    1712'''Book_Author'''
    1813* (BookID*(Book), AuthorID*(Author))
    19 
    2014'''Loan'''
    2115* (LoanID, LoanDate, ReturnDate, Status, BookCopyID*(Book_Copies), MemberID*(Member))
    22 
    2316'''Fine'''
    2417* (FineID, FineAmount, FineDate, Status, LoanID*(Loan))
    25 
    2618'''FinePayment'''
    2719* (FinePaymentID, PaymentDate, PaymentAmount, FineID*(Fine))