Question 1

KimTay's database allows sales reps to sell the same item for different prices by _____.
A) including a QUOTED_PRICE column in the INVOICE_LINE table
B) including a PRICE column in the ITEM table
C) using the prices from the ITEM table in the invoice body
D) omitting price information from the ITEM table

Accepted Answer

Including a QUOTED_PRICE column in the INVOICE_LINE table allows for flexibility in pricing, enabling sales reps to sell the same item at different prices by specifying the sale price for each transaction individually.

Question 2

In the StayWell database, each rental property is identified by _____.
A) a combination of letters and numbers
B) a unique integer
C) a unique character value
D) the owner's owner ID

Accepted Answer

In databases, a unique integer is commonly used to identify records, such as rental properties, because it ensures each record can be uniquely identified without confusion. This method is efficient and widely adopted in database design for its simplicity and effectiveness in indexing and searching records.

Question 3

The StayWell database includes OWNER and PROPERTY tables. Both tables have columns with the owner numbers, but the OWNER table does not have a column associating property IDs with owners. Why is this?

Accepted Answer

The answer of The StayWell database includes OWNER and PROPERTY...

Question 4

KimTay's management would like to set up a structure that contains different categories of information and the relationships between these categories. In other words, they want a _____.
A) table
B) database
C) digital template
D) spreadsheet

Accepted Answer

A database is designed to store different categories of information and manage the relationships between these categories, making it the correct choice for setting up a structured repository of information with relational capabilities.

Question 5

The StayWell database's OWNER table _____.
A) includes property IDs
B) omits property IDs
C) includes single rows with multiple data entries
D) cannot be easily cross-referenced to the PROPERTY table

Accepted Answer

The answer of The StayWell database's OWNER table _____.
A) includes...

Question 6

If a StayWell administrator needs to know where a resident lives, he or she should consult which tables?
A) RESIDENTS and PROPERTY
B) SERVICE_CATEGORY and SERVICE_REQUEST
C) OFFICE and PROPERTY
D) RESIDENTS and OFFICE

Accepted Answer

The RESIDENTS table likely contains information about the individuals living in the StayWell facility, including their names and possibly their unit or apartment numbers. The PROPERTY table would contain details about the physical properties, including addresses or location details. Together, these tables would enable an administrator to determine where a resident lives.

Question 7

Why would you not combine the two tables INVOICES and INVOICE_LINE in the KimTay database?

Accepted Answer

The answer of Why would you not combine the two...

Question 8

Though they haven't yet achieved an e-commerce-based business status, in the future, StayWell would like to be able to use their database in conjunction with _____.
A) an overseas call center
B) live administrators taking phone calls
C) advertisements in student-facing publications
D) mobile apps and online booking systems

Accepted Answer

StayWell aims to integrate their database with mobile apps and online booking systems to achieve an e-commerce-based business status in the future.

Question 9

List three practical issues that would need to be dealt with if the INVOICES table and the INVOICE_LINE table in the KimTay database were combined.

Accepted Answer

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

Question 10

At KimTay, the invoice total appears in which section of the invoice?
A) top
B) heading
C) body
D) footing

Accepted Answer

The invoice total typically appears in the footing section of an invoice, which is at the bottom. This section summarizes the charges and presents the total amount due.

Question 11

The KimTay database must combine data from all of its tables in order to print a(n) _____.
A) inventory report
B) sales rep directory
C) invoice
D) customer directory

Accepted Answer

An invoice typically requires data from multiple tables, such as customer information, product details, and transaction records, to provide a comprehensive billing document.

Question 12

The KimTay database stores several items for each customer's invoice, including the _____.
A) invoice date
B) line totals (extensions)
C) invoice total
D) discount percentage

Accepted Answer

The invoice date is a standard piece of information stored for each customer's invoice in a database.

Question 13

Can an administrator at StayWell use their database to determine which student resident put in a request for maintenance? Explain why or why not.

Accepted Answer

The answer of Can an administrator at StayWell use their...

Question 14

To determine how many Pump & Filter Kits are available in the warehouse, a KimTay employee would need to consult which database table?
A) SALES_REP
B) INVOICES
C) ITEM
D) INVOICE_LINE

Accepted Answer

The ITEM database table is typically where inventory items, such as Pump & Filter Kits, are listed, including details about their availability, description, and quantity in stock.

Question 15

When a StayWell property is owned by more than one person, the OWNER table includes _____.
A) a group ID instead of an owner ID
B) an owner ID for each person
C) a row for each individual owner
D) only the primary contact

Accepted Answer

The answer of When a StayWell property is owned by...

Question 16

Name and briefly describe the tables in the StayWell database.

Accepted Answer

The answer of Name and briefly describe the tables in...

Quiz 1: Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

KimTay's database allows sales reps to sell the same item for different prices by _____.

In the StayWell database, each rental property is identified by _____.

The StayWell database includes OWNER and PROPERTY tables. Both tables have columns with the owner numbers, but the OWNER table does not have a column associating property IDs with owners. Why is this?

KimTay's management would like to set up a structure that contains different categories of information and the relationships between these categories. In other words, they want a _____.

The StayWell database's OWNER table _____.

If a StayWell administrator needs to know where a resident lives, he or she should consult which tables?

Why would you not combine the two tables INVOICES and INVOICE_LINE in the KimTay database?

Though they haven't yet achieved an e-commerce-based business status, in the future, StayWell would like to be able to use their database in conjunction with _____.

List three practical issues that would need to be dealt with if the INVOICES table and the INVOICE_LINE table in the KimTay database were combined.

At KimTay, the invoice total appears in which section of the invoice?

The KimTay database must combine data from all of its tables in order to print a(n) _____.

The KimTay database stores several items for each customer's invoice, including the _____.

Can an administrator at StayWell use their database to determine which student resident put in a request for maintenance? Explain why or why not.

To determine how many Pump & Filter Kits are available in the warehouse, a KimTay employee would need to consult which database table?

When a StayWell property is owned by more than one person, the OWNER table includes _____.

Name and briefly describe the tables in the StayWell database.