Database

16. Create a new table named FictionCopies using the data in the BookCode, Title, BranchNum, CopyNum, Quality, and Price columns for those books that have the type FIC.

17. Ray Henry is considering increasing the price of all copies of fiction books whose quality is excellent by 10%. To determine the new prices, list the book code, title, and increased price of every book in the FictionCopies table. (Your computed column should determine 110% of the current price, which is 100% plus a 10% increase.)