Database principles

Assignment #3-Relational Data Retrieval-SQL Read chapter 4 carefully and do the following tasks. 1. The Henry Books Store. Ray Henry is the owner of a bookstore chain named Henry Books. Ray has decided to store his data in a database. He wants to ensure that his data is current and accurate. He also needs to create forms to interact with the data and to produce reports from that data. In addition, he wants to be able to ask questions concerning the data and to obtain answers to these questions easily and quickly Consider the following relational database that Henry uses to keep track of information about his bookstore chain including branches, publishers, authors, and books. Branch number (BRANCH NUM), publisher code (PUBLISHER CODE), author number (AUTHOR_NUM), and book code (BOOK CODE) are all unique fields. In addition, books are categorized by using the following types. (ART - Art, CMP-Computer Science, FIC-Fiction, HIS History, HOR - Horror, MYS-Mystery, PHI Philosophy, POE Poetry, PSY - Psychology, SCI-Science, SFI- Science Fiction, TRA Travel) a. Branch Table NUM-EMPLOYEES 10 15 BRANCH-NUM BRANCH-NAME BRANCH-LOCAT?O Henry Downtown 16 Riverview Henry On The Hill 1289 Bedford Henry Brentwood Brentwood Mall Henry Eastshore Eastshore Mall b. Publisher Table PUBLISHER NAME Arkham House Arcade PublishingNew York Basic Books Berkley Publishing Boston Back Bay Books Course Technology Boston Faweett Books Farrar Straus and Giroux New York HarperCollins Publishers New York Jove Publications Jeremy P. Tarcher Lb Books McPherson and Co.Kingston Penguin USA AH Sauk City W Boulder CO New York BP BY FA New Yorik HC New York Los Angeles New York New York