ACCT 310 Chapter 4

A foreign key in a database table is always: A. A primary key in a related table. B. A unique identifier for a record in that table. C. A numeric field. D. The name of a UML class.

A. A primary key in a related table.

Which of the following statements about the requirements of table design is incorrect? A. All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key. B. Each attribute (column) of a record (row) must be single-valued. C. Each attribute in a table must have a unique name. D. Values of a specific attribute must be of the same type.

A. All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key.

Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales? A. Cash Collection (1..1) - Sale (1..1). B. Cash Collection (1..N) - Sale (1..1). C. Cash Collection (1..N) - Sale (1..N). D. Cash Collection (1..1) - Sale (1..N).

A. Cash Collection (1..1) - Sale (1..1).

Which set of multiplicities correctly shows the relationship between the Cash Receipts table and the Sale table for an organization that allows customers to buy on credit and pay in multiple installments? A. Cash Receipts (0..N) - Sale (1..1). B. Cash Receipts (1..1) - Sale (1..1). C. Cash Receipts (1..N) - Sale (0..N). D. Cash Receipts (1..1) - Sale (N..M).

A. Cash Receipts (0..N) - Sale (1..1).

Which of the following about cloud computing is incorrect? A. Clients using cloud computing do not need to periodically backup data. B. Cloud Computing can easily host enterprise system applications. C. Cloud computing is Internet-based computing where shared resources, software, and information are provided to firms on demand. D. Security is a major issue to consider when using cloud computing.

A. Clients using cloud computing do not need to periodically backup data.

In Microsoft Access, we use "Tables" for: A. Data storage. B. Data entry. C. Date retrieve. D. Two of these choices are correct.

A. Data storage.

In Microsoft Access, we use tables in a database for: A. Data storage. B. Data retrieval. C. Data entry. D. Two of these choices are correct.

A. Data storage.

ERPs are useful to auditors for which of the following reasons? A. ERPs track details regarding creation, modification, and use of transactions throughout the organization in a single system. B. ERPs are spread across multiple logical databases, allowing auditors to minimize disruption to processing when reviewing ERP activity. C. ERPs use cloud computing technology, which allows auditors to review transactions from anywhere. D. ERPs are required by the Sarbanes-Oxley Act of 2002.

A. ERPs track details regarding creation, modification, and use of transactions throughout the organization in a single system.

Which of the following is not one of the typical challenges organizations face when implementing an ERP? A. Installing the ERP software. B. Successfully completing a large project in an organization. C. Converting data from legacy systems to the ERP. D. Integrating with external business partners' information systems.

A. Installing the ERP software.

What is the main purpose of using foreign keys in a relational database design? A. It is used to link tables. B. It is required in all tables. C. It provides useful financial data value in the table. D. None of these choices is correct.

A. It is used to link tables.

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers? A. Reports. B. Forms. C. Tables. D. Macros.

A. Reports.

The property of the primary key in a table in Microsoft Access should be set to: A. The Required field = "Yes", and the Indexed field = "Yes (No Duplicates)". B. The Required field = "NO" and the Indexed field = "Yes (Duplicated)". C. The Required field = "Yes" and the Indexed field = "Yes (Duplicated)". D. The Required field = "NO" and the Indexed field = "Yes (No Duplicates)".

A. The Required field = "Yes", and the Indexed field = "Yes (No Duplicates)".

Which of the following statements best describes the entity integrity rule? A. A database entity must fit within the REA model. B. A record's primary key must have a data value. C. A record's foreign key value must be null. D. All values of an attribute must be of the same data type.

B. A record's primary key must have a data value.

Classes in a relational database model for AISs are typically grouped into all of the following categories except: A. Events. B. Activities. C. Resources. D. Agents.

B. Activities.

Which of the following items can best be described as an "Event" in the REA data model? A. Cashier. B. Cash collection. C. Cash. D. None of these choices is correct.

B. Cash collection.

Which of the following is considered one of the primary benefits of ERPs? A. ERPs all operate using cloud computing technology. B. ERPs allow an organization to integrate information related to multiple business functions (i.e., manufacturing, human resources, finance, etc.). C. ERPs create protected data silos for each function in the organization. D. ERPs use relational data models, which are required by the Sarbanes-Oxley Act of 2002.

B. ERPs allow an organization to integrate information related to multiple business functions (i.e., manufacturing, human resources, finance, etc.).

Which of the following is not one of the advantages relational data models have over other data models? A. Simplicity. B. Exclusively uses parent/child relationships. C. Reduced information redundancy. D. Increased flexibility and scalability.

B. Exclusively uses parent/child relationships.

An enterprise resource planning system has which of the following advantages over multiple independent functional systems? A. Modifications can be made to each module without affecting other modules. B. Increased responsiveness and flexibility while aiding in the decision-making process. C. Increased amount of data redundancy since more than one module contains the same information. D. Reduction in costs for implementation and training.

B. Increased responsiveness and flexibility while aiding in the decision-making process.

Which of the following is not a type of data model? A. Network data model. B. Normalization data model. C. Hierarchical data model. D. Relational data model.

B. Normalization data model.

Which of the following operators would be used in a SQL query designed to simply display database records? A. INSERT. B. SELECT. C. DISPLAY. D. VIEW.

B. SELECT.

