Accounting Information Systems (D217)

Correct Answer

B. enter data

Explanation

In Microsoft Access, the main function of a Form is to allow users to enter data into the database. Forms provide a user-friendly interface that enables users to input, update, or view data in an organized manner, without directly interacting with the underlying database tables.

Why other options are wrong

A. store data – Data is stored in tables, not in forms. Forms are designed for entering or viewing data, not for storage.

C. retrieve data – While forms can display retrieved data, their primary function is to facilitate data entry, not retrieval. Queries or reports are better suited for retrieving data.

D. analyze data – Analysis of data is typically done using queries, reports, or external tools, not through forms, which are primarily for data entry and viewing.

Correct Answer

A. Verifiability

Explanation

In accounting and financial reporting, faithful representation refers to information that accurately reflects the real-world economic phenomena it purports to represent. The main components of faithful representation are completeness, neutrality, and freedom from error. Verifiability is a separate qualitative characteristic of useful financial information, but it is not part of faithful representation.

Why other options are wrong

B. Completeness

Completeness means all necessary information is included, and it is a fundamental aspect of faithful representation. Without completeness, users might be misled due to missing data or omitted facts that could influence decision-making.

C. Neutrality

Neutrality implies that the information is presented without bias. This is essential to ensure that the data reflects the true financial position and does not influence users’ decisions unfairly. It is a required component of faithful representation.

D. Free from error

Being free from error doesn’t mean perfectly accurate in all aspects, but it implies that the information is as accurate and precise as possible given the circumstances. This enhances the trustworthiness of the data and is a core element of faithful representation.

Correct Answer

A. remittance advice number

Explanation

In a "collect cash" table, the primary key is typically the "remittance advice number," as it uniquely identifies each payment transaction or record. This number is used to track individual payments or collections and ensures each record is unique within the table.

Why other options are wrong

B. bank account number

While the bank account number is important for identifying where the payment came from, it is not unique to each transaction. Multiple transactions can originate from the same bank account.

C. inventory description

The inventory description pertains to the items being sold, not the transaction itself. This would not be a suitable primary key, as it could appear in multiple rows and would not uniquely identify each cash collection.

D. customer name

The customer name, like the bank account number, is not unique to each transaction. Multiple customers can have the same name, and a single customer can make multiple payments.

Correct Answer

A. A blueprint for a house.

Explanation

Structure models like class diagrams represent the static structure of a system, showing how entities relate and are organized. This is analogous to a blueprint, which lays out the design of a house before it is built. It doesn't describe processes or sequences, but rather defines the components and how they fit together, much like a structural model defines data and its relationships.

Why other options are wrong

B. Driving directions to get home

Driving directions represent a dynamic process—a sequence of steps to reach a destination. This aligns more closely with behavioral models, such as flowcharts or process diagrams, rather than structural models like class diagrams.

C. Directions to bake a cake

Baking instructions involve a specific order of operations to achieve a result, which corresponds more to a process model. Structural models, on the other hand, focus on the static layout and relationships between elements rather than a sequence of actions.

D. The conversion of raw material to finished goods

This option describes a transformation or workflow, which again is a dynamic process. Structural models do not represent processes or transformations but rather the components and their interrelations, making this analogy inaccurate.

Correct Answer

B. The way to access data is by following a predefined data path.

Explanation

In a hierarchical model, data is structured in a tree-like format where each record (parent) is linked to one or more child records. To retrieve data, users must follow a predefined path from the parent record to its child records, which is a key characteristic of the hierarchical model. This structure defines relationships in a way that each child record can only have one parent, and the traversal of data is fixed by the tree structure.

Why other options are wrong

A. Links between related records are implicit – This is incorrect. In a hierarchical model, the relationships between parent and child records are explicitly defined, not implicit.

C. An owner (parent) record may own just one member (child) record – This is incorrect. In a hierarchical model, a parent record can own multiple child records, not just one.

D. A member (child) record may have more than one owner (parent) – This is incorrect. In a hierarchical model, a child record can only have one parent, which is a defining feature of the model.

Correct Answer

D. linking vendor table with employee table

Explanation

Linking the vendor table with the employee table represents an invalid relationship in most business databases. Vendors are external entities that provide goods or services, while employees are internal to the organization. These two tables do not typically have a direct relationship with each other in standard database design. Relationships are usually made between entities that are directly related, such as between employees and payroll, or between products and orders.

Why other options are wrong

A. linking employee table with payroll table

This is a valid relationship because employees are typically linked to payroll information, where each employee may have corresponding payroll data.

B. linking product table with order table

This is a valid relationship because orders usually contain products, and the relationship between products and orders is common in a sales database to track which products are purchased by customers.

C. linking vendor table with inventory table

This is a valid relationship, as vendors supply inventory items, and therefore, the vendor table can be linked with the inventory table to track which vendor supplies which items.

Correct Answer

A. To aggregate data

Explanation

The GROUP BY clause in SQL is used to group rows that have the same values in specified columns into summary rows. It is typically used with aggregate functions like SUM(), AVG(), COUNT(), etc., to perform operations on each group of data. This helps in generating meaningful reports and summaries.

Why other options are wrong

B. To sort data alphabetically

Sorting is handled by the ORDER BY clause, not GROUP BY. While GROUP BY may incidentally affect the order, its purpose is not to sort but to aggregate data based on shared column values.

C. To filter data

Filtering data is done using the WHERE clause before grouping or the HAVING clause after grouping. GROUP BY does not perform filtering; it organizes data for aggregation.

D. To join tables

Table joins are performed using JOIN operations (INNER JOIN, LEFT JOIN, etc.). GROUP BY has no function in combining data from multiple tables—it only deals with grouping within a result set.

Correct Answer

D. Transform data into useful information

Explanation

A primary function of an AIS (Accounting Information System) is to transform raw data into useful information that helps in decision-making and reporting. AIS systems collect, process, and store financial data to generate reports and insights that are essential for operational and strategic decision-making.

Why other options are wrong

A. Automate all decision making

This is incorrect because an AIS automates certain processes, such as data collection and report generation, but it does not automatically make decisions. Decision-making still requires human intervention, especially in more complex or strategic matters.

B. Reduce need to identify a strategy and strategic position

This is incorrect because an AIS does not replace the need for strategic planning. While it provides useful data, it does not determine the strategy or strategic position of an organization.

C. Allocate organizational resources

This is incorrect because while an AIS can track resource allocation, it is not directly responsible for allocating organizational resources. Resource allocation is typically a function of management and organizational strategy.

Correct Answer

C. The rule requires that primary keys must always have a value (cannot be null).

Explanation

The entity integrity rule in database management states that a primary key must have a value for each record and cannot be null. This ensures that each record can be uniquely identified in the database, supporting the accuracy and integrity of the data.

Why other options are wrong

A. The rule mandates that primary keys must be unique for each record.

While primary keys must be unique, this is not the focus of the entity integrity rule. The rule primarily emphasizes that the primary key cannot be null, rather than just being unique. Uniqueness is a requirement for the primary key, but entity integrity ensures it always has a value.

B. The rule allows primary keys to contain duplicate values.

This is incorrect because primary keys must be unique, and allowing duplicate values would violate the entity integrity rule.

D. The rule permits primary keys to be blank if other fields are filled.

This is incorrect as the entity integrity rule specifically states that primary keys cannot be blank or null, regardless of whether other fields are filled.