DBMS EXAM 1 QUESTIONS AND ANSWERS
An example of a relationship between categories in the KimTay database is the
relationship between sales reps and customers. - Answers -True
Which of the following is a unique identifier? - Answers -OWNER_ID
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
- Answers -extension
Which of the following is not a table in the STAYWELL database? - Answers -
ADDRESS
Why would you not combine the two tables INVOICES and INVOICE_LINE in the
KimTay database? - Answers -If the two tables were combined, the new table would be
more complicated. Some of the individual positions within this table would contain
multiple entries, making it difficult to track the information between columns.
Determining which invoices contained invoice lines for a given item would be tricky. In
general, the simpler structure is preferable, and that is why invoice lines appear in a
separate table.
How many tables make up the KimTay database? - Answers -5
What information is contained in the CUSTOMER table in the KIMTAY database? -
Answers -Customer name, contact information, and customer representative.
The SERVICE_CATEGORY table in the StayWell database includes the service fees. -
Answers -False
Combining the INVOICE_LINE and INVOICES tables in the KimTay database will
_____. - Answers -make the table more complicated
What is a database? - Answers -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 KIMTAY database? - Answers -
REPRESENTIVE
In the StayWell database, each rental property is identified by _____. - Answers -a
unique integer
Which table in the KIMTAY database is ITEM_ID found? - Answers -ITEM and
INVOICE_LINE tables
An example of a relationship between categories in the KimTay database is the
relationship between sales reps and customers. - Answers -True
Which of the following is a unique identifier? - Answers -OWNER_ID
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
- Answers -extension
Which of the following is not a table in the STAYWELL database? - Answers -
ADDRESS
Why would you not combine the two tables INVOICES and INVOICE_LINE in the
KimTay database? - Answers -If the two tables were combined, the new table would be
more complicated. Some of the individual positions within this table would contain
multiple entries, making it difficult to track the information between columns.
Determining which invoices contained invoice lines for a given item would be tricky. In
general, the simpler structure is preferable, and that is why invoice lines appear in a
separate table.
How many tables make up the KimTay database? - Answers -5
What information is contained in the CUSTOMER table in the KIMTAY database? -
Answers -Customer name, contact information, and customer representative.
The SERVICE_CATEGORY table in the StayWell database includes the service fees. -
Answers -False
Combining the INVOICE_LINE and INVOICES tables in the KimTay database will
_____. - Answers -make the table more complicated
What is a database? - Answers -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 KIMTAY database? - Answers -
REPRESENTIVE
In the StayWell database, each rental property is identified by _____. - Answers -a
unique integer
Which table in the KIMTAY database is ITEM_ID found? - Answers -ITEM and
INVOICE_LINE tables
