Changes between Version 5 and Version 6 of UseCase013

Timestamp:

01/13/25 02:38:17 (2 days ago)

Author:

201205

Comment:

--

UseCase013

@@ -24 +24 @@
  (4, 'Urban Fiction')
 
-INSERT INTO Library (InventoryId, UserId, BookId, Availability, Condition)
-VALUES (4, 1, 4, 'Available', 'Like New')
+INSERT INTO Library (InventoryId, UserId, Availability, Condition)
+VALUES (4, 1, 'Available', 'Like New')
+
+INSERT INTO LibraryBook(InventoryId, BookId)
+VALUES (4,4)
 }}}
 
@@ -37 +40 @@
 
 {{{
-update "library" l 
+update Library L
 set condition='Poor'
-where l.bookid=5;
+from LibraryBook LB
+where L.InventoryId=LB.InventoryId and LB.BookId=5;
 }}}
 
@@ -48 +52 @@
 
 {{{
-delete from "library" l 
-where l.bookid=5;
+delete from Library L
+using LibraryBook LB
+where L.InventoryId=LB.InventoryId and LB.BookId=5;
 }}}