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

Question 1

The SERVICE_CATEGORY table in the StayWell database includes the service fees.

Answer 1

False

Question 2

StayWell provides maintenance services across the properties they manage. The SERVICE_CATEGORY table in their database contains a _____.

A) property ID
B) location number
C) description of the category
D) location name

Answer 2

C

Question 3

Information about the services requested by StayWell residents is stored in the _____ table.

A) LOCATION
B) PROPERTY
C) SERVICE_REQUEST
D) OWNER

Answer 3

C

Question 4

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

Question 5

The StayWell database uses a combination of letters and numbers to identify each resident.

Question 6

The KimTay INVOICES table consists of the invoice number, invoice date, and _____.

A) item ID
B) quantity
C) customer ID
D) quoted price

Question 7

An example of a relationship between categories in the KimTay database is the relationship between sales reps and customers.

Question 8

StayWell organizes a variety of maintenance services for a fee.

Question 9

In general, when designing tables, which type of structure is most preferable?

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

Question 10

StayWell rents out and helps to maintain _____.

A) one- to five-bedroom properties
B) apartments in the New York City area
C) medical equipment
D) office buildings for educational organizations

Question 11

An owner number in the OWNER table in the StayWell database consists of _____ uppercase letters followed by a three-digit number.

A) two
B) three
C) four
D) five

Question 12

Combining the INVOICE_LINE and INVOICES tables in the KimTay database will _____.

A) save space in the table
B) make the table more effective
C) decrease the efficiency of the table
D) make the table more complicated

Question 13

StayWell stores information about the facilities where student residents live in the _____ table.

A) RENTAL_UNIT
B) OFFICE
C) PROPERTY
D) OWNER

Question 14

StayWell has twelve offices, one to manage each of their twelve rental locations.

Question 15

The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.

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

Question 16

The SALES_REP table consists of the sales representatives' IDs, first names, last names, addresses, mobile numbers, total commissions, and _____.

A) total sales
B) commission rates
C) customers
D) invoice numbers

Question 17

Each row in the PROPERTY table in the StayWell database contains a property _____ that identifies that particular property.

A) sequence
B) ID
C) name
D) owner

Question 18

KimTay sells _____.

A) furniture
B) pet supplies
C) sporting goods
D) electronic games

Question 19

Which field of the SERVICE_REQUEST table in the StayWell database indicates the issue reported by the resident who made the request?

A) STATUS
B) DESCRIPTION
C) CATEGORY_DESCRIPTION
D) SERVICE_DESCRIPTION

Question 20

How many tables make up the KimTay database?

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

Question 21

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

Question 22

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

Question 23

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?

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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.

Question 30

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

A) top
B) heading
C) body
D) footing

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

Name and briefly describe the tables in the StayWell database.