chapter 4

Question 1

Which type of data models allows each record to have multiple parent and child records

Answer 1

The network model

Question 2

Which of the following correctly describes the Referential Integrity Rule

Answer 2

The data value for a foreign key could be null

Question 3

Which of the following tasks cannot be performed through queries in access

Answer 3

Enter data into tables

Question 4

In Microsoft Access, we use tables in a database for

Answer 4

Data storage

Question 5

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

Answer 5

An enterprise resource planning system

Question 6

An enterprise resource planning system has which of the following advantages over multiple independent functional systems

Answer 6

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

Question 7

What kind data model is most commonly used as a basis for today’s enterprise systems

Answer 7

The relational model

Question 8

The property of the primary key in a table in Microsoft Access should be set to

Answer 8

The required field = “Yes”, the Indexed field = “Yes (No Duplicates)

Question 9

Which of the following is considered as class in the relational database model

Answer 9

All of the above are correct

Question 10

Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction

Answer 10

Sales and Distribution

Question 11

Which of the following statements about the requirements of table design is incorrect

Answer 11

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

Question 12

To convert a conceptual model with a maximum Multiplicities relationship of “many to many” into relationship database tables, one must

Answer 12

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

Question 13

Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales

Answer 13

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

Question 14

A Query in a program language can be used to

Answer 14

All of the above

Question 15

In Microsoft Access, we use “Forms” for

Answer 15

Date entry

Question 16

In Microsoft Access, we use “Tables” for

Answer 16

Data storage

Question 17

Which of the following is not a type of data model

Answer 17

Normalization data model

Question 18

What kind of data models is most commonly used in today’s business environment

Answer 18

Relational data model

Question 19

Which of the following about cloud computing is incorrect

Answer 19

Clients using cloud computing do not need to periodically backup data

Question 20

What is the main purpose of using foreign keys in a relational database design

Answer 20

It is used to link tables

Question 21

Which of the following about SQL is incorrect

Answer 21

SQL is very user-friendly

Question 22

Which of the following items can best be described as a “Resource” in the REA data model

Answer 22

Cash

Question 23

Which of the following items can best be described as an “Event” in the REA data model

Answer 23

Cash collection

Question 24

Which of the following items can best be described as an “Agent” in the REA data model

Answer 24

Accounts payable clerk

Question 25

Which of the following resources is usually not modeled as an entity (table) in an REA data model

Answer 25

Accounts receivable