A Guide to SQL 8e Philip Pratt, Mary Last All Chapters, Original , Answers At The End Of Each Chapter Complete And Study material 72pages LEARNEXAMS

Chapter 01 True/False Indicate whether the statement is true or false. ____ 1. Premiere Products sells appliances, toys, and kitchen gadgets. ____ 2. An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers. ____ 3. At Premiere Products, the body of the order contains the order number and date; the customer’s number, name, and address; and the sales rep number and name. ____ 4. At Premiere Products, the three sections of an order are the heading, body, and footing. ____ 5. The overall order total is stored in the Premiere Products database. ____ 6. The customer’s name and address and the number of the sales rep who represents the customer are stored with sales rep information. ____ 7. The part description is stored with the information about parts. ____ 8. All the sales representatives at Premiere Products get the same commission rate. ____ 9. Each row in the ORDER_LINE table has an order number, part number, number ordered, quoted price, and total amount. ____ 10. The Premiere Products database includes four tables. ____ 11. The ORDER_LINE table in the Premiere Products database contains information about the date an order was placed. ____ 12. In some database systems, the word “order” has a special purpose. ____ 13. Because Premiere Products wants the flexibility to quote and charge different prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table. ____ 14. Each branch of Henry Books has a number that uniquely identifies the branch. ____ 15. The Henry Books database uses a two-digit number to represent the publisher code. ____ 16. In the Henry Books database, the AUTHOR table contains the author's number, name, and address. ____ 17. Each author is uniquely identified by his or her AUTHOR_NUM. ____ 18. The BOOK table at Henry Books includes the author number. ____ 19. The WROTE table in the Henry Books database relates publishers and books.