Improve the accuracy of the data entry process by adding some input controls to the database. The following are the examples. All Book Type and Publisher Code entries should be uppercase. The Book Title, Publisher Code, and Author fields are required. Publisher Code entries should match the entries in the Publisher Table v. SOFT and HARD are the only choices for the cover type.
Most books are paperback.
Any letters entered in the Book Code field are in uppercase. However, the book publisher is not in the Publisher table. Add the book to the database. The book title is Runaway Hero by Megan Tustan, and it is fiction. Delete all science fiction books from the database.