Question 1

The body of the order for TAL Distributors contains one or more order lines,sometimes called line ____________________.​

Accepted Answer

The answer of The body of the order for TAL...

Question 2

When designing tables a ____ structure is preferred.​

Accepted Answer

A)  complex
B)  ​simple
C)  detailed
D)  ​completeE) None of the above
F) A) and B)

Question 3

Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.​

Accepted Answer

The answer of Colonial Adventure Tours identifies each reservation by...

Question 4

The ____________________ of the order form at TAL Distributors contains the order number and date;the customer's number,name,and address;and the sales rep's number and name.​

Accepted Answer

heading​

Question 5

In the Colonial Adventure Tours database,each guide is uniquely identified by a(n)____________________.​

Accepted Answer

guide
numb...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium Group database.​

Accepted Answer

The answer of The owner number appears in the OWNER...

Question 8

Solmaris manages _____ condo locations.​

Accepted Answer

A)  2
B)  ​3
C)  4
D)  ​5E) All of the above
F) C) and D)

Question 9

Combining the ORDER_LINE and ORDERS tables will ____.​

Accepted Answer

A)  save space in the table
B)  ​make the table more effective
C)  increase space in the table
D)  ​make the table more complicatedE) A) and D)
F) None of the above

Question 10

In some database systems,the word "order" has a special purpose.​

Accepted Answer

A) True 
 B)False

Question 11

Each guide is uniquely identified by his or her GUIDE_NUM.​

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Solmaris Condominium Group database.​

Accepted Answer

The answer of The category number appears in the SERVICE_CATEGORY...

Question 14

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.​

Accepted Answer

A)  sequence
B)  ​ID
C)  name
D)  ​ownerE) C) and D)
F) B) and D)

Question 15

The TAL Distributors database includes four tables.​

Accepted Answer

A) True 
 B)False

Question 16

Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?​

Accepted Answer

If the two tables were combined,the new table would be more complicated.Some of the individual positions within this table will contain multiple entries,making it difficult to track the information between columns.In general,the simpler structure is preferable,and that is why order lines appear in a separate table.​

Question 17

The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors database.​

Accepted Answer

The answer of The order number appears in the ORDERS...

Question 18

In addition to the trip ID,Colonial Adventure Tours tracks the trip name,the trip's starting location,the state in which the trip originates,the trip's total distance,the trip's maximum group size,the trip's type,and the trip's ____________________.​

Accepted Answer

The answer of In addition to the trip ID,Colonial Adventure...

Question 19

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

Accepted Answer

A) True 
 B)False  False

Question 20

Why does the TAL Distributors database use the table ORDERS instead of ORDER?​

Accepted Answer

In some database systems,the w...

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

The body of the order for TAL Distributors contains one or more order lines,sometimes called line ____________________.

Correct Answer
verified

When designing tables a ____ structure is preferred.

Correct Answer
verified

Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.

Correct Answer
verified

The ____________________ of the order form at TAL Distributors contains the order number and date;the customer's number,name,and address;and the sales rep's number and name.

Correct Answer
verified
heading

In the Colonial Adventure Tours database,each guide is uniquely identified by a(n)____________________.

Correct Answer
verified
guide
numb...
View Answer

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

Correct Answer
verified

The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium Group database.

Correct Answer
verified

Solmaris manages _____ condo locations.

Correct Answer
verified

Combining the ORDER_LINE and ORDERS tables will ____.

Correct Answer
verified

In some database systems,the word "order" has a special purpose.

Correct Answer
verified

Each guide is uniquely identified by his or her GUIDE_NUM.

Correct Answer
verified

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

Correct Answer
verified

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Solmaris Condominium Group database.

Correct Answer
verified

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.

Correct Answer
verified

The TAL Distributors database includes four tables.

Correct Answer
verified

Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?

The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors database.

Correct Answer
verified

In addition to the trip ID,Colonial Adventure Tours tracks the trip name,the trip's starting location,the state in which the trip originates,the trip's total distance,the trip's maximum group size,the trip's type,and the trip's ____________________.

Correct Answer
verified

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

Correct Answer
verified
False

Why does the TAL Distributors database use the table ORDERS instead of ORDER?

Correct Answer
verified
In some database systems,the w...
View Answer

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

The body of the order for TAL Distributors contains one or more order lines,sometimes called line ____________________.​

Correct AnswerverifiedShow Answer

When designing tables a ____ structure is preferred.​

Correct AnswerverifiedShow Answer

Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.​

Correct AnswerverifiedShow Answer

The ____________________ of the order form at TAL Distributors contains the order number and date;the customer's number,name,and address;and the sales rep's number and name.​

Correct Answerverifiedheading​

In the Colonial Adventure Tours database,each guide is uniquely identified by a(n)____________________.​

Correct Answerverifiedguidenumb...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium Group database.​

Correct AnswerverifiedShow Answer

Solmaris manages _____ condo locations.​

Correct AnswerverifiedShow Answer

Combining the ORDER_LINE and ORDERS tables will ____.​

Correct AnswerverifiedShow Answer

In some database systems,the word "order" has a special purpose.​

Correct AnswerverifiedShow Answer

Each guide is uniquely identified by his or her GUIDE_NUM.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Solmaris Condominium Group database.​

Correct AnswerverifiedShow Answer

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.​

Correct AnswerverifiedShow Answer

The TAL Distributors database includes four tables.​

Correct AnswerverifiedShow Answer

Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?​

The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors database.​

Correct AnswerverifiedShow Answer

In addition to the trip ID,Colonial Adventure Tours tracks the trip name,the trip's starting location,the state in which the trip originates,the trip's total distance,the trip's maximum group size,the trip's type,and the trip's ____________________.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

Why does the TAL Distributors database use the table ORDERS instead of ORDER?​

Correct AnswerverifiedIn some database systems,the w...View AnswerShow Answer

The body of the order for TAL Distributors contains one or more order lines,sometimes called line ____________________.

Correct Answer
verified

When designing tables a ____ structure is preferred.

Correct Answer
verified

Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.

Correct Answer
verified

The ____________________ of the order form at TAL Distributors contains the order number and date;the customer's number,name,and address;and the sales rep's number and name.

Correct Answer
verified
heading

In the Colonial Adventure Tours database,each guide is uniquely identified by a(n)____________________.

Correct Answer
verified
guide
numb...
View Answer

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

Correct Answer
verified

The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium Group database.

Correct Answer
verified

Solmaris manages _____ condo locations.

Correct Answer
verified

Combining the ORDER_LINE and ORDERS tables will ____.

Correct Answer
verified

In some database systems,the word "order" has a special purpose.

Correct Answer
verified

Each guide is uniquely identified by his or her GUIDE_NUM.

Correct Answer
verified

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

Correct Answer
verified

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Solmaris Condominium Group database.

Correct Answer
verified

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.

Correct Answer
verified

The TAL Distributors database includes four tables.

Correct Answer
verified

Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?

The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors database.

Correct Answer
verified

In addition to the trip ID,Colonial Adventure Tours tracks the trip name,the trip's starting location,the state in which the trip originates,the trip's total distance,the trip's maximum group size,the trip's type,and the trip's ____________________.

Correct Answer
verified

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

Correct Answer
verified
False

Why does the TAL Distributors database use the table ORDERS instead of ORDER?

Correct Answer
verified
In some database systems,the w...
View Answer