Exam 4: Relational Databases and Enterprise System

In Microsoft Access, we use "Tables" for: A. Data entry B. Data storage C. Date retrieve D. Two of the above

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 foreign key value must be null C. A record's primary key must have a data value D. All values of an attribute must be of the same data type

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

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

In Microsoft Access, we use "Forms" for A. Data entry B. Data storage C. Date retrieve D. Two of the above

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

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

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

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 (1..1) - Sale (1..1) B. Cash Receipts (1..N) - Sale (0..N) C. Cash Receipts (1..1) - Sale (N..M) D. Cash Receipts (0..N) - Sale (1..1)

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

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

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

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..N) B. Cash Collection (1..N) - Sale (1..1) C. Cash Collection (1..N) - Sale (1..1) D. Cash Collection (1..1) - Sale (1..1)

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

What are the benefits of implementing enterprise systems in companies?

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

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

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

What kind data model is most commonly used HYPERLINK "http://www.whatis.com/relation.htm" as a basis for today's enterprise systems? A. The hierarchical mode B. The network model C. The relational model D. None of the above

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).