GBUS3301 - Quiz 1

What is a database?

A database is a structure that contains different categories of information and the relationships between these categories.

Which of the following is not a table in the STAYWELL database?

ADDRESS

What information below is contained in the CUSTOMER table in the KIMTAY database?

Customer name, contact information, and customer representative

Which of the following is a valid statement regarding the KIMTAY database?

For any given invoice, an ITEM is sold only to one customer

Which line in the KIMTAY database is ITEM_ID found?

ITEM and INVOICE_LINE tables

Which of the following is a table in the STAYWELL database?

OWNER

Which of the following is a unique identifier?

OWNER_ID

Which of the following is not a table in the KIMTAY database?

REPRESENTATIVE

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

including a QUOTED_PRICE column in the INVOICE_LINE table