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


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

--

Legend:

Unmodified
Added
Removed
Modified

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

    v23 v24  
    88* ('''__UserID__''', Username, Password, Email, Role)
    99'''Member'''
    10 * ('''__MemberID__''', Address, Phone, Membership_Status, UserID*(Users))
     10* ('''__MemberID__''', Address, Phone, Membership_Status, '''UserID'''*(Users))
    1111'''Book'''
    1212* ('''__BookID__''', ISBN, Title, Genre, PublishedYear, TotalCopies)
    1313'''Book_Copies'''
    14 * ('''__CopyID__''', BookID*(Book), Condition)
     14* ('''__CopyID__''', '''BookID'''*(Book), Condition)
    1515'''Author'''
    1616* ('''__AuthorID__''', FirstName, LastName, Nationality, DateOfBirth)
    1717'''Book_Author'''
    18 * (BookID*(Book), AuthorID*(Author))
     18* ('''BookID'''*(Book), '''AuthorID'''*(Author))
    1919'''Loan'''
    20 * ('''__LoanID__''', LoanDate, ReturnDate, Status, BookCopyID*(Book_Copies), MemberID*(Member))
     20* ('''__LoanID__''', LoanDate, ReturnDate, Status, '''BookCopyID'''*(Book_Copies), '''MemberID'''*(Member))
    2121'''Fine'''
    22 * ('''__FineID__''', FineAmount, FineDate, Status, LoanID*(Loan))
     22* ('''__FineID__''', FineAmount, FineDate, Status, '''LoanID'''*(Loan))
    2323'''FinePayment'''
    24 * ('''__FinePaymentID__''', PaymentDate, PaymentAmount, FineID*(Fine))
     24* ('''__FinePaymentID__''', PaymentDate, PaymentAmount, '''FineID'''*(Fine))
    2525
    2626=== DDL скрипта за креирање и бришење на табелите ===