Question 1

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) A) and C)
F) All of the above A

Question 2

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 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

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 C)
F) C) and D)

Question 5

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) None of the above
F) B) and D)

Question 6

Name and briefly describe the tables in the StayWell database.

Accepted Answer

StayWell is split into two offices to be...

Question 7

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) A) and D)
F) All of the above

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

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) All of the above
F) C) and D)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 C)
F) A) and D) C

Question 12

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 D)
F) B) and D)

Question 13

StayWell organizes a variety of maintenance services for a fee.

Accepted Answer

A) True 
 B)False

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

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) All of the above
F) A) and B)

Question 16

How many tables make up the KimTay database?

Accepted Answer

A)   4
B)   5
C)   6
D)   7E) B) and C)
F) A) and B)

Question 17

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 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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) A) and D)
F) A) and C)

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

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

Correct AnswerverifiedA

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 StayWell database uses a combination of letters and numbers to identify each resident.

Correct AnswerverifiedFalse

StayWell rents out and helps to maintain _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Name and briefly describe the tables in the StayWell database.

Correct AnswerverifiedStayWell is split into two offices to be...View AnswerShow 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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

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

Correct AnswerverifiedShow Answer

StayWell organizes a variety of maintenance services for a fee.

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

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

Correct AnswerverifiedShow Answer

How many tables make up the KimTay database?

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow 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

Correct Answer
verified
A

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

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified