Create a view named BOOK_INVENTORY. It consists of the branch number and the tot

Question

Create a view named BOOK_INVENTORY. It consists of the branch number and the total number of books on hand for each branch. Use UNITS as the name for the count of books on hand. Group and order the rows by branch number. a. Write and execute the CREATE VIEW command to create the BOOK_INVENTORY view. b. Write and execute the command to retrieve the branch number and units for each branch having more than 25 books on hand. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what are they? If not, why not?

Explanation / Answer

www.unix.eng.ua.edu/~mmcd/Files/CS472/Wk06/HBC-chap04.doc

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.