Question 1

Information about the services requested by Solmaris owners is stored in the ____ table.​
A)LOCATION
B)​CONDO_UNIT
C)SERVICE_REQUEST
D)​OWNER

Accepted Answer

The services requested by Solmaris owners are stored in the SERVICE_REQUEST table.

Question 2

The _____ table includes the maximum number of people that can participate in a trip in the Colonial Adventure Tours database.​
A)RESERVATION
B)​TRIP_GUIDES
C)TRIP
D)​GUIDE

Accepted Answer

The TRIP table would likely include information about each trip offered by Colonial Adventure Tours, including the maximum number of people who can participate in each trip. The RESERVATION table would likely include information about customers who have booked a specific trip, while the TRIP_GUIDES and GUIDE tables would likely include information about the guides who lead the trips.

Question 3

The computer calculates the ____________________ for TAL Distributors whenever an order is printed or displayed on the screen.​

Accepted Answer

The answer of The computer calculates the ____________________ for TAL...

Question 4

The TAL Distributors database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.​

Accepted Answer

The answer of The TAL Distributors database contains information that...

Question 5

Solmaris stores information about its condo locations in the _____ table.​
A)CONDO
B)​CONDO_UNIT
C)LOCATION
D)​OWNER

Accepted Answer

The best choice would be the LOCATION table, as it would contain information about Solmaris' condo locations. The CONDO table might contain information about individual condos, but not necessarily their locations. The CONDO_UNIT table would likely contain information about specific units within a condo building. The OWNER table would pertain to information about condo owners, which is not directly relevant to the location of the condos themselves.

Question 6

Which of the following tables relates guides to trips?​
A)TRIP
B)​GUIDE
C)TRIP_GUIDES
D)​RESERVATION

Accepted Answer

A table named "TRIP_GUIDES" is the most appropriate choice as it directly relates the guides to the trips they are associated with. A "TRIP" table may contain information about trips such as dates and locations, while a "GUIDE" table may contain information about individual guides. A "RESERVATION" table may contain information about reservations made by customers, but does not directly relate to guides and trips.

Question 7

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 8

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 9

Solmaris manages _____ condo locations.​
A)2
B)​3
C)4
D)​5

Accepted Answer

Solmaris manages 2 condo locations.

Question 10

Each row in the table CONDO_UNIT table at Solmaris contains a condo _____ that identifies the particular condo.​
A)sequence
B)​ID
C)name
D)​owner

Accepted Answer

The most common and appropriate identifier for a condo unit is an ID. IDs are unique and can easily differentiate one condo unit from another. Sequences are typically used to generate unique numbers, but they may not necessarily be identifiers. Names and owners may not be unique to a single condo unit and can be easily duplicated, leading to confusion and errors.

Question 11

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

The answer of The ____________________ of the order form at...

Question 12

Solmaris Condominium Group provides maintenance service for owners at its two condo locations.The SERVICE_CATEGORY table contains a _____.​
A)condo ID
B)​location number
C)description of the category
D)​location name

Accepted Answer

The SERVICE_CATEGORY table contains a description of the category for maintenance services provided by Solmaris Condominium Group. The other options (condo ID, location number, and location name) are not relevant to describing maintenance categories.

Question 13

The customer number appears in the CUSTOMER table and the ____________________ table in the TAL Distributors database.​

Accepted Answer

The answer of The customer number appears in the CUSTOMER...

Question 14

The _____ field of the SERVICE_REQUEST table in the Solmaris Condominium Group database gives a description of the specific service to be performed.​
A)STATUS
B)​DESCRIPTION
C)CATEGORY_DESCRIPTION
D)​SERVICE_DESCRIPTION

Accepted Answer

The answer of The _____ field of the SERVICE_REQUEST table...

Question 15

The three components of a TAL Distributors order are the heading,____________________,and footing.​

Accepted Answer

The answer of The three components of a TAL Distributors...

Question 16

The item number appears in the ITEM table and the ____________________ table in the TAL Distributors database.​

Accepted Answer

The answer of The item number appears in the ITEM...

Question 17

Colonial Adventure Tours offers three types of trips;hiking,biking,and _____.​
A)downhill skiing
B)​cross country skiing
C)zip lining
D)​paddling

Accepted Answer

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

Question 18

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 19

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 20

An owner number in the OWNER table at Solmaris Condominium consists of ____ uppercase letters followed by a three-digit number.​
A)2
B)​3
C)4
D)​5

Accepted Answer

The answer of An owner number in the OWNER table...

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

Information about the services requested by Solmaris owners is stored in the ____ table.​

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

The computer calculates the ____________________ for TAL Distributors whenever an order is printed or displayed on the screen.​

The TAL Distributors database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.​

Solmaris stores information about its condo locations in the _____ table.​

Which of the following tables relates guides to trips?​

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

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

Solmaris manages _____ condo locations.​

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

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

Solmaris Condominium Group provides maintenance service for owners at its two condo locations.The SERVICE_CATEGORY table contains a _____.​

The customer number appears in the CUSTOMER table and the ____________________ table in the TAL Distributors database.​

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

The three components of a TAL Distributors order are the heading,____________________,and footing.​

The item number appears in the ITEM table and the ____________________ table in the TAL Distributors database.​

Colonial Adventure Tours offers three types of trips;hiking,biking,and _____.​

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

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

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

Information about the services requested by Solmaris owners is stored in the ____ table.

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

The computer calculates the ____________________ for TAL Distributors whenever an order is printed or displayed on the screen.

The TAL Distributors database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.

Solmaris stores information about its condo locations in the _____ table.

Which of the following tables relates guides to trips?

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

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

Solmaris manages _____ condo locations.

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

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.

Solmaris Condominium Group provides maintenance service for owners at its two condo locations.The SERVICE_CATEGORY table contains a _____.

The customer number appears in the CUSTOMER table and the ____________________ table in the TAL Distributors database.

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

The three components of a TAL Distributors order are the heading,____________________,and footing.

The item number appears in the ITEM table and the ____________________ table in the TAL Distributors database.

Colonial Adventure Tours offers three types of trips;hiking,biking,and _____.

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

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

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