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


Ignore:
Timestamp:
12/23/24 03:16:49 (3 weeks ago)
Author:
222039
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

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

    v41 v42  
    2929
    3030'''Book_Author'''
    31 * ('''BookID'''*(Book), '''AuthorID'''*(Author)
     31* ('''BookID'''*(Book), '''AuthorID'''*(Author))
    3232
    3333'''Loan'''
    34 * ('''__LoanID__''', ''__LoanDate, ReturnDate, Status__'', '''BookCopyID'''*(Book_Copies), '''MemberID'''*(Member)
     34* ('''__LoanID__''', ''__LoanDate, ReturnDate, Status__'', '''BookCopyID'''*(Book_Copies), '''MemberID'''*(Member))
    3535
    3636'''Fine'''
    37 * ('''__FineID__''', ''__FineAmount, FineDate, Status__'', '''LoanID'''*(Loan)
     37* ('''__FineID__''', ''__FineAmount, FineDate, Status__'', '''LoanID'''*(Loan))
    3838
    3939'''FinePayment'''
    40 * '''__FinePaymentID__''', ''__PaymentDate, PaymentAmount__'', '''FineID'''*(Fine)
     40* ('''__FinePaymentID__''', ''__PaymentDate, PaymentAmount__'', '''FineID'''*(Fine))
     41
     42'''Cart'''
     43* ('''__CartID__''', '''BookCopyID'''*(Book_Copies), '''MemberID'''*(Member))
    4144
    4245== DDL скрипта за креирање и бришење на табелите ==