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


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

--

Legend:

Unmodified
Added
Removed
Modified

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

    v22 v23  
    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'''
    12 * (BookID, ISBN, Title, Genre, PublishedYear, TotalCopies)
     12* ('''__BookID__''', ISBN, Title, Genre, PublishedYear, TotalCopies)
    1313'''Book_Copies'''
    14 * (CopyID, BookID*(Book), Condition)
     14* ('''__CopyID__''', BookID*(Book), Condition)
    1515'''Author'''
    16 * (AuthorID, FirstName, LastName, Nationality, DateOfBirth)
     16* ('''__AuthorID__''', FirstName, LastName, Nationality, DateOfBirth)
    1717'''Book_Author'''
    1818* (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 скрипта за креирање и бришење на табелите ===