7. Customers who are part of a special program get a 10 percent dis- count. To see what the discounted prices would be, list the book code, title, and discounted price of all books. (Use the Book Price field to calculate this.) BOOK M100P PBLISI COOE BACK 0180 Shyness PSY 7.65 BB O189 Kane and Abel FIC 5.55 PB 0200 Stranger. The FIC 8.75 BB 0378 Dunwich Horror and Others. The HOR 19.7A PB MYS 4.55 079X Smoke-screen PB T. MYS 4.75 0808 Knockdown PB HOR 1351 Cuio 11.25 ART Marcel Duchamp 1382 3.95 MYS 138X Death on the Nile 19.95 SPI Ghost from the Grand Banks 2226 13.25 ART Prints of the 20th Century PB 2281 5.45 FIC 27oo Prodigal Daughter. The T. 6.75 POE BB 2908 Hymns to the Night T. 9.75 PSY PB Higher Creativity 3350 T. 3.95 FIC First Among Equals PB 3743 T. SUS 5.45 BB 3906 Vortex 16.95 T. SI MUS Organ. The 5163 54.95 BP CS Datahase Systems 5790 4.45 MYS Evil Under the Sun PB o128 SUS 5.55 BB 6328 Vixen 07 23.95 A Guide to SQL. BP CS ti69X 20.50 DOS Essentials T. BF cs Night Probe SUS 7405 T. 6.75 HOR SI 7443 Carrie T. MYS 3.95 PB 7559 Risk 39.90 CS JBASE Programming 7947 BF 21.95 ART SI 8092 Magritte 12.15 FIC T. BB 8720 Castle. The 10.95 T. FIC BB Amerika 1196 Figure 2.5 The B0OK table AUTHOR home BRANCH BRANCH EOCATIONN OEDRES num Sock Archer. Jelfrey 10 16 Riveniew 1 Chriscie. Agatha Henn' Dewntown 12 Beord Clarke, Athur C Hees On The Hill Bevnrwood Mall Henry's Brenrwod Francis, Dick Easahore Mall Cussler, Clive Henry's Eastshore home King. Stephen Pratt. Philip PUBLISHER Alamaki, Joseph quILISHE PUBLISHER CITY Harmon, Willie 10 Sauk Ciry, Wisconsin Arkham Huuse Pull. Rheingold. Howand New York Arcade Publishing AP Owen. Barbara 12 end Alinon- Wesley Realing. Masachusetts Williama. Peter 13 Bantam Books New York Kalka. Frans 14 Baston bod a fraser BF Novalis 15 Las Angeles Jeremy P. Tarcher JT Lovecraft, H. P. MePherson and Co. Kingston Paz, Otavio 17 New York Packet Baoke PB Camus. Alls I8 New York Random House 19 Castleman, Riva Rirnoli New York Zinlarda. Philip New York 20 Schoken Ikoks sa New York Gimferrer. Pere 21 SI Signet Thames and Hluln New York 22 Southworth. Rod TIH wW. Narton and Ca WN New Yark 25 Wray, Robert Figure 2.4 Collection oF tables 7. Customers who are part of a special program get a 10 percent dis- count. To see what the discounted prices would be, list the book code, title, and discounted price of all books. (Use the Book Price field to calculate this.) BOOK M100P PBLISI COOE BACK 0180 Shyness PSY 7.65 BB O189 Kane and Abel FIC 5.55 PB 0200 Stranger. The FIC 8.75 BB 0378 Dunwich Horror and Others. The HOR 19.7A PB MYS 4.55 079X Smoke-screen PB T. MYS 4.75 0808 Knockdown PB HOR 1351 Cuio 11.25 ART Marcel Duchamp 1382 3.95 MYS 138X Death on the Nile 19.95 SPI Ghost from the Grand Banks 2226 13.25 ART Prints of the 20th Century PB 2281 5.45 FIC 27oo Prodigal Daughter. The T. 6.75 POE BB 2908 Hymns to the Night T. 9.75 PSY PB Higher Creativity 3350 T. 3.95 FIC First Among Equals PB 3743 T. SUS 5.45 BB 3906 Vortex 16.95 T. SI MUS Organ. The 5163 54.95 BP CS Datahase Systems 5790 4.45 MYS Evil Under the Sun PB o128 SUS 5.55 BB 6328 Vixen 07 23.95 A Guide to SQL. BP CS ti69X 20.50 DOS Essentials T. BF cs Night Probe SUS 7405 T. 6.75 HOR SI 7443 Carrie T. MYS 3.95 PB 7559 Risk 39.90 CS JBASE Programming 7947 BF 21.95 ART SI 8092 Magritte 12.15 FIC T. BB 8720 Castle. The 10.95 T. FIC BB Amerika 1196 Figure 2.5 The B0OK table AUTHOR home BRANCH BRANCH EOCATIONN OEDRES num Sock Archer. Jelfrey 10 16 Riveniew 1 Chriscie. Agatha Henn' Dewntown 12 Beord Clarke, Athur C Hees On The Hill Bevnrwood Mall Henry's Brenrwod Francis, Dick Easahore Mall Cussler, Clive Henry's Eastshore home King. Stephen Pratt. Philip PUBLISHER Alamaki, Joseph quILISHE PUBLISHER CITY Harmon, Willie 10 Sauk Ciry, Wisconsin Arkham Huuse Pull. Rheingold. Howand New York Arcade Publishing AP Owen. Barbara 12 end Alinon- Wesley Realing. Masachusetts Williama. Peter 13 Bantam Books New York Kalka. Frans 14 Baston bod a fraser BF Novalis 15 Las Angeles Jeremy P. Tarcher JT Lovecraft, H. P. MePherson and Co. Kingston Paz, Otavio 17 New York Packet Baoke PB Camus. Alls I8 New York Random House 19 Castleman, Riva Rirnoli New York Zinlarda. Philip New York 20 Schoken Ikoks sa New York Gimferrer. Pere 21 SI Signet Thames and Hluln New York 22 Southworth. Rod TIH wW. Narton and Ca WN New Yark 25 Wray, Robert Figure 2.4 Collection oF tables
