Логички и физички дизајн - Креирање база податоци (со SQL DDL) ¶
Релациска шема ¶
Ознаки ¶
- Примарни клучеви: bold и underline
- Надворешни клучеви: bold и *(заграда на кои табели референцираат
- Not null атрибути: italic и underline
Табели ¶
Users
Member
- (MemberID, Expired_Date, Membership_Status, UserID*(Users))
Book
- (BookID, ISBN, Title, Genre, PublishedYear, Description, CoverImage, TotalCopies)
Book_Details
- (DetailsID, BookID*(Book), Format, Language, Publisher, Pages)
Book_Copies
- (CopyID, BookID*(Book), Condition)
Author
- (AuthorID, FirstName, LastName, Nationality, DateOfBirth, Author_description, Author_image)
Book_Author
- (BookID*(Book), AuthorID*(Author))
Loan
- (LoanID, LoanDate, ReturnDate, Status, BookCopyID*(Book_Copies), MemberID*(Member))
Fine
- (FineID, FineAmount, FineDate, Status, LoanID*(Loan))
- (FinePaymentID, PaymentDate, PaymentAmount, FineID*(Fine))
Cart
- (CartID, BookID*(Book), MemberID*(Member))
DDL скрипта за креирање и бришење на табелите ¶
DML скрипта за полнење на табелите со податоци ¶
Релациски дијаграм изваден од DBeaver ¶
Last modified
11 days ago
Last modified on 01/10/25 14:17:49
Attachments (4)
- BookTracker - DBeaver.png (37.1 KB ) - added by 4 weeks ago.
- DDL-Script-Book-Tracker.sql (3.6 KB ) - added by 11 days ago.
- DML-Script-Book-Tracker.sql (21.1 KB ) - added by 11 days ago.
- BT-DBeaver.png (38.3 KB ) - added by 11 days ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.