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

Question 1

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

Answer 1

True

Question 2

TAL Distributors sells appliances,toys,and kitchen gadgets.​

Answer 2

False

Question 3

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

Answer 3

True

Question 4

In the Colonial Adventure Tours database,the GUIDE table contains the guide's number,name,address,and salary.​

Question 5

An example of a relationship between categories is the relationship that exists in the TAL Distributors database between sales reps and customers.​

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

The TRIP table at Colonial Adventure Tours includes the guide number.​

Question 14

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

Question 15

All the sales representatives at TAL Distributors get the same commission rate.​

Question 16

At TAL Distributors,the three sections of an order are the heading,body,and footing.​

Question 17

Each trip that Colonial Adventure Tours offers has a number that uniquely identifies the trip.​

Question 18

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

Question 19

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

Question 20

The TAL Distributors database includes four tables.​

Question 21

The order line in a TAL Distributors order form contains a total that is called a(n)____.​

A)footing
B)​extension
C)trailer
D)​sum

Question 22

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

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

Question 23

A category name uniquely identifies each service that Solmaris performs​

Question 24

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

Question 25

The TRIP_GUIDES table in the Colonial Adventure Tours database has three columns.​

Question 26

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 weight
D)​item color

Question 27

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

Question 28

Solmaris provides a variety of maintenance services for a fee.​

Question 29

How many tables make up the TAL Distributors database?​

A)4
B)​5
C)6
D)​7

Question 30

The TRIP,GUIDE,and ____ tables are part of the Colonial Adventure Tours database.​

A)SALES
B)​LOCATION
C)CUSTOMER
D)​REP

Question 31

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

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

Question 32

The Solmaris Condominium Group database uses a combination of letters and numbers to represent an owner number.​

Question 33

When designing tables a ____ structure is preferred.​

A)complex
B)​simple
C)detailed
D)​complete

Question 34

The reservation ID in the RESERVATION table in the Colonial Adventure Tours database is presented as a three-digit number.​

Question 35

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

Question 36

TAL Distributors sells ____.​

A)furniture
B)​wooden toys,games,and puzzles
C)appliances,housewares,and sporting goods
D)​electronic games

Question 37

Combining the ORDER_LINE and ORDERS tables will ____.​

A)save space in the table
B)​make the table more effective
C)increase space in the table
D)​make the table more complicated

Question 38

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

Question 39

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

A)Colorado
B)​New England
C)Virginia
D)​Pennsylvania

Question 40

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

Question 41

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

A)LOCATION
B)​CONDO_UNIT
C)SERVICE_REQUEST
D)​OWNER

Question 42

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

Question 43

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

Question 44

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

Question 45

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

A)CONDO
B)​CONDO_UNIT
C)LOCATION
D)​OWNER

Question 46

Which of the following tables relates guides to trips?​

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

Question 47

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

Question 48

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

Question 49

Solmaris manages _____ condo locations.​

A)2
B)​3
C)4
D)​5

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

A)downhill skiing
B)​cross country skiing
C)zip lining
D)​paddling

Question 58

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

Question 59

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

Question 60

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

Question 61

If another appointment is required to complete additional service,the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Solmaris.​

Question 62

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

Question 63

The date for a particular trip is stored in the ____________________ table in the Colonial Adventure Tours database.​

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

Colonial Adventure Tours offers three types of guided trips;____________________,biking,and paddling.​

Question 69

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

Question 70

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

Question 71

Colonial Adventure Tours gathers and organizes information about guides,trips,customers,and ____________________.​

Question 72

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

Question 73

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

Question 74

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

Question 75

Colonial Adventure Tours uses the ____________________ field in the RESERVATION table to store any additional fees for transportation and equipment.​