Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 1
1. TAL Distributors sells appliances, toys, and kitchen gadgets.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
2
2. An example of a relationship between categories is the relationship that exists in the TAL Distributors database
between sales reps and customers.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
3. 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.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
3
4. At TAL Distributors, the three sections of an order are the heading, body, and footing.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
5. The overall order total is stored in the TAL Distributors database.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
4
6. The customer’s name and address and the number of the sales rep who represents the customer are stored with sales rep
information.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
4
7. The item description is stored with the information about items.
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 2
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
8. All the sales representatives at TAL Distributors get the same commission rate.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
4
9. Each row in the ORDER_LINE table has an order number, item number, number ordered, quoted price, and total
amount.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
5
10. The TAL Distributors database includes four tables.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
4/5
11. The ORDER_LINE table in the TAL Distributors database contains information about the date an order was placed.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
5
12. In some database systems, the word “order” has a special purpose.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
13. 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.
a.
True
b.
False
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 3
ANSWER:
POINTS:
REFERENCES:
14. Each trip that Colonial Adventure Tours offers has a number that uniquely identifies the trip.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
15. The Colonial Adventure Tours database uses a two-digit number to represent the guide number.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
9
16. In the Colonial Adventure Tours database, the GUIDE table contains the guide’s number, name, address, and salary.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
9
17. Each guide is uniquely identified by his or her GUIDE_NUM.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
18. The TRIP table at Colonial Adventure Tours includes the guide number.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
10
19. The TRIP table in the Colonial Adventure Tours database includes a column for the trip cost.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
10
Cengage Learning Testing, Powered by Cognero
Page 4
20. Colonial Adventure Tours offers biking, hiking, and paddling trips.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
21. The CUSTOMER table in the Colonial Adventure Tours database includes a column for the trip date.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
11
22. The reservation ID in the RESERVATION table in the Colonial Adventure Tours database is presented as a three-digit
number.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
11
23. In the Colonial Adventure Tours database, the table named RESERVATION contains information about trip cost and
other fees.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
24. The TRIP_GUIDES table in the Colonial Adventure Tours database has three columns.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
13
25. The TRIP_GUIDES table in the Colonial Adventure Tours database is used to relate trips and guides.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
26. The Solmaris Condominium Group database uses a combination of letters and numbers to represent an owner number.
a.
True
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 5
b.
False
ANSWER:
POINTS:
REFERENCES:
27. Solmaris provides a variety of maintenance services for a fee.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
28. At Solmaris Condominium Group, condo units are numbered differently at each location.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
29. The SERVICE_CATEGORY table in the Solmaris Condominium Group database includes the service fee
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
16
30. A category name uniquely identifies each service that Solmaris performs
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
16
31. TAL Distributors sells ____.
a.
furniture
b.
wooden toys, games, and puzzles
c.
appliances, housewares, and sporting goods
d.
electronic games
ANSWER:
b
POINTS:
1
REFERENCES:
2
32. The order line in a TAL Distributors order form contains a total that is called a(n) ____.
a.
footing
b.
extension
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 6
c.
trailer
d.
sum
ANSWER:
b
POINTS:
1
REFERENCES:
3
33. 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
ANSWER:
b
POINTS:
1
REFERENCES:
3
34. How many tables make up the TAL Distributors database?
a.
4
b.
5
c.
6
d.
7
ANSWER:
b
POINTS:
1
REFERENCES:
4/5
35. 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
ANSWER:
b
POINTS:
1
REFERENCES:
4
36. The ORDERS table consists of the order number, order date, and ____.
a.
item number
b.
number ordered
c.
customer number
d.
unit price
ANSWER:
c
POINTS:
1
REFERENCES:
5
37. When designing tables a ____ structure is preferred.
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 7
a.
complex
b.
simple
c.
detailed
d.
complete
ANSWER:
b
POINTS:
1
REFERENCES:
7
38. 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
ANSWER:
d
POINTS:
1
REFERENCES:
7
39. Colonial Adventure Tours organizes day-long guided trips to ____.
a.
Colorado
b.
New England
c.
Virginia
d.
Pennsylvania
ANSWER:
b
POINTS:
1
REFERENCES:
8
40. The TRIP, GUIDE, and ____ tables are part of the Colonial Adventure Tours database.
a.
SALES
b.
LOCATION
c.
CUSTOMER
d.
REP
ANSWER:
c
POINTS:
1
REFERENCES:
9/11
41. 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
ANSWER:
c
POINTS:
1
REFERENCES:
10
Cengage Learning Testing, Powered by Cognero
Page 8
42. Colonial Adventure Tours offers three types of trips; hiking, biking, and _____.
a.
downhill skiing
b.
cross country skiing
c.
zip lining
d.
paddling
ANSWER:
d
POINTS:
1
REFERENCES:
10
43. Which of the following tables relates guides to trips?
a.
TRIP
b.
GUIDE
c.
TRIP_GUIDES
d.
RESERVATION
ANSWER:
c
POINTS:
1
REFERENCES:
13
44. Solmaris stores information about its condo locations in the _____ table.
a.
CONDO
b.
CONDO_UNIT
c.
LOCATION
d.
OWNER
ANSWER:
c
POINTS:
1
REFERENCES:
15
45. Solmaris manages _____ condo locations.
a.
2
b.
3
c.
4
d.
5
ANSWER:
a
POINTS:
1
REFERENCES:
14
46. 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
ANSWER:
b
POINTS:
1
REFERENCES:
16
Cengage Learning Testing, Powered by Cognero
Page 9
47. 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
ANSWER:
a
POINTS:
1
REFERENCES:
15
48. 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
ANSWER:
c
POINTS:
1
REFERENCES:
16
49. 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
ANSWER:
b
POINTS:
1
REFERENCES:
17
50. Information about the services requested by Solmaris owners is stored in the ____ table.
a.
LOCATION
b.
CONDO_UNIT
c.
SERVICE_REQUEST
d.
OWNER
ANSWER:
c
POINTS:
1
REFERENCES:
16
51. A(n) ____________________ is a structure that contains different categories of information and the relationships
between these categories.
ANSWER:
database
POINTS:
1
REFERENCES:
1
52. The TAL Distributors database contains information that relates sales reps to the customers they represent and
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 10
customers to the ____________________ they have placed.
ANSWER:
orders
POINTS:
1
REFERENCES:
2
53. Each order line at TAL Distributors contains a total, usually called a(n) ____________________.
ANSWER:
extension
POINTS:
1
REFERENCES:
3
54. The body of the order for TAL Distributors contains one or more order lines, sometimes called line
____________________.
ANSWER:
items
POINTS:
1
REFERENCES:
3
55. 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.
ANSWER:
heading
POINTS:
1
REFERENCES:
3
56. The computer calculates the ____________________ for TAL Distributors whenever an order is printed or displayed
on the screen.
ANSWER:
total
order total
overall order total
POINTS:
1
REFERENCES:
4
57. The three components of a TAL Distributors order are the heading, ____________________, and footing.
ANSWER:
body
POINTS:
1
REFERENCES:
7
58. The customer number appears in the CUSTOMER table and the ____________________ table in the TAL
Distributors database.
ANSWER:
ORDERS
POINTS:
1
REFERENCES:
3
59. The item number appears in the ITEM table and the ____________________ table in the TAL Distributors database.
ANSWER:
ORDER_LINE
POINTS:
1
REFERENCES:
5
60. The order number appears in the ORDERS table and the ____________________ table in the TAL Distributors
database.
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 11
ANSWER:
ORDER_LINE
POINTS:
1
REFERENCES:
9
61. Colonial Adventure Tours gathers and organizes information about guides, trips, customers, and
____________________.
ANSWER:
reservations
POINTS:
1
REFERENCES:
9
62. In the Colonial Adventure Tours database, each guide is uniquely identified by a(n) ____________________.
ANSWER:
guide number
number
GUIDE_NUM
POINTS:
1
REFERENCES:
9
63. 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
____________________.
ANSWER:
season
POINTS:
1
REFERENCES:
9
64. Colonial Adventure Tours offers three types of guided trips; ____________________, biking, and paddling.
ANSWER:
hiking
POINTS:
1
REFERENCES:
9
65. The date for a particular trip is stored in the ____________________ table in the Colonial Adventure Tours database.
ANSWER:
RESERVATION
POINTS:
1
REFERENCES:
11
66. 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.
ANSWER:
two
2
POINTS:
1
REFERENCES:
11
67. Colonial Adventure Tours uses the ____________________ field in the RESERVATION table to store any additional
fees for transportation and equipment.
ANSWER:
OTHER_FEES
POINTS:
1
REFERENCES:
12
68. The table named ____________________ is used to relate trips and guides in the Colonial Adventure Tours database.
Chapter 1: Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group
Cengage Learning Testing, Powered by Cognero
Page 12
ANSWER:
TRIP_GUIDES
POINTS:
1
REFERENCES:
132
69. The table named ____________________ stores information about condo locations for Solmaris Condominium
Group.
ANSWER:
LOCATION
POINTS:
1
REFERENCES:
13
70. The owner number appears in the OWNER table and the ____________________ table in the Solmaris Condominium
Group database.
ANSWER:
CONDO_UNIT
POINTS:
1
REFERENCES:
15/16
71. If another appointment is required to complete additional service, the appointment date appears in the
NEXT_SERVICE_DATE column of the ____________________ table of Solmaris.
ANSWER:
SERVICE_REQUEST
POINTS:
1
REFERENCES:
16
72. The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the
Solmaris Condominium Group database.
ANSWER:
SERVICE_REQUEST
POINTS:
1
REFERENCES:
17
73. Why does the TAL Distributors database use the table ORDERS instead of ORDER?
ANSWER:
In some database systems, the word order has a special purpose. Having a table named ORDER could
cause problems in such systems.
POINTS:
1
REFERENCES:
6
74. Why would you not combine the two tables ORDERS and ORDER_LINE at TAL Distributors?
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.
POINTS:
1
REFERENCES:
6/7
75. 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?
ANSWER:
How much room do you allow for multiple entries?
What if an order has more order lines than you have allowed room for?
Given an item, how do you determine which orders contain order lines for that item?
POINTS:
1