Question 1

The table named ____________________ stores information about condo locations for Solmaris Condominium Group.​

Accepted Answer

The answer of The table named ____________________ stores information about...

Question 2

A(n)____________________ is a structure that contains different categories of information and the relationships between these categories.​

Accepted Answer

The answer of A(n)____________________ is a structure that contains different...

Question 3

Colonial Adventure Tours offers biking,hiking,and paddling trips.​

Accepted Answer

A) True 
 B)False

Question 4

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at TAL Distributors were combined?​

Accepted Answer

The answer of List the three practical issues that would...

Question 5

At Solmaris Condominium Group,condo units are numbered differently at each location.​

Accepted Answer

A) True 
 B)False

Question 6

The ORDERS table consists of the order number,order date,and ____.​

Accepted Answer

A) item number 
B) ​number ordered 
C) customer number 
D) ​unit price

Question 7

A category name uniquely identifies each service that Solmaris performs​

Accepted Answer

A) True 
 B)False

Question 8

Each order line at TAL Distributors contains a total,usually called a(n)____________________.​

Accepted Answer

The answer of Each order line at TAL Distributors contains...

Question 9

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

Accepted Answer

A) total sales 
B) ​commission rate 
C) customers 
D) ​order number

Question 10

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.​

Accepted Answer

A) True 
 B)False

Question 11

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.​

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The item description is stored with the information about items.​

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) RESERVATION 
B) ​TRIP_GUIDES 
C) TRIP 
D) ​GUIDE

Question 15

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

Accepted Answer

A) True 
 B)False

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

The table named ____________________ stores information about condo locations for Solmaris Condominium Group.​

A(n)____________________ is a structure that contains different categories of information and the relationships between these categories.​

Colonial Adventure Tours offers biking,hiking,and paddling trips.​

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at TAL Distributors were combined?​

At Solmaris Condominium Group,condo units are numbered differently at each location.​

The ORDERS table consists of the order number,order date,and ____.​

A category name uniquely identifies each service that Solmaris performs​

Each order line at TAL Distributors contains a total,usually called a(n)____________________.​

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

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.​

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.​

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

The item description is stored with the information about items.​

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

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

The table named ____________________ stores information about condo locations for Solmaris Condominium Group.

A(n)____________________ is a structure that contains different categories of information and the relationships between these categories.

Colonial Adventure Tours offers biking,hiking,and paddling trips.

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at TAL Distributors were combined?

At Solmaris Condominium Group,condo units are numbered differently at each location.

The ORDERS table consists of the order number,order date,and ____.

A category name uniquely identifies each service that Solmaris performs

Each order line at TAL Distributors contains a total,usually called a(n)____________________.

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

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.

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.

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

The item description is stored with the information about items.

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

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