Web site builder - Exercise 2 solution Three CREATE INDEX commands to
Exercise 2 solution Three CREATE INDEX commands to create indexes on foreign keys: CREATE INDEX XFK_SI_SSD ON Stock_Item (stock_source_department); CREATE INDEX XFK_SO_C ON Sale_Order (customer_name); CREATE INDEX XFK_SOI_SI ON Sale_Order_Item (stock#); Chapter 5 Exercise 1 solution There are two possible answers: SELECT * FROM EDITION; SELECT ISBN,PUBLISHER_ID,PUBLICATION_ID,PRINT_DATE,PAGES,LIST_PRICE,FORMAT,RANK, UNITS FROM EDITION; Exercise 2 solution SELECT ISBN FROM EDITION WHERE FORMAT= Hardcover ; Exercise 3 solution SELECT ISBN FROM EDITION WHERE FORMAT= Hardcover ORDER BY FORMAT, LIST_PRICE; Exercise 4 solution 3 + 4 * 5 = 23, and (3 + 4 ) * 5 = 35. The second expression yields the greater value. Exercise 5 solution SELECT PUBLISHER_ID, SUM(LIST_PRICE) FROM EDITION GROUP BY PUBLISHER_ID; Exercise 6 solution SELECT * FROM SUBJECT S JOIN PUBLICATION P USING (SUBJECT_ID); Exercise 7 solution SELECT * FROM SUBJECT S LEFT OUTER JOIN PUBLICATION P USING (SUBJECT_ID); Exercise 8 solution SELECT * FROM SUBJECT WHERE SUBJECT_ID IN (SELECT SUBJECT_ID FROM PUBLICATION); SELECT * FROM SUBJECT WHERE EXISTS (SELECT SUBJECT_ID FROM PUBLICATION WHERE SUBJECT_ID = SUBJECT.SUBJECT_ID); 423 Exercise Answers
Please visit Domain Name Hosting services for high quality webhost to host and run your jsp applications.