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


Ignore:
Timestamp:
12/18/24 18:00:26 (4 weeks ago)
Author:
222039
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

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

    v25 v26  
    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'''
    1414* ('''__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 скрипта за креирање и бришење на табелите ===