BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com | Page 2

5. (TCO 1) Assume you want to associate a TaxpayerTable
with a PrincipalResidenceTable. The PrincipalResidentTable
contains the address where each taxpayer lives. Assume that
each taxpayer can have only one residence; however, more
than one person at the address can be considered a taxpayer.
What is the relationship between the TaxpayerTable and
PrincipalResidenceTable? (Points : 5)
Many-To-One
One-To-Many
Many-to-Many
One-to-One
6. (TCO 1) Which of the following would display values from the
city field in the Professor table, removing all duplicate city
names? (Points : 5)
SELECT City DISTINCT FROM Professor
SELECT City FROM DISTINCT Professor
SELECT DISTINCT City FROM Professor
SELECT DISTINCT FROM Professor
7. (TCO 1) Assume you have a table called StudentTable. You
would like to extract the lastname of all students who have not
yet declared their major. Which of the following WHERE
clauses would accomplish this? (Points : 5)
WHERE major = " "
WHERE major = ' '
WHERE major IS NULL
WHERE major = 'NULL'
8. (TCO 3) Which of the following statements would count the
number of customers within each state?
Assume you have a table with the following columns:
(Points : 5)
SELECT State, Count(*)
FROM CustomerTable
GROUP BY State;
SELECT CustomerID, Count(State)