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


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

--

Legend:

Unmodified
Added
Removed
Modified

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

    v16 v17  
    11== Релациска шема ==
     2'''Users'''
     3* (UserID, Username, Password, Email, Role)
     4
     5'''Member'''
     6* (MemberID, Address, Phone, Membership_Status, UserID*(Users))
     7
     8'''Book'''
     9* (BookID, ISBN, Title, Genre, PublishedYear, TotalCopies)
     10
     11'''Book_Copies'''
     12* (CopyID, BookID*(Book), Condition)
     13
     14'''Author'''
     15* (AuthorID, FirstName, LastName, Nationality, DateOfBirth)
     16
     17'''Book_Author'''
     18* (BookID*(Book), AuthorID*(Author))
     19
     20'''Loan'''
     21* (LoanID, LoanDate, ReturnDate, Status, BookCopyID*(Book_Copies), MemberID*(Member))
     22
     23'''Fine'''
     24* (FineID, FineAmount, FineDate, Status, LoanID*(Loan))
     25
     26'''FinePayment'''
     27* (FinePaymentID, PaymentDate, PaymentAmount, FineID*(Fine))
    228
    329=== DDL скрипта за креирање и бришење на табелите ===