Question 1

Name and briefly describe the tables in the StayWell database.

Accepted Answer

StayWell is split into two offices to be...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

How many tables make up the KimTay database?

Accepted Answer

A)   4
B)   5
C)   6
D)   7E) None of the above
F) B) and D)

Question 5

StayWell rents out and helps to maintain _____.

Accepted Answer

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

Question 6

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

Accepted Answer

If the two tables were combined, the new...

Question 7

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

Accepted Answer

A)   item ID
B)   quantity
C)   customer ID
D)   quoted priceE) B) and D)
F) B) and C) C

Question 8

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

How much room do you allow for multiple ...

Question 9

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

Accepted Answer

A)   two
B)   three
C)   four
D)   fiveE) C) and D)
F) None of the above

Question 10

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

It might at first seem reasonable to inc...

Question 11

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

Accepted Answer

A)   invoice date
B)   line totals (extensions) 
C)   invoice total
D)   discount percentageE) C) and D)
F) A) and D) A

Question 12

StayWell organizes a variety of maintenance services for a fee.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)   RESIDENTS and PROPERTY
B)   SERVICE_CATEGORY and SERVICE_REQUEST
C)   OFFICE and PROPERTY
D)   RESIDENTS and OFFICEE) All of the above
F) B) and C)

Question 16

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

Accepted Answer

A)   complex
B)   simple
C)   detailed
D)   completeE) All of the above
F) A) and B)

Question 17

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

Accepted Answer

A)   property ID
B)   location number
C)   description of the category
D)   location nameE) A) and C)
F) A) and B)

Question 18

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

Accepted Answer

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 contactE) None of the above
F) All of the above

Question 19

Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the quoted price, and ____.

Accepted Answer

A)   the wholesale price
B)   an item description
C)   the customer ID
D)   an office locationE) All of the above
F) B) and D)

Question 20

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

Accepted Answer

A) True 
 B)False

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

Name and briefly describe the tables in the StayWell database.

Correct AnswerverifiedStayWell is split into two offices to be...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

How many tables make up the KimTay database?

Correct AnswerverifiedShow Answer

StayWell rents out and helps to maintain _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedIf the two tables were combined, the new...View AnswerShow Answer

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

Correct AnswerverifiedC

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.

Correct AnswerverifiedHow much room do you allow for multiple ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedIt might at first seem reasonable to inc...View AnswerShow Answer

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

Correct AnswerverifiedA

StayWell organizes a variety of maintenance services for a fee.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the quoted price, and ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
StayWell is split into two offices to be...
View Answer

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
If the two tables were combined, the new...
View Answer

Correct Answer
verified
C

Correct Answer
verified
How much room do you allow for multiple ...
View Answer

Correct Answer
verified

Correct Answer
verified
It might at first seem reasonable to inc...
View Answer

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified