Chapter 1, M1 Quiz

Database programming I, A Guide to SQL, 10e

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 a valid KIMTAY database fact?

?? a. A CUSTOMER may have many relationships, b. An INVOICE contains many customers, c. A sales representative represents only one customer, d. An ITEM is sold to only one customer in an invoice

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

Customer name, contact information, and customer representative.

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

OWNER

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

ADDRESS

Which of the following is a unique identifier?

OWNER_ID

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

REPRESENTIVE

Which table in the KIMTAY database is ITEM_ID found?

?? a. ITEM and INVOCES tables, b. INVOICES table, c. ITEM and INVOICE_LINE tables, d. ITEM table