Which of the following about SQL is incorrect? A. SQL is a language designed to query data in a relational database. B. SQL is very user-friendly. C. SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query. D. SQL is based on relational algebra and allows a user to query and update the database.

B. SQL is very user-friendly.

Which of the following correctly describes the Referential Integrity Rule? A. The primary key of a table must have data values (cannot be null). B. The data value for a foreign key could be null. C. Values of a specific attribute must be of the same type. D. Each attribute in a table must have a unique name.

B. The data value for a foreign key could be null.

What kind data model is most commonly used as a basis for today's enterprise systems? A. The network model. B. The relational model. C. The hierarchical mode. D. None of these choices is correct.

B. The relational model.

Which of the following items can best be described as an "Agent" in the REA data model? A. Purchases. B. Raw material inventory. C. Accounts payable clerk. D. None of these choices is correct.

C. Accounts payable clerk.

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations. Which of the following systems is most effective for this application? A. A decision support system. B. An office automation system. C. An enterprise resource planning system. D. An executive support system.

C. An enterprise resource planning system.

Which of the following items can best be described as a "Resource" in the REA data model? A. Sales. B. Cashier. C. Cash. D. Two of these choices are correct.

C. Cash.

Which of the following tasks cannot be performed through queries in access? A. Data sorting. B. Retrieve and display data. C. Create and update relationships. D. Calculations of data.

C. Create and update relationships.

In Microsoft Access, we use "Forms" for: A. Data storage. B. Date retrieve. C. Data entry. D. Two of these choices are correct.

C. Data entry.

Consider the following SQL query. Which item best describes the results of the query? SELECT VendorID, Sum(POTotal) FROM [Purchase Orders] GROUP BY VendorID A. Displays the vendor ID and all purchase order totals in the purchase orders table. B. Adds new purchase order information to the purchase orders table. C. Displays the vendor ID and the sum of all purchase order totals for that vendor. D. Displays all purchase order lines for all vendors.

C. Displays the vendor ID and the sum of all purchase order totals for that vendor.

What kind of data model is most commonly used in today's business environment? A. Network data model. B. Hierarchical data model. C. Relational data model. D. All of these choices are correct.

C. Relational data model.

Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction? A. Production Planning and Control. B. Materials Management. C. Sales and Distribution. D. Logistics Execution.

C. Sales and Distribution.

Which type of data models allows each record to have multiple parent and child records? A. The relational model. B. The hierarchical mode. C. The network model. D. None of these choices is correct.

C. The network model.

Which of the following resources is usually not modeled as an entity (table) in an REA data model? A. Property, plant and equipment. B. Inventory. C. Cash. D. Accounts receivable.

D. Accounts receivable.

A Query in a program language can be used to: A. Update data. B. Retrieve data. C. Report data. D. All of these choices are correct.

D. All of these choices are correct.

Which of the following is considered a class in the relational database model? A. Cash. B. Customer. C. Sale. D. All of these choices are correct.

D. All of these choices are correct.

To convert a conceptual model with a maximum Multiplicities relationship of "many to many" into relationship database tables, one must: A. Create a relation with no attributes of its own. B. Create a foreign key in one of the tables to link the two tables. C. Many-to-many relationship cannot be represented in Access. D. Create a relationship table to handle the many-to-many relationship.

D. Create a relationship table to handle the many-to-many relationship.

Which of the following items does not represent a UML class diagram object and its resulting database object? A. Classes → Tables. B. Associations → Relationships. C. Attributes → Fields. D. Multiplicities → Records.

D. Multiplicities → Records.

Which of the following is not a potential disadvantage of using cloud computing to host an organization's ERP? A. Uncertainty about the data security of sensitive information hosted offsite. B. Uncertainty about the adequacy of the host's processing speed and availability. C. Requires a reliable Internet connection. D. Reduced internal processing and storage needs for the organization.

D. Reduced internal processing and storage needs for the organization.

Which of the following is not one of the objects used in Microsoft Access? A. Forms. B. Macros. C. Tables. D. Sites.

D. Sites.

Which of the following best describes a DBMS? A. The manager(s) in charge of a company's databases. B. A language used to retrieve data from databases. C. A database created using Microsoft software. D. Software that can create, modify and query databases.

D. Software that can create, modify and query databases.

Access offers modules, which are defined by users to automate processes like opening a specific form. True False

False

Classes could be grouped into Resources (R), Entities (E), and Assets (A) in data modeling. True False

False

Each attribute in a table can have several names. True False

False

In Access, users can edit database information in reports. True False

False

In a hierarchical data model, data elements are related in many-to-many relationships. True False

False

Queries in Access are utilized by users to enter data into tables and view existing records. True False

False

The SQL command "Group by" can be used to order an amount in a descending order. True False

False

Access is a simple database management system that can be used to run databases for individuals and small firms. True False

True

Cloud computing is an internet-based computing where shared resources, software, and information is provided to firms on demand. True False

True

In a database, while queries allow the user to access, read and report on desired data, the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS). True False

True

SQL is based on relational algebra and allows a user to query and update the database. True False

True

The "Where" SQL clause can be used to link two tables. True False

True

The asterisk (*) following the SELECT SQL statement is a wild card indicating all columns should be selected. True False

True

Three types of data models used today are: the hierarchical model, the network model and the relational model. True False

True

While hierarchical and network data models require relationships to be formed at the database creation, relational data models allow relationships to be created and updated as needed. True False

True