A Guide to SQL
10th Edition Mark Shellman, Hassan Afyouni, Philip J. Pratt, Mary Z. Last
Table of Contents:-
Module 1. Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases
Module 2. Database Design Fundamentals
Module 3. Creating Tables
Module 4. Single-Table Queries
Module 5. Multiple-Table Queries
Module 6. Updating Data
Module 7. Database Administration
Module 8. Functions, Procedures and Triggers
,Module 1 - Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases
True / False
1. An example of a relationship between categories in the KimTay database is the relationship between sales reps and customers.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Each database also contains relationships between categories. For example, the KimTay Pet Supplies
database contains information that relates sales reps to the customers they represent and customers to
the invoices they have placed.
Incorrect Each database also contains relationships between categories. For example, the KimTay Pet Supplies
database contains information that relates sales reps to the customers they represent and customers to
the invoices they have placed.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: What Is a Database?
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.1 - Introduce KimTay Pet Supplies, a company whose database is used to manage a pet
supplies business.
KEYWORDS: Bloom's: Remember
2. The StayWell database uses a combination of letters and numbers to identify each resident.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Each owner is identified by a unique owner number that consists of two uppercase letters followed by a
three-digit number.
Incorrect Each owner is identified by a unique owner number that consists of two uppercase letters followed by a
three-digit number.
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: StayWell Student Accommodation Database
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.2 - Introduce StayWell, a Seattle-based company whose database is used to manage
accommodation for university students on behalf of property owners.
KEYWORDS: Bloom's: Remember
3. StayWell organizes a variety of maintenance services for a fee.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Currently, prospective owners and renters need to contact the offices and speak to an administrator on
all matters relating to renting of properties. The office organizes maintenance services for a fee, which is
also currently done via email or direct communication.
Incorrect Currently, prospective owners and renters need to contact the offices and speak to an administrator on
all matters relating to renting of properties. The office organizes maintenance services for a fee, which is
also currently done via email or direct communication.
POINTS: 1
DIFFICULTY: Easy
Page 1
,REFERENCES: StayWell Student Accommodation Database
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.2 - Introduce StayWell, a Seattle-based company whose database is used to manage
accommodation for university students on behalf of property owners.
KEYWORDS: Bloom's: Remember
4. The SERVICE_CATEGORY table in the StayWell database includes the service fees.
a. True
b. False
ANSWER: False
FEEDBACK: Correct The SERVICE_CATEGORY table includes details of maintenance services. The CATEGORY_NUM
provides a unique number for the service, and CATEGORY_DESCRIPTION shows what the service is.
Incorrect The SERVICE_CATEGORY table includes details of maintenance services. The CATEGORY_NUM
provides a unique number for the service, and CATEGORY_DESCRIPTION shows what the service is.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: StayWell Student Accommodation Database
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.2 - Introduce StayWell, a Seattle-based company whose database is used to manage
accommodation for university students on behalf of property owners.
KEYWORDS: Bloom's: Remember
5. StayWell has twelve offices, one to manage each of their twelve rental locations.
a. True
b. False
ANSWER: False
FEEDBACK: Correct StayWell is split into two offices to better manage the properties. This management includes
communicating with owners about the status and upkeep of their properties.
Incorrect StayWell is split into two offices to better manage the properties. This management includes
communicating with owners about the status and upkeep of their properties.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: StayWell Student Accommodation Database
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.2 - Introduce StayWell, a Seattle-based company whose database is used to manage
accommodation for university students on behalf of property owners.
KEYWORDS: Bloom's: Remember
DATE CREATED: 9/9/2020 1:37 PM
DATE MODIFIED: 9/29/2020 12:31 PM
Multiple Choice
6. KimTay sells _____.
a. furniture
b. pet supplies
c. sporting goods
d. electronic games
ANSWER: b
FEEDBACK: a. The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in
Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to
Page 2
, maintain customer, invoice, and inventory data using its manual systems.
b. The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in
Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to
maintain customer, invoice, and inventory data using its manual systems.
c. The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in
Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to
maintain customer, invoice, and inventory data using its manual systems.
d. The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in
Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to
maintain customer, invoice, and inventory data using its manual systems.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: The KimTay Pet Supplies Database
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.1 - Introduce KimTay Pet Supplies, a company whose database is used to manage a pet
supplies business.
KEYWORDS: Bloom's: Remember
7. The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
a. footing
b. extension
c. trailer
d. sum
ANSWER: b
FEEDBACK: a. Each invoice line contains a total, usually called an extension, which is the result of multiplying the
number ordered by the quoted price.
b. Each invoice line contains a total, usually called an extension, which is the result of multiplying the
number ordered by the quoted price.
c. Each invoice line contains a total, usually called an extension, which is the result of multiplying the
number ordered by the quoted price.
d. Each invoice line contains a total, usually called an extension, which is the result of multiplying the
number ordered by the quoted price.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: The KimTay Pet Supplies Database
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.1 - Introduce KimTay Pet Supplies, a company whose database is used to manage a pet
supplies business.
KEYWORDS: Bloom's: Remember
8. Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the quoted price, and ____.
a. the wholesale price
b. an item description
c. the customer ID
d. an office location
ANSWER: b
FEEDBACK: a. Each invoice line contains an item ID, an item description, the number of units of the item ordered,
and the quoted price for the item.
b. Each invoice line contains an item ID, an item description, the number of units of the item ordered,
and the quoted price for the item.
c. Each invoice line contains an item ID, an item description, the number of units of the item ordered,
and the quoted price for the item.
d. Each invoice line contains an item ID, an item description, the number of units of the item ordered,
Page 3
10th Edition Mark Shellman, Hassan Afyouni, Philip J. Pratt, Mary Z. Last
Table of Contents:-
Module 1. Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases
Module 2. Database Design Fundamentals
Module 3. Creating Tables
Module 4. Single-Table Queries
Module 5. Multiple-Table Queries
Module 6. Updating Data
Module 7. Database Administration
Module 8. Functions, Procedures and Triggers
,Module 1 - Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases
True / False
1. An example of a relationship between categories in the KimTay database is the relationship between sales reps and customers.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Each database also contains relationships between categories. For example, the KimTay Pet Supplies
database contains information that relates sales reps to the customers they represent and customers to
the invoices they have placed.
Incorrect Each database also contains relationships between categories. For example, the KimTay Pet Supplies
database contains information that relates sales reps to the customers they represent and customers to
the invoices they have placed.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: What Is a Database?
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.1 - Introduce KimTay Pet Supplies, a company whose database is used to manage a pet
supplies business.
KEYWORDS: Bloom's: Remember
2. The StayWell database uses a combination of letters and numbers to identify each resident.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Each owner is identified by a unique owner number that consists of two uppercase letters followed by a
three-digit number.
Incorrect Each owner is identified by a unique owner number that consists of two uppercase letters followed by a
three-digit number.
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: StayWell Student Accommodation Database
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.2 - Introduce StayWell, a Seattle-based company whose database is used to manage
accommodation for university students on behalf of property owners.
KEYWORDS: Bloom's: Remember
3. StayWell organizes a variety of maintenance services for a fee.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Currently, prospective owners and renters need to contact the offices and speak to an administrator on
all matters relating to renting of properties. The office organizes maintenance services for a fee, which is
also currently done via email or direct communication.
Incorrect Currently, prospective owners and renters need to contact the offices and speak to an administrator on
all matters relating to renting of properties. The office organizes maintenance services for a fee, which is
also currently done via email or direct communication.
POINTS: 1
DIFFICULTY: Easy
Page 1
,REFERENCES: StayWell Student Accommodation Database
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.2 - Introduce StayWell, a Seattle-based company whose database is used to manage
accommodation for university students on behalf of property owners.
KEYWORDS: Bloom's: Remember
4. The SERVICE_CATEGORY table in the StayWell database includes the service fees.
a. True
b. False
ANSWER: False
FEEDBACK: Correct The SERVICE_CATEGORY table includes details of maintenance services. The CATEGORY_NUM
provides a unique number for the service, and CATEGORY_DESCRIPTION shows what the service is.
Incorrect The SERVICE_CATEGORY table includes details of maintenance services. The CATEGORY_NUM
provides a unique number for the service, and CATEGORY_DESCRIPTION shows what the service is.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: StayWell Student Accommodation Database
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.2 - Introduce StayWell, a Seattle-based company whose database is used to manage
accommodation for university students on behalf of property owners.
KEYWORDS: Bloom's: Remember
5. StayWell has twelve offices, one to manage each of their twelve rental locations.
a. True
b. False
ANSWER: False
FEEDBACK: Correct StayWell is split into two offices to better manage the properties. This management includes
communicating with owners about the status and upkeep of their properties.
Incorrect StayWell is split into two offices to better manage the properties. This management includes
communicating with owners about the status and upkeep of their properties.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: StayWell Student Accommodation Database
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.2 - Introduce StayWell, a Seattle-based company whose database is used to manage
accommodation for university students on behalf of property owners.
KEYWORDS: Bloom's: Remember
DATE CREATED: 9/9/2020 1:37 PM
DATE MODIFIED: 9/29/2020 12:31 PM
Multiple Choice
6. KimTay sells _____.
a. furniture
b. pet supplies
c. sporting goods
d. electronic games
ANSWER: b
FEEDBACK: a. The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in
Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to
Page 2
, maintain customer, invoice, and inventory data using its manual systems.
b. The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in
Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to
maintain customer, invoice, and inventory data using its manual systems.
c. The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in
Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to
maintain customer, invoice, and inventory data using its manual systems.
d. The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in
Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to
maintain customer, invoice, and inventory data using its manual systems.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: The KimTay Pet Supplies Database
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.1 - Introduce KimTay Pet Supplies, a company whose database is used to manage a pet
supplies business.
KEYWORDS: Bloom's: Remember
7. The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
a. footing
b. extension
c. trailer
d. sum
ANSWER: b
FEEDBACK: a. Each invoice line contains a total, usually called an extension, which is the result of multiplying the
number ordered by the quoted price.
b. Each invoice line contains a total, usually called an extension, which is the result of multiplying the
number ordered by the quoted price.
c. Each invoice line contains a total, usually called an extension, which is the result of multiplying the
number ordered by the quoted price.
d. Each invoice line contains a total, usually called an extension, which is the result of multiplying the
number ordered by the quoted price.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: The KimTay Pet Supplies Database
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: Guide to SQL.10e.1.1 - Introduce KimTay Pet Supplies, a company whose database is used to manage a pet
supplies business.
KEYWORDS: Bloom's: Remember
8. Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the quoted price, and ____.
a. the wholesale price
b. an item description
c. the customer ID
d. an office location
ANSWER: b
FEEDBACK: a. Each invoice line contains an item ID, an item description, the number of units of the item ordered,
and the quoted price for the item.
b. Each invoice line contains an item ID, an item description, the number of units of the item ordered,
and the quoted price for the item.
c. Each invoice line contains an item ID, an item description, the number of units of the item ordered,
and the quoted price for the item.
d. Each invoice line contains an item ID, an item description, the number of units of the item ordered,
Page 3
