Which of the following tables relates guides to trips? TRIP RESERVATION GUIDE TR

Question

Which of the following tables relates guides to trips?

TRIP

RESERVATION

GUIDE

TRIP_GUIDES

4 points   

QUESTION 2

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

True

False

4 points   

QUESTION 3

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

True

False

4 points   

QUESTION 4

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

True

False

4 points   

QUESTION 5

Solmaris provides a variety of maintenance services for a fee.

True

False

4 points   

QUESTION 6

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

True

False

4 points   

QUESTION 7

Colonial Adventure Tours organizes day-long guided trips to ____.

Colorado

New England

Virginia

Pennsylvania

4 points   

QUESTION 8

The SERVICE_CATEGORY table in the Solmaris Condominium Group database includes the service fee

True

False

4 points   

QUESTION 9

TAL Distributors sells appliances, toys, and kitchen gadgets.

True

False

4 points   

QUESTION 10

The _____ table includes the maximum number of people that can participate in a trip in the Colonial Adventure Tours database.

TRIP

GUIDE

RESERVATION

TRIP_GUIDES

4 points   

QUESTION 11

TAL Distributors sells ____.

appliances, housewares, and sporting goods

electronic games

wooden toys, games, and puzzles

furniture

4 points   

QUESTION 12

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

True

False

4 points   

QUESTION 13

Each line in the TAL Distributors order form contains an item number, the number of units of the ordered item, the quoted price, and ____.

wholesale price

item description

item color

item weight

4 points   

QUESTION 14

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

4 points   

QUESTION 15

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

4 points   

QUESTION 16

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

True

False

4 points   

QUESTION 17

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

True

False

4 points   

QUESTION 18

The item description is stored with the information about items.

True

False

4 points   

QUESTION 19

An owner number in the OWNER table at Solmaris Condominium consists of ____ uppercase letters followed by a three-digit number.

2

4

5

3

4 points   

QUESTION 20

Solmaris manages _____ condo locations.

5

2

4

3

4 points   

QUESTION 21

The REP table consists of the sales representatives’ number, last name, first name, address, total commission, and ____.

commission rate

customers

total sales

order number

4 points   

QUESTION 22

The _____ field of the SERVICE_REQUEST table in the Solmaris Condominium Group database gives a description of the specific service to be performed.

SERVICE_DESCRIPTION

STATUS

CATEGORY_DESCRIPTION

DESCRIPTION

4 points   

QUESTION 23

When designing tables a ____ structure is preferred.

complex

simple

detailed

complete

4 points   

QUESTION 24

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

True

False

4 points   

QUESTION 25

Each guide is uniquely identified by his or her GUIDE_NUM.

True

False

a.

TRIP

b.

RESERVATION

c.

GUIDE

d.

TRIP_GUIDES

Explanation / Answer

Which of the following tables relates guides to trips?

Ans: d. TRIP_GUIDES.

QUESTION 2

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

Ans: False.

QUESTION 3

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

Ans: True

QUESTION 4

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

Ans: False.

QUESTION 5

Solmaris provides a variety of maintenance services for a fee.

Ans:True.

QUESTION 6

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

Ans: True

QUESTION 7

Colonial Adventure Tours organizes day-long guided trips to ____

Ans: b. New England

QUESTION 8

The SERVICE_CATEGORY table in the Solmaris Condominium Group database includes the service fee

Ans: False.

QUESTION 9

TAL Distributors sells appliances, toys, and kitchen gadgets.

Ans:TFalse

QUESTION 10

The _____ table includes the maximum number of people that can participate in a trip in the Colonial Adventure Tours database.

Ans: TRIP

QUESTION 11

TAL Distributors sells ____.

Ans: wooden toys, games, and puzzles

QUESTION 12

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

Ans: True.

QUESTION 13

Each line in the TAL Distributors order form contains an item number, the number of units of the ordered item, the quoted price, and ____.

An: b. item description

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.