Use the Following Information to Answer the Questions
a $\quad$

question 8

Multiple Choice

Use the following information to answer the Questions
A five-member evaluating committee votes by approval voting on 10 faculty members for a promotion as indicated in the table below. An X indicates an approval vote. $\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\text { Voters }$
$\begin{array} { c c c c c c } \text { Candidates } &1 & 2 & 3 & 4 & 5 \\\mathrm {~A} & \mathrm { X } & & \mathrm { X } & \mathrm { X } & \mathrm { X } \\\mathrm { B } & \mathrm { X } & \mathrm { X } & \mathrm { X } & \mathrm { X } & \mathrm { X } \\\mathrm { C } & & & \mathrm { X } & & \mathrm { X } \\\mathrm { D } & & \mathrm { X } & \mathrm { X } & \mathrm { X } & \\\mathrm { E } & \mathrm { X } & & \mathrm { X } & & \mathrm { X } \\\mathrm { F } & \mathrm { X } & & & & \mathrm { X } \\\mathrm { G } & & \mathrm { X } & \mathrm { X } & \mathrm { X } & \\\mathrm { H } & & \mathrm { X } & & \mathrm { X } & \\\mathrm { I } & \mathrm { X } & & \mathrm { X } & \mathrm { X } & \\\mathrm { J } & & \mathrm { X } & \mathrm { X } & \mathrm { X } & \mathrm { X }\end{array}$
-Which faculty member(s) is(are) chosen if 60% approval is necessary and at most three are to be selected?

• A) B only
• B) A, B, and J
• C) All candidates, except C, F, and H
• D) None will be promoted.

---

Definitions:

Crosstab Query

A database query that aggregates data into a table that displays data across rows and columns, often used for comparative analysis.

Query Wizard

A tool designed to help users easily create database queries by guiding them through a step-by-step process.

Append Only Property

A feature in database management systems where records can only be added and not deleted or altered, ensuring data integrity.

Long Text

A data type in databases designed for storing large amounts of text, such as descriptions or comments.