Cengage Learning Testing, Powered by Cognero Page 1

Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group Cengage Learning Testing, Powered by Cognero Page 1 1.TAL Distributors sells appliances, toys, and kitchen gadgets.

• True
• 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.

• True
• 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.

• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 3

4.At TAL Distributors, the three sections of an order are the heading, body, and footing.

• True
• False

ANSWER: True

POINTS: 1

REFERENCES: 3

5.The overall order total is stored in the TAL Distributors database.

• True
• 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.

• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 4

7.The item description is stored with the information about items.A Guide to SQL 9e Philip Pratt, Mary Last (Test Bank All Chapters, 100% Original Verified, A+ Grade) 1 / 4

Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group Cengage Learning Testing, Powered by Cognero Page 2

• True
• False

ANSWER: True

POINTS: 1

REFERENCES: 4

8.All the sales representatives at TAL Distributors get the same commission rate.

• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 4

9.Each row in the ORDER_LINE table has an order number, item number, number ordered, quoted price, and total amount.

• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 5

10.The TAL Distributors database includes four tables.

• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 4/5

11.The ORDER_LINE table in the TAL Distributors database contains information about the date an order was placed.

• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 5

12.In some database systems, the word “order” has a special purpose.

• True
• False

ANSWER: True

POINTS: 1

REFERENCES: 6

13.Because TAL Distributors wants the flexibility to quote and charge different prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table.

• True
• False 2 / 4

Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Cengage Learning Testing, Powered by Cognero Page 3

ANSWER: True

POINTS: 1

REFERENCES: 8

• Each trip that Colonial Adventure Tours offers has a number that uniquely identifies the trip.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: 9

• The Colonial Adventure Tours database uses a two-digit number to represent the guide number.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 9

• In the Colonial Adventure Tours database, the GUIDE table contains the guide’s number, name, address, and salary.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 9

• Each guide is uniquely identified by his or her GUIDE_NUM.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: 9

• The TRIP table at Colonial Adventure Tours includes the guide number.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 10

• The TRIP table in the Colonial Adventure Tours database includes a column for the trip cost.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 10

• / 4

Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Cengage Learning Testing, Powered by Cognero Page 4

• Colonial Adventure Tours offers biking, hiking, and paddling trips.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: 11

• The CUSTOMER table in the Colonial Adventure Tours database includes a column for the trip date.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 11

• The reservation ID in the RESERVATION table in the Colonial Adventure Tours database is presented as a three-digit

number.

• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 11

• In the Colonial Adventure Tours database, the table named RESERVATION contains information about trip cost and

other fees.

• True
• False

ANSWER: True

POINTS: 1

REFERENCES: 12

• The TRIP_GUIDES table in the Colonial Adventure Tours database has three columns.
• True
• False

ANSWER: False

POINTS: 1

REFERENCES: 13

• The TRIP_GUIDES table in the Colonial Adventure Tours database is used to relate trips and guides.
• True
• False

ANSWER: True

POINTS: 1

REFERENCES: 13

• The Solmaris Condominium Group database uses a combination of letters and numbers to represent an owner number.
• True
• / 4