a. Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project: To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants. Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects: There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also. Mention a query to know how much time employees are spending on Quota Computation project: The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed. Mention a query to find the number of hours worked by employees in the quota computation project in all three plants: To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter AE, Problem AE1.2

Explanation of Solution

a.

Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project:
To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants.

Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects:
There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also.

Mention a query to know how much time employees are spending on Quota Computation project:
The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed.

Mention a query to find the number of hours worked by employees in the quota computation project in all three plants:
To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

"Do not use AI tools. Solve the problem by hand on paper only and upload a photo of your handwritten solution."

| √ (r² + r + 1)e^ dr

Ensure you answer the question asked at the end of the document. Do not just paste things without the GNS3 console outputs

Answer 2

Expert Solution & Answer

Chapter AE, Problem AE1.2

Explanation of Solution

a.

Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project:
To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants.

Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects:
There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also.

Mention a query to know how much time employees are spending on Quota Computation project:
The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed.

Mention a query to find the number of hours worked by employees in the quota computation project in all three plants:
To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter AE, Problem AE1.2

Explanation of Solution

a.

Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project:
To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants.

Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects:
There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also.

Mention a query to know how much time employees are spending on Quota Computation project:
The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed.

Mention a query to find the number of hours worked by employees in the quota computation project in all three plants:
To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter AE, Problem AE1.2

Explanation of Solution

a.

Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project:
To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants.

Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects:
There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also.

Mention a query to know how much time employees are spending on Quota Computation project:
The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed.

Mention a query to find the number of hours worked by employees in the quota computation project in all three plants:
To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter AE, Problem AE1.2

Explanation of Solution

a.

Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project:
To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants.

Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects:
There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also.

Mention a query to know how much time employees are spending on Quota Computation project:
The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed.

Mention a query to find the number of hours worked by employees in the quota computation project in all three plants:
To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Answer 8

Chapter AE, Problem AE1.2

Explanation of Solution

a.

Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project:
To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants.

Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects:
There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also.

Mention a query to know how much time employees are spending on Quota Computation project:
The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed.

Mention a query to find the number of hours worked by employees in the quota computation project in all three plants:
To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Answer 9

Chapter AE, Problem AE1.2

Explanation of Solution

a.

Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project:
To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants.

Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects:
There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also.

Mention a query to know how much time employees are spending on Quota Computation project:
The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed.

Mention a query to find the number of hours worked by employees in the quota computation project in all three plants:
To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Answer 10

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Answer 11

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Answer 12

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Answer 13

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Answer 14

Expert Solution & Answer

Answer 15

Expert Solution & Answer

Answer 16

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 17

Ch. AE - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2

Concept explainers

Explanation of Solution

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Want to see the full answer?

Chapter AE Solutions

Concept explainers

Explanation of Solution

Explanation of Solution

b. Mention the conclusion that can be drawn by this exercise: It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Explanation of Solution

c. Mention the advantages and disadvantages of databases as compared to spreadsheet: It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Want to see the full answer?

Chapter AE Solutions

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...