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 percentage 
A)  invoice date 
B)  line totals (extensions) 
C)  invoice total 
D)  discount percentage A

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

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

Question 4

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 5

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 contact 
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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 OFFICE 
A)  RESIDENTS and PROPERTY 
B)  SERVICE_CATEGORY and SERVICE_REQUEST 
C)  OFFICE and PROPERTY 
D)  RESIDENTS and OFFICE

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Name and briefly describe the tables in the StayWell database.

Accepted Answer

StayWell is split into two offices to be

Question 11

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 location 
A)  the wholesale price 
B)  an item description 
C)  the customer ID 
D)  an office location

Question 12

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)  five 
A)  two 
B)  three 
C)  four 
D)  five

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 complicated 
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 14

How many tables make up the KimTay database?

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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 17

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 18

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 name 
A)  property ID 
B)  location number 
C)  description of the category 
D)  location name

Question 19

StayWell organizes a variety of maintenance services for a fee.

Accepted Answer

A) True 
 B)False

Question 20

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 organizations 
A)  one- to five-bedroom properties 
B)  apartments in the New York City area 
C)  medical equipment 
D)  office buildings for educational organizations

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

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

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

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.

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

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

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

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

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

Name and briefly describe the tables in the StayWell database.

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

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

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

How many tables make up the KimTay database?

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

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?

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

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

StayWell organizes a variety of maintenance services for a fee.

StayWell rents out and helps to maintain _____.

Database Design Fundamentals

Creating Tables

Single Table Queries

Multiple Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters

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 _____.

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

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

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.

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

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

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

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

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

Name and briefly describe the tables in the StayWell database.

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

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

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

How many tables make up the KimTay database?

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

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?

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

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

StayWell organizes a variety of maintenance services for a fee.

StayWell rents out and helps to maintain _____.

Database Design Fundamentals

Creating Tables

Single Table Queries

Multiple Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters