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

Timestamp:

01/11/25 10:39:30 (4 days ago)

Author:

201205

Comment:

--

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

@@ -10 +10 @@
 User(**__UserId__**, **!FirstName**, **!LastName**, **Email**, **Username**, **Password**, **City**, **Neighborhood**, Bio, Quote)
 
-Book(**__BookId__**, **Title**, **Author**, **Language**, ImageURL, **__!InventoryId*__**, **__!WishId*__**)
+Book(**__BookId__**, **Title**, **Author**, **Language**, ImageURL)
 
 BookISBN(**__!BookId*__**, **ISBN**)
@@ -18 +18 @@
     • !BookId референцира кон Book(!BookId)
 
-Library(**__InventoryId__**, **__!UserId*__**, **Availability**, **Condition**) 
+Library(**__InventoryId__**, **__!UserId*__**, **__BookId__**, **Availability**, **Condition**) 
     • !UserId референцира кон User(!UserId)
+    • !BookId референцира кон Book(!BookId)
 
-Wishlist(**__WishId__**, **__!UserId*__**, Priority)
+Wishlist(**__WishId__**, **__!UserId*__**, **__BookId__**, Priority)
     • !UserId референцира кон User(!UserId)
+    • !BookId референцира кон Book(!BookId)
 
 !BookRequest(**__RequestId__**, **__!RequesterId*__**, **__!OwnerId*__**, **__!BookId*__**, **__!InventoryId*__**, **!RequestStatus**, **!RequestDate**)