Which of the following tables relates guides to trips?

	a.	TRIP
	b.	RESERVATION
	c.	GUIDE
	d.	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 ____.

	a.	Colorado
	b.	New England
	c.	Virginia
	d.	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.

	a.	TRIP
	b.	GUIDE
	c.	RESERVATION
	d.	TRIP_GUIDES

4 points

QUESTION 11

TAL Distributors sells ____.

	a.	appliances, housewares, and sporting goods
	b.	electronic games
	c.	wooden toys, games, and puzzles
	d.	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 ____.

	a.	wholesale price
	b.	item description
	c.	item color
	d.	item weight

4 points

QUESTION 14

At TAL Distributors, the body of the order contains the order number and date; the customers 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.

	a.	2
	b.	4
	c.	5
	d.	3

4 points

QUESTION 20

Solmaris manages _____ condo locations.

	a.	5
	b.	2
	c.	4
	d.	3

4 points

QUESTION 21

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

	a.	commission rate
	b.	customers
	c.	total sales
	d.	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.

	a.	SERVICE_DESCRIPTION
	b.	STATUS
	c.	CATEGORY_DESCRIPTION
	d.	DESCRIPTION

4 points

QUESTION 23

When designing tables a ____ structure is preferred.

	a.	complex
	b.	simple
	c.	detailed
	d.	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