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.
Category | exam bundles |
Comments | 0 |
Rating | |
Sales | 0 |