Create queries for the following requirements based on the database diagram and data. Q3: Select first name, item, unit price, and quantity for items that are either 'Spanner' or 'Cable', sorted by bu

Here are the answers to the questions based on the provided image:

Question 3:
The query selects the FirstName of buyers, the Item name, UnitPrice, and Quantity for all items that are either 'Spanner' or 'Cable'. The results are then sorted in ascending order by the buyer's FirstName.

Question 4:
To create this query, you would include the following fields, tables, and criteria in your query design view:

• Fields: FirstName, LastName, Item, Quantity
• Tables: BUYERS (for FirstName, LastName), ITEMS (for Item), and an ORDERS or SALES table (for Quantity, linking buyers to items).
• Criteria: For the Quantity field, the criteria would be Between 10 And 20.
• All selected fields should have the 'Show' box checked.

Question 5:
Here is the query design view for GeneralSales:

$$\begin{array}{|l|l|l|l|l|l|l|} \hline \textbf{Field:} & \text{FirstName} & \text{LastName} & \text{Item} & \text{UnitPrice} & \text{Quantity} & \text{LineTotal: [UnitPrice]*[Quantity]} \\ \hline \textbf{Table:} & \text{BUYERS} & \text{BUYERS} & \text{ITEMS} & \text{ITEMS} & \text{ORDERS} & \\ \hline \textbf{Sort:} & & & & & & \\ \hline \textbf{Show:} & \checkmark & \checkmark & \checkmark & \checkmark & \checkmark & \checkmark \\ \hline \textbf{Criteria:} & & & & & & \\ \hline \textbf{or:} & & & & & & \\ \hline \end{array}$$