Changes between Version 7 and Version 8 of UseCase013

Timestamp:

01/21/25 07:06:19 (30 hours ago)

Author:

201205

Comment:

--

UseCase013

@@ -17 +17 @@
 VALUES(4, 'Daisy Jones & The Six', 'Taylor Jenkins Reid', 'French', NULL)
 
-INSERT INTO BookISBN (BookId, ISBN)
-VALUES (4, '0-356-50257-0')
+INSERT INTO BookISBN (BookISBNId, BookId, ISBN)
+VALUES (4, 4, '0-356-50257-0')
 
-INSERT INTO Genre (BookId, Genre)
-VALUES (4, 'Historical Fiction')
- (4, 'Urban Fiction')
+INSERT INTO Genre (GenreId, BookId, Genre)
+VALUES  (1 ,4, 'Historical Fiction')
+ (2,4, 'Urban Fiction')
 
 INSERT INTO Library (InventoryId, UserId, Availability, Condition)
 VALUES (4, 1, 'Available', 'Like New')
 
-INSERT INTO LibraryBook(LibraryBookId, InventoryId, BookId)
+INSERT INTO ContainsLibraryBook(LibraryBookId, InventoryId, BookId)
 VALUES (4,4,4)
 }}}
@@ -42 +42 @@
 update Library L
 set condition='Poor'
-from LibraryBook LB
-where L.InventoryId=LB.InventoryId and LB.BookId=5;
+from ContainsLibraryBook CLB
+where L.InventoryId=CLB.InventoryId and CLB.BookId=5;
 }}}
 
@@ -53 +53 @@
 {{{
 delete from Library L
-using LibraryBook LB
-where L.InventoryId=LB.InventoryId and LB.BookId=5;
+using ContainsLibraryBook CLB
+where L.InventoryId=CLB.InventoryId and CLB.BookId=5;
 }}}