184k views
4 votes
A report may be based on:

A. A table but not a query
B. A query but not a table
C. Either a table or query
D. Neither a table nor a query
E. None of the above

User Silmaril
by
7.7k points

1 Answer

3 votes

Final answer:

A report in the context of database systems can be based on either a table or a query. A table stores data in rows and columns, and a query retrieves and manipulates this data to fulfill specific reporting requirements. The choice between using a table or a query depends on the data needs of the report.

Step-by-step explanation:

The student's question pertains to what sources a report can be based upon, specifically in the context of data management systems such as databases. The answer to the question is C. Either a table or a query. Both tables and queries serve as foundational elements in database systems and can be used individually or in conjunction as the basis for generating reports. A table is a database object that stores data in rows and columns, while a query is a request for data or information from a database table or combination of tables. Queries can manipulate the data from these tables in various ways to produce a desired subset of data or calculate additional information that can then be used in a report.

In general, whether one uses a table or a query for a report depends on the specific requirements of the report. If the report requires data that is directly available in a single table, then the table can serve as the source. However, if the report requires more complex data extraction, such as data from multiple tables or data that needs to be filtered or summarized, a query would be necessary. Both methods of grouping data have their advantages, and the choice between a table and a query or a combination thereof depends on the complexity and specific needs of the report.

User Pommicket
by
7.5k points