A Guide to SQL 9e Philip Pratt, Mary Last All Chapters, Original , Complete And Study material 101pages LEARNEXAMS

Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group 1. TAL Distributors sells appliances, toys, and kitchen gadgets. a. True b. False ANSWER: False POINTS: 1 REFERENCES: 2 2. An example of a relationship between categories is the relationship that exists in the TAL Distributors database between sales reps and customers. a. True b. False ANSWER: True POINTS: 1 REFERENCES: 2 3. At TAL Distributors, 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. a. True b. False ANSWER: False POINTS: 1 REFERENCES: 3 4. At TAL Distributors, the three sections of an order are the heading, body, and footing. a. True b. False ANSWER: True POINTS: 1 REFERENCES: 3 5. The overall order total is stored in the TAL Distributors database. a. True b. False ANSWER: False POINTS: 1 REFERENCES: 4 6. The customer’s name and address and the number of the sales rep who represents the customer are stored with sales rep information. a. True b. False ANSWER: False POINTS: 1 REFERENCES: 4 7. The item description is stored with the information about